Saturday, February 25, 2012

"Creating a Mobile Application with SQL Server" Tutorial Problem

I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error:

TITLE: Microsoft SQL Server Management Studio

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)

One potential area of concern is in setting up the windows authentication login. Step two of "Secure the publication" states "type computername\iusr_computername, where computername is the name of your computer." I was not sure what iusr_computername stood for--should I just type in my windows account for this machine? Or am I to make an account called "isur_computername?"

I just restarted my system and now receive a different error (at the same place):

TITLE: Microsoft SQL Server Management Studio

Authentication failed on the computer running IIS.
HRESULT 0x80070057 (28011)

|||

Hi,

IUSR_<IISMachineName> is an account automatically built-in and would be created automatically when IIS is installed. This is the login account that would be used when you chose the authentication as anonymous. Simply to say, this is anonymous user account. Ofcourse, you can change IIS to use a different account as anonymous account. Now, please replace the 'IISMachineName' with IIS Machine name in your environment and assign permissions to this IUSR account on Virtual Directory (read & write, create and delete files).

Hope this helps!

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||I'm having the same problem when I try to use a subscription for MS SQL 2005 I get the same error message. I have tried to use different account including the IUSR_<machinename> but have the same problem.|||

Hi keyboardape. Did you solve your problem?

I met the same issue like your and I solved it today.

Let me know

|||

I am getting this same message! I'm trying to get the AdventureWorks merge replication sample using a mobile device to work.

I have tried both anonymous and authenticated and used various users. Any help? Thanks!

|||

Hi Nick, what was the solution?

initially I had the exactly same error as jonfroehlich ...

the walkthrough goes fine until step 10 of 'create a new subscripition' then it just fails and gives the following error:

--

Failure to connect to SQL Server with provided connection information.
SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
The operation could not be completed.

--

but after running it again the error msg has changed to ...

--

Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)
The process could not connect to Distributor '<mycomputername>.
HRESULT 0x00004E74 (0)The operation could not be completed.
--

I created a new iusr_<computername> account as directed in the walkthrough and have assigned it accordingly...

can you help?

Thanks

|||Hi there
as Laxmi suggested, you do have to set up the IIS and the authentication correctly
try the following:
1. after creating your publication on the management studio, add the user IUSR_<IISMachineName> in the security->login folder
Important: you don't have to create that user, this user already exist, so look it up under advanced search!!
2. rightclick on that user and choose properties
3. under usermappings check the box of the database you would like to access, then click ok
4. rightclick on your publication and choose properties
5. select publication access list an add the IUSR_<IISMachineName> user and click ok
6. rightclick on your publication, select view snapshot status and generate the snapshot

7. execute the web synchronisation wizard (conwizz30.exe) before the subscription wizard!!
this wizard creates the virtual directory for the webaccess, choose annonymous access
8. execute the subscription wizard and use windowsauthentication

the following link helps a lot:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true

by the way, check the port (settigns-Controlpanel-administrativetool-iis) of your IIS (default is 80) but it might be possible that it's not (if you use skype or such appilations)
if it's not 80 you have to add the port to the url in the WebServer Authentication Step of the Subscription Wizard like 192.168.0.111:81/myVirtDir

Hop it helps
Greets Florian
|||

In my case, I got a very similar error message while trying to use SQL server authentication with the 'sa' account.

- Synchronizing Data (100%) (Error)

Messages

* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29060)

It turned out sa account was disabled by default.

|||

I have the same problem. The fix of Florian did not help me.

Any suggestion?

Thanks

GIo

|||

It is Correct.

Thanks. I got the solution. I have created a Word Document to configure step by step.

But, I dont know how to upload it here to help others.

|||

Hi,

Previously I was using Sql mobile in device, that was worked fine with SQL Server 2005. Now as per client's requirement they want the Database in sql ce and sql server 2000.

First of all I would like to know that which are the required cab files for sql ce environment in the device and from where i can get those?

When i see the merge agent, it is connecting Sql server 2000 from sql mobile and it is able to connect the sql server 2000 publisher, but after connecting to publisher when it tries to connect the subscriber it stops with message "Connecting to subscriber WM_Dhaval1". after waiting for 10 minutes the message changes to "The agent is suspect, no response within last 10 minutes" with failed satus. I am sure the problem is with subscriber.

Is sql mobile compatible with sql server 2000? or i have to use sql ce for mobile device explicitely?

|||Was having the same issue. I believe it is caused because I have multiple network cards.

I got this tutorial working, when in the wizard to create a new subscription on the page "choose publication" I selected the aktual server name (my pc name) rather than (local). Then it worked for me.

good luck
|||I have the same problem, each time to subscribe the subscription said that the IIS user is not valid SQL Server user. When I create publication on Windows XP the problem is solved, but when I try on Vista the problem go back again. I have create SQL Server login for IUSR and put it into Publication Access List (PAL) of my publication. Is there any user that I must include for IIS 7 or only IUSR.

Sorry I'm really new on discovering IIS 7, for IIS 6 just fine for me.

Thanks,

"Creating a Mobile Application with SQL Server" Tutorial Problem

I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error:

TITLE: Microsoft SQL Server Management Studio

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)

One potential area of concern is in setting up the windows authentication login. Step two of "Secure the publication" states "type computername\iusr_computername, where computername is the name of your computer." I was not sure what iusr_computername stood for--should I just type in my windows account for this machine? Or am I to make an account called "isur_computername?"

I just restarted my system and now receive a different error (at the same place):

TITLE: Microsoft SQL Server Management Studio

Authentication failed on the computer running IIS.
HRESULT 0x80070057 (28011)

|||

Hi,

IUSR_<IISMachineName> is an account automatically built-in and would be created automatically when IIS is installed. This is the login account that would be used when you chose the authentication as anonymous. Simply to say, this is anonymous user account. Ofcourse, you can change IIS to use a different account as anonymous account. Now, please replace the 'IISMachineName' with IIS Machine name in your environment and assign permissions to this IUSR account on Virtual Directory (read & write, create and delete files).

Hope this helps!

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||I'm having the same problem when I try to use a subscription for MS SQL 2005 I get the same error message. I have tried to use different account including the IUSR_<machinename> but have the same problem.|||

Hi keyboardape. Did you solve your problem?

I met the same issue like your and I solved it today.

Let me know

|||

I am getting this same message! I'm trying to get the AdventureWorks merge replication sample using a mobile device to work.

I have tried both anonymous and authenticated and used various users. Any help? Thanks!

|||

Hi Nick, what was the solution?

initially I had the exactly same error as jonfroehlich ...

the walkthrough goes fine until step 10 of 'create a new subscripition' then it just fails and gives the following error:

--

Failure to connect to SQL Server with provided connection information.
SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
The operation could not be completed.

--

but after running it again the error msg has changed to ...

--

Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)
The process could not connect to Distributor '<mycomputername>.
HRESULT 0x00004E74 (0)The operation could not be completed.
--

I created a new iusr_<computername> account as directed in the walkthrough and have assigned it accordingly...

can you help?

Thanks

|||Hi there
as Laxmi suggested, you do have to set up the IIS and the authentication correctly
try the following:
1. after creating your publication on the management studio, add the user IUSR_<IISMachineName> in the security->login folder
Important: you don't have to create that user, this user already exist, so look it up under advanced search!!
2. rightclick on that user and choose properties
3. under usermappings check the box of the database you would like to access, then click ok
4. rightclick on your publication and choose properties
5. select publication access list an add the IUSR_<IISMachineName> user and click ok
6. rightclick on your publication, select view snapshot status and generate the snapshot

7. execute the web synchronisation wizard (conwizz30.exe) before the subscription wizard!!
this wizard creates the virtual directory for the webaccess, choose annonymous access
8. execute the subscription wizard and use windowsauthentication

the following link helps a lot:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true

by the way, check the port (settigns-Controlpanel-administrativetool-iis) of your IIS (default is 80) but it might be possible that it's not (if you use skype or such appilations)
if it's not 80 you have to add the port to the url in the WebServer Authentication Step of the Subscription Wizard like 192.168.0.111:81/myVirtDir

Hop it helps
Greets Florian
|||

In my case, I got a very similar error message while trying to use SQL server authentication with the 'sa' account.

- Synchronizing Data (100%) (Error)

Messages

* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29060)

It turned out sa account was disabled by default.

|||

I have the same problem. The fix of Florian did not help me.

Any suggestion?

Thanks

GIo

|||

It is Correct.

Thanks. I got the solution. I have created a Word Document to configure step by step.

But, I dont know how to upload it here to help others.

|||

Hi,

Previously I was using Sql mobile in device, that was worked fine with SQL Server 2005. Now as per client's requirement they want the Database in sql ce and sql server 2000.

First of all I would like to know that which are the required cab files for sql ce environment in the device and from where i can get those?

When i see the merge agent, it is connecting Sql server 2000 from sql mobile and it is able to connect the sql server 2000 publisher, but after connecting to publisher when it tries to connect the subscriber it stops with message "Connecting to subscriber WM_Dhaval1". after waiting for 10 minutes the message changes to "The agent is suspect, no response within last 10 minutes" with failed satus. I am sure the problem is with subscriber.

Is sql mobile compatible with sql server 2000? or i have to use sql ce for mobile device explicitely?

|||Was having the same issue. I believe it is caused because I have multiple network cards.

I got this tutorial working, when in the wizard to create a new subscription on the page "choose publication" I selected the aktual server name (my pc name) rather than (local). Then it worked for me.

good luck
|||I have the same problem, each time to subscribe the subscription said that the IIS user is not valid SQL Server user. When I create publication on Windows XP the problem is solved, but when I try on Vista the problem go back again. I have create SQL Server login for IUSR and put it into Publication Access List (PAL) of my publication. Is there any user that I must include for IIS 7 or only IUSR.

Sorry I'm really new on discovering IIS 7, for IIS 6 just fine for me.

Thanks,

"Creating a Mobile Application with SQL Server" Tutorial Problem

I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error:

TITLE: Microsoft SQL Server Management Studio

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)

One potential area of concern is in setting up the windows authentication login. Step two of "Secure the publication" states "type computername\iusr_computername, where computername is the name of your computer." I was not sure what iusr_computername stood for--should I just type in my windows account for this machine? Or am I to make an account called "isur_computername?"

I just restarted my system and now receive a different error (at the same place):

TITLE: Microsoft SQL Server Management Studio

Authentication failed on the computer running IIS.
HRESULT 0x80070057 (28011)

|||

Hi,

IUSR_<IISMachineName> is an account automatically built-in and would be created automatically when IIS is installed. This is the login account that would be used when you chose the authentication as anonymous. Simply to say, this is anonymous user account. Ofcourse, you can change IIS to use a different account as anonymous account. Now, please replace the 'IISMachineName' with IIS Machine name in your environment and assign permissions to this IUSR account on Virtual Directory (read & write, create and delete files).

Hope this helps!

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||I'm having the same problem when I try to use a subscription for MS SQL 2005 I get the same error message. I have tried to use different account including the IUSR_<machinename> but have the same problem.|||

Hi keyboardape. Did you solve your problem?

I met the same issue like your and I solved it today.

Let me know

|||

I am getting this same message! I'm trying to get the AdventureWorks merge replication sample using a mobile device to work.

I have tried both anonymous and authenticated and used various users. Any help? Thanks!

|||

Hi Nick, what was the solution?

initially I had the exactly same error as jonfroehlich ...

the walkthrough goes fine until step 10 of 'create a new subscripition' then it just fails and gives the following error:

--

Failure to connect to SQL Server with provided connection information.
SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
The operation could not be completed.

--

but after running it again the error msg has changed to ...

--

Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)
The process could not connect to Distributor '<mycomputername>.
HRESULT 0x00004E74 (0)The operation could not be completed.
--

I created a new iusr_<computername> account as directed in the walkthrough and have assigned it accordingly...

can you help?

Thanks

|||Hi there
as Laxmi suggested, you do have to set up the IIS and the authentication correctly
try the following:
1. after creating your publication on the management studio, add the user IUSR_<IISMachineName> in the security->login folder
Important: you don't have to create that user, this user already exist, so look it up under advanced search!!
2. rightclick on that user and choose properties
3. under usermappings check the box of the database you would like to access, then click ok
4. rightclick on your publication and choose properties
5. select publication access list an add the IUSR_<IISMachineName> user and click ok
6. rightclick on your publication, select view snapshot status and generate the snapshot

7. execute the web synchronisation wizard (conwizz30.exe) before the subscription wizard!!
this wizard creates the virtual directory for the webaccess, choose annonymous access
8. execute the subscription wizard and use windowsauthentication

the following link helps a lot:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true

by the way, check the port (settigns-Controlpanel-administrativetool-iis) of your IIS (default is 80) but it might be possible that it's not (if you use skype or such appilations)
if it's not 80 you have to add the port to the url in the WebServer Authentication Step of the Subscription Wizard like 192.168.0.111:81/myVirtDir

Hop it helps
Greets Florian|||

In my case, I got a very similar error message while trying to use SQL server authentication with the 'sa' account.

- Synchronizing Data (100%) (Error)

Messages

* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29060)

It turned out sa account was disabled by default.

|||

I have the same problem. The fix of Florian did not help me.

Any suggestion?

Thanks

GIo

|||

It is Correct.

Thanks. I got the solution. I have created a Word Document to configure step by step.

But, I dont know how to upload it here to help others.

|||

Hi,

Previously I was using Sql mobile in device, that was worked fine with SQL Server 2005. Now as per client's requirement they want the Database in sql ce and sql server 2000.

First of all I would like to know that which are the required cab files for sql ce environment in the device and from where i can get those?

When i see the merge agent, it is connecting Sql server 2000 from sql mobile and it is able to connect the sql server 2000 publisher, but after connecting to publisher when it tries to connect the subscriber it stops with message "Connecting to subscriber WM_Dhaval1". after waiting for 10 minutes the message changes to "The agent is suspect, no response within last 10 minutes" with failed satus. I am sure the problem is with subscriber.

Is sql mobile compatible with sql server 2000? or i have to use sql ce for mobile device explicitely?

|||Was having the same issue. I believe it is caused because I have multiple network cards.

I got this tutorial working, when in the wizard to create a new subscription on the page "choose publication" I selected the aktual server name (my pc name) rather than (local). Then it worked for me.

good luck|||I have the same problem, each time to subscribe the subscription said that the IIS user is not valid SQL Server user. When I create publication on Windows XP the problem is solved, but when I try on Vista the problem go back again. I have create SQL Server login for IUSR and put it into Publication Access List (PAL) of my publication. Is there any user that I must include for IIS 7 or only IUSR.

Sorry I'm really new on discovering IIS 7, for IIS 6 just fine for me.

Thanks,

"Creating a Mobile Application with SQL Server" Tutorial Problem

I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error:

TITLE: Microsoft SQL Server Management Studio

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)

One potential area of concern is in setting up the windows authentication login. Step two of "Secure the publication" states "type computername\iusr_computername, where computername is the name of your computer." I was not sure what iusr_computername stood for--should I just type in my windows account for this machine? Or am I to make an account called "isur_computername?"

I just restarted my system and now receive a different error (at the same place):

TITLE: Microsoft SQL Server Management Studio

Authentication failed on the computer running IIS.
HRESULT 0x80070057 (28011)

|||

Hi,

IUSR_<IISMachineName> is an account automatically built-in and would be created automatically when IIS is installed. This is the login account that would be used when you chose the authentication as anonymous. Simply to say, this is anonymous user account. Ofcourse, you can change IIS to use a different account as anonymous account. Now, please replace the 'IISMachineName' with IIS Machine name in your environment and assign permissions to this IUSR account on Virtual Directory (read & write, create and delete files).

Hope this helps!

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||I'm having the same problem when I try to use a subscription for MS SQL 2005 I get the same error message. I have tried to use different account including the IUSR_<machinename> but have the same problem.|||

Hi keyboardape. Did you solve your problem?

I met the same issue like your and I solved it today.

Let me know

|||

I am getting this same message! I'm trying to get the AdventureWorks merge replication sample using a mobile device to work.

I have tried both anonymous and authenticated and used various users. Any help? Thanks!

|||

Hi Nick, what was the solution?

initially I had the exactly same error as jonfroehlich ...

the walkthrough goes fine until step 10 of 'create a new subscripition' then it just fails and gives the following error:

--

Failure to connect to SQL Server with provided connection information.
SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
The operation could not be completed.

--

but after running it again the error msg has changed to ...

--

Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)
The process could not connect to Distributor '<mycomputername>.
HRESULT 0x00004E74 (0)The operation could not be completed.
--

I created a new iusr_<computername> account as directed in the walkthrough and have assigned it accordingly...

can you help?

Thanks

|||Hi there
as Laxmi suggested, you do have to set up the IIS and the authentication correctly
try the following:
1. after creating your publication on the management studio, add the user IUSR_<IISMachineName> in the security->login folder
Important: you don't have to create that user, this user already exist, so look it up under advanced search!!
2. rightclick on that user and choose properties
3. under usermappings check the box of the database you would like to access, then click ok
4. rightclick on your publication and choose properties
5. select publication access list an add the IUSR_<IISMachineName> user and click ok
6. rightclick on your publication, select view snapshot status and generate the snapshot

7. execute the web synchronisation wizard (conwizz30.exe) before the subscription wizard!!
this wizard creates the virtual directory for the webaccess, choose annonymous access
8. execute the subscription wizard and use windowsauthentication

the following link helps a lot:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true

by the way, check the port (settigns-Controlpanel-administrativetool-iis) of your IIS (default is 80) but it might be possible that it's not (if you use skype or such appilations)
if it's not 80 you have to add the port to the url in the WebServer Authentication Step of the Subscription Wizard like 192.168.0.111:81/myVirtDir

Hop it helps
Greets Florian|||

In my case, I got a very similar error message while trying to use SQL server authentication with the 'sa' account.

- Synchronizing Data (100%) (Error)

Messages

* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29060)

It turned out sa account was disabled by default.

|||

I have the same problem. The fix of Florian did not help me.

Any suggestion?

Thanks

GIo

|||

It is Correct.

Thanks. I got the solution. I have created a Word Document to configure step by step.

But, I dont know how to upload it here to help others.

|||

Hi,

Previously I was using Sql mobile in device, that was worked fine with SQL Server 2005. Now as per client's requirement they want the Database in sql ce and sql server 2000.

First of all I would like to know that which are the required cab files for sql ce environment in the device and from where i can get those?

When i see the merge agent, it is connecting Sql server 2000 from sql mobile and it is able to connect the sql server 2000 publisher, but after connecting to publisher when it tries to connect the subscriber it stops with message "Connecting to subscriber WM_Dhaval1". after waiting for 10 minutes the message changes to "The agent is suspect, no response within last 10 minutes" with failed satus. I am sure the problem is with subscriber.

Is sql mobile compatible with sql server 2000? or i have to use sql ce for mobile device explicitely?

|||Was having the same issue. I believe it is caused because I have multiple network cards.

I got this tutorial working, when in the wizard to create a new subscription on the page "choose publication" I selected the aktual server name (my pc name) rather than (local). Then it worked for me.

good luck|||I have the same problem, each time to subscribe the subscription said that the IIS user is not valid SQL Server user. When I create publication on Windows XP the problem is solved, but when I try on Vista the problem go back again. I have create SQL Server login for IUSR and put it into Publication Access List (PAL) of my publication. Is there any user that I must include for IIS 7 or only IUSR.

Sorry I'm really new on discovering IIS 7, for IIS 6 just fine for me.

Thanks,

"Creating a Mobile Application with SQL Server" Tutorial Problem

I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error:

TITLE: Microsoft SQL Server Management Studio

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)

One potential area of concern is in setting up the windows authentication login. Step two of "Secure the publication" states "type computername\iusr_computername, where computername is the name of your computer." I was not sure what iusr_computername stood for--should I just type in my windows account for this machine? Or am I to make an account called "isur_computername?"

I just restarted my system and now receive a different error (at the same place):

TITLE: Microsoft SQL Server Management Studio

Authentication failed on the computer running IIS.
HRESULT 0x80070057 (28011)

|||

Hi,

IUSR_<IISMachineName> is an account automatically built-in and would be created automatically when IIS is installed. This is the login account that would be used when you chose the authentication as anonymous. Simply to say, this is anonymous user account. Ofcourse, you can change IIS to use a different account as anonymous account. Now, please replace the 'IISMachineName' with IIS Machine name in your environment and assign permissions to this IUSR account on Virtual Directory (read & write, create and delete files).

Hope this helps!

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||I'm having the same problem when I try to use a subscription for MS SQL 2005 I get the same error message. I have tried to use different account including the IUSR_<machinename> but have the same problem.|||

Hi keyboardape. Did you solve your problem?

I met the same issue like your and I solved it today.

Let me know

|||

I am getting this same message! I'm trying to get the AdventureWorks merge replication sample using a mobile device to work.

I have tried both anonymous and authenticated and used various users. Any help? Thanks!

|||

Hi Nick, what was the solution?

initially I had the exactly same error as jonfroehlich ...

the walkthrough goes fine until step 10 of 'create a new subscripition' then it just fails and gives the following error:

--

Failure to connect to SQL Server with provided connection information.
SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
The operation could not be completed.

--

but after running it again the error msg has changed to ...

--

Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)
The process could not connect to Distributor '<mycomputername>.
HRESULT 0x00004E74 (0)The operation could not be completed.
--

I created a new iusr_<computername> account as directed in the walkthrough and have assigned it accordingly...

can you help?

Thanks

|||Hi there
as Laxmi suggested, you do have to set up the IIS and the authentication correctly
try the following:
1. after creating your publication on the management studio, add the user IUSR_<IISMachineName> in the security->login folder
Important: you don't have to create that user, this user already exist, so look it up under advanced search!!
2. rightclick on that user and choose properties
3. under usermappings check the box of the database you would like to access, then click ok
4. rightclick on your publication and choose properties
5. select publication access list an add the IUSR_<IISMachineName> user and click ok
6. rightclick on your publication, select view snapshot status and generate the snapshot

7. execute the web synchronisation wizard (conwizz30.exe) before the subscription wizard!!
this wizard creates the virtual directory for the webaccess, choose annonymous access
8. execute the subscription wizard and use windowsauthentication

the following link helps a lot:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true

by the way, check the port (settigns-Controlpanel-administrativetool-iis) of your IIS (default is 80) but it might be possible that it's not (if you use skype or such appilations)
if it's not 80 you have to add the port to the url in the WebServer Authentication Step of the Subscription Wizard like 192.168.0.111:81/myVirtDir

Hop it helps
Greets Florian
|||

In my case, I got a very similar error message while trying to use SQL server authentication with the 'sa' account.

- Synchronizing Data (100%) (Error)

Messages

* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29060)

It turned out sa account was disabled by default.

|||

I have the same problem. The fix of Florian did not help me.

Any suggestion?

Thanks

GIo

|||

It is Correct.

Thanks. I got the solution. I have created a Word Document to configure step by step.

But, I dont know how to upload it here to help others.

|||

Hi,

Previously I was using Sql mobile in device, that was worked fine with SQL Server 2005. Now as per client's requirement they want the Database in sql ce and sql server 2000.

First of all I would like to know that which are the required cab files for sql ce environment in the device and from where i can get those?

When i see the merge agent, it is connecting Sql server 2000 from sql mobile and it is able to connect the sql server 2000 publisher, but after connecting to publisher when it tries to connect the subscriber it stops with message "Connecting to subscriber WM_Dhaval1". after waiting for 10 minutes the message changes to "The agent is suspect, no response within last 10 minutes" with failed satus. I am sure the problem is with subscriber.

Is sql mobile compatible with sql server 2000? or i have to use sql ce for mobile device explicitely?

|||Was having the same issue. I believe it is caused because I have multiple network cards.

I got this tutorial working, when in the wizard to create a new subscription on the page "choose publication" I selected the aktual server name (my pc name) rather than (local). Then it worked for me.

good luck
|||I have the same problem, each time to subscribe the subscription said that the IIS user is not valid SQL Server user. When I create publication on Windows XP the problem is solved, but when I try on Vista the problem go back again. I have create SQL Server login for IUSR and put it into Publication Access List (PAL) of my publication. Is there any user that I must include for IIS 7 or only IUSR.

Sorry I'm really new on discovering IIS 7, for IIS 6 just fine for me.

Thanks,

"CREATE OR ALTER" works in oracle, but not in ms sql

Hi

Normally we deliver scripts and the installers may NOT update the scripts.

This was fine for SQL scripts for oracle: because we are not aware of the situation in production, whether a stored proc was already previously installed or not.

therefore we wrote:

CREATE OR ALTER PROCEDURE ....... (or something like that).

but it seems in SQL server I can only write one of both:

CREATE PROCEDURE ....

or

ALTER PROCEDURE

this means that the script fails if it's NOT yet installed when and i use ALTER, and it fails when it IS already installed and I write CREATE

isn't there a solution to use "CREATE OR ALTER" in one script ?

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'myStoredProc' AND type = 'P')

BEGIN

DROP PROCEDURE myStoredProc

END

GO

CREATE PROCEDURE myStoredProc (@.Params ...)

AS

BEGIN

...

END

GO

"Create a Grants Rights Script" error in rs db configaration

Hi,

While I'm trying to configure rs db configuration, I’m getting "Create a Grants Rights Script" error when I click Apply button in rs configuration UI.

For this setup; I’m using 32-bit rs on 64-bit windows 2003 server and trying to connect 64-bit sql db instance on a different 64-bit box . both boxes are in same windows domain. I could also able to create rs db from rs configuration UI successfully. I'm using sql sa credentials and installed SQL SP1 on both boxes. Pl let me know how to fix this error.

Complate error message is,

System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)

Thanks in advance

Ram

did you ever resolve this problem. I'm gettnig the same error.|||

Hi Greg,

I would suggest to start from here:

http://msdn2.microsoft.com/en-us/library/ms365170.aspx

http://msdn2.microsoft.com/en-us/library/ms159093.aspx

Mihaela

"Create a Grants Rights Script" error in rs db configaration

Hi,

While I'm trying to configure rs db configuration, I’m getting "Create a Grants Rights Script" error when I click Apply button in rs configuration UI.

For this setup; I’m using 32-bit rs on 64-bit windows 2003 server and trying to connect 64-bit sql db instance on a different 64-bit box . both boxes are in same windows domain. I could also able to create rs db from rs configuration UI successfully. I'm using sql sa credentials and installed SQL SP1 on both boxes. Pl let me know how to fix this error.

Complate error message is,

System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)

Thanks in advance

Ram

did you ever resolve this problem. I'm gettnig the same error.|||

Hi Greg,

I would suggest to start from here:

http://msdn2.microsoft.com/en-us/library/ms365170.aspx

http://msdn2.microsoft.com/en-us/library/ms159093.aspx

Mihaela

"Could not start the SQL Server Integration Services..."

Running MS SQL 2005 SP1 on Windows 2003 Server SP1 (IA32). Upon rebooting, I get an error that this service failed to start, and when I attempt to start manually, I get the same error:

Could not start the SQL Server Integration Services service on the Local Computer.

Error 1053: The service did not respond to the start or control request in a timely fashion.

Any ideas?

Have you looed at http://support.microsoft.com/kb/886695/ ?


Thanks,
Ovidiu Burlacu

|||I also recommend this one - http://support.microsoft.com/kb/918644 :)

"Could not open SQLEVN70.RLL"

"Your SQL Server installation is eigher corrupt or has been tampered with (could not open SQLEVN70.rll). Please uninstall then re-run Setup to correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard


I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard


No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your SQL Server installation is eigher corrupt or has been tampered with (could not open SQLEVN70.rll). Please uninstall then re-run Setup to correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard


I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard


No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your

SQL Server installation is eigher corrupt or has been tampered with

(could not open SQLEVN70.rll). Please uninstall then re-run Setup to

correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard


I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard


No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your

SQL Server installation is eigher corrupt or has been tampered with

(could not open SQLEVN70.rll). Please uninstall then re-run Setup to

correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard


I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard


No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your

SQL Server installation is eigher corrupt or has been tampered with

(could not open SQLEVN70.rll). Please uninstall then re-run Setup to

correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard


I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard


No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your SQL Server installation is eigher corrupt or has been tampered with (could not open SQLEVN70.rll). Please uninstall then re-run Setup to correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard


I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard


No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your

SQL Server installation is eigher corrupt or has been tampered with

(could not open SQLEVN70.rll). Please uninstall then re-run Setup to

correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard


I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard


No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"could not open connection to SQL Server"?

I just installed a new SQL 2005 Server (September CTP - Developer Edition) on Windows Server 2003 (Using Virtual PC).

I have created a Data Model to be used for creating reports. When I tried to deploy the Model, I got an error along the lines of "...SQL Server does not allow remote connections...".

I then took a step back and tried to browse the report server (http://localhost/reportserver) and I got the message below:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I also notice that when I go into the Reporting Services Configuration Manager, I see that the Initialization item in the left hand side is Not Configured (has a "red x"). When I try clicking on this item, I get a similar message to the one above.

I am very new at SQL 2005 and this is my first install of it (I have been using other installations in the past). I did some searching and found that I should use the SQL Server Surface Area Configuration utility to allow remote connections for both TCP and Named Pipes. I did this and rebooted my server and I am still getting the same error messages.

Is there something I have yet to configure?

Any and all help is very much appreciated!!!

Thanks!

Brian McCulloughRight after I posted this I realized I renamed the Computer after I installed SQL. The problem was that when I installed reporting services, it created all the connection information based on the "old" computer name.

Brian|||What did you have to do to fix it? Where is the connection information?|||In the Reporting Services Configuration Manager select the Database Setup item on the left-hand side. This is where you specify the Database connection properties for the ReportServer database. I had to change the Server Name to match the current machine name, not what I had it as originally.

-Brian|||I had a similar problem - I was able to fix it by specifying my server as computer-name\servername
Hope this helps

"could not open connection to SQL Server"?

I just installed a new SQL 2005 Server (September CTP - Developer Edition) on Windows Server 2003 (Using Virtual PC).

I have created a Data Model to be used for creating reports. When I tried to deploy the Model, I got an error along the lines of "...SQL Server does not allow remote connections...".

I then took a step back and tried to browse the report server (http://localhost/reportserver) and I got the message below:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I also notice that when I go into the Reporting Services Configuration Manager, I see that the Initialization item in the left hand side is Not Configured (has a "red x"). When I try clicking on this item, I get a similar message to the one above.

I am very new at SQL 2005 and this is my first install of it (I have been using other installations in the past). I did some searching and found that I should use the SQL Server Surface Area Configuration utility to allow remote connections for both TCP and Named Pipes. I did this and rebooted my server and I am still getting the same error messages.

Is there something I have yet to configure?

Any and all help is very much appreciated!!!

Thanks!

Brian McCulloughRight after I posted this I realized I renamed the Computer after I installed SQL. The problem was that when I installed reporting services, it created all the connection information based on the "old" computer name.

Brian|||What did you have to do to fix it? Where is the connection information?|||In the Reporting Services Configuration Manager select the Database Setup item on the left-hand side. This is where you specify the Database connection properties for the ReportServer database. I had to change the Server Name to match the current machine name, not what I had it as originally.

-Brian|||I had a similar problem - I was able to fix it by specifying my server as computer-name\servername
Hope this helps

"Could not find schema information ..." error in XSD annotation

When I open any annotated schema in VC# 2005 Express, I get the error:

"Could not find schema information for the attribute 'urn:schemas-microsoft-com:mapping-schema:relation'."

Am I missing a reference? MSXML4.0 and the SQL Client are installed on my workstation.

An example of one of the annotated schemas I've tried is this one, from Andrew Conrad's MSDN article "A Survey of Microsoft SQL Server 2000 XML Features":

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"

xmlns:sql="urn:schemas-microsoft-com:mapping-schema">

<xsd:element name="CustomerRecord" sql:relation="Customers" >

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Contact" sql:field="ContactName"

type="xsd:string" />

... etc. All references to sql:relation, sql:field and sql:relationship produce the same error.

How do you open it?

Thanks

Michael

|||I was opening the schema in the standard editor pane and then clicking on Show Errors in one of the drop-down menus (can't remember which one that is, now). I dumped VC# 2005 Express in favor of C# in VS 2003 Enterprise, which validates the same schema with no problem. The documentation which installed with the Express edition was clearly meant for the standard VS product, anyway, and, so far, schema handling in VS 2003 appears to work as advertised.

Best Regards,

Mike|||

I think the issue may be that the VC# 2005 editor by default expects all namespaces to have schemas associated. I am forwarding this to our schema editor experts to see what's going on.

Thanks

Michael

|||

The schema for these mapping annotations was not shipped in Visual Studio 2005. If you plop the following XSD schema into your "program files\visual studio 8\xml\schema" folder then the errors will go away:

<?xml version="1.0" encoding="utf-8" ?>

<xs:schema targetNamespace="urn:schemas-microsoft-com:mapping-schema"

elementFormDefault="qualified"

xmlns="urn:schemas-microsoft-com:mapping-schema"

xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:attribute name="encode" type="xs:anyURI">

<xs:annotation>

<xs:documentation>

When an XML element or attribute is mapped to a SQL Server BLOB column, allows requesting a reference URI. This URI can be used later to return BLOB data.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="field" type="xs:string">

<xs:annotation>

<xs:documentation>Maps an XML item to a database column.</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="guid" type="guid">

<xs:annotation>

<xs:documentation>

Allows you to specify whether to use a GUID value generated by SQL Server or use the value provided in the updategram for that column.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="hide" type="xs:boolean">

<xs:annotation>

<xs:documentation>

Hides the element or attribute that is specified in the schema in the resulting XML document.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="identity" type="guid">

<xs:annotation>

<xs:documentation>

Can be specified on any node that maps to an IDENTITY-type database column. The value specified for this annotation defines how the corresponding IDENTITY-type column in the database is updated.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="inverse" type="xs:boolean">

<xs:annotation>

<xs:documentation>

Instructs the updategram logic to inverse its interpretation of the parent-child relationship that has been specified using &lt;sql:relationship&gt;

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="is-constant" type="xs:boolean">

<xs:annotation>

<xs:documentation>

Creates an XML element that does not map to any table. The element appears in the query output.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="key-fields" type="xs:string">

<xs:annotation>

<xs:documentation>

Allows specification of column(s) that uniquely identify the rows in a table.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="limit-field" type="xs:string">

<xs:annotation>

<xs:documentation>

Allows limiting the values that are returned on the basis of a limiting value.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="limit-value" type="xs:string">

<xs:annotation>

<xs:documentation>

Allows limiting the values that are returned on the basis of a limiting value.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="mapped" type="xs:boolean">

<xs:annotation>

<xs:documentation>

Allows schema items to be excluded from the result.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="max-depth" type="xs:positiveInteger">

<xs:annotation>

<xs:documentation>

Allows you to specify depth in recursive relationships that are specified in the schema.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="overflow-field" type="xs:string">

<xs:annotation>

<xs:documentation>

Identifies the database column that contains the overflow data.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="prefix" type="xs:string">

<xs:annotation>

<xs:documentation>

Creates valid XML ID, IDREF, and IDREFS. Prepends the values of ID, IDREF, and IDREFS with a string.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="relation" type="xs:string">

<xs:annotation>

<xs:documentation>

Maps an XML item to a database table.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="relationship" type="xs:string">

<xs:annotation>

<xs:documentation>

Specifies relationships between XML elements. The parent, child, parent-key, and child-key attributes are used to establish the relationship.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:attribute name="use-cdata" type="xs:boolean">

<xs:annotation>

<xs:documentation>

Allows specifying CDATA sections to be used for certain elements in the XML document.

</xs:documentation>

</xs:annotation>

</xs:attribute>

<xs:simpleType name="guid">

<xs:restriction base="xs:string">

<xs:pattern value="\{[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}\}"/>

</xs:restriction>

</xs:simpleType>

</xs:schema>

|||Thanks, Chris. That makes perfect sense. I saved the schema and will use it if I try VS C# Express again.

Mike|||

Fine, but where in that folder should the schema be plopped?

Should I be able to deduce the file name from the info in the schema?

Or doesn't the fle name matter?

In that case, please explain the magic that allows it to be fetched in to cure the problem under discusssion

Regards,

Al

|||Al -

I'm no longer using VC# 2005 Express, but the schema name would be mapping-schema.xsd, and I think you would save it to the folder Program Files\Microsoft Visual Studio 8\Xml\Schemas.

There's probably a way to implicitly embed a xsi:schemaLocation directive in your annotated schema, so you could put the mapping-schema in your bin\Debug folder along with the program source files, but I can't figure out what such a directive would look like.

Good luck,

Mike
|||

What should the filename be?

|||

Did you ever find out how the file should be named? I am having the same endless messages and i would like to get rid of them.

Thanks,

|||

RoseD wrote:

Did you ever find out how the file should be named? I am having the same endless messages and i would like to get rid of them.

Thanks,

No. That is still a mystery, unfortunately.

It is absolutely ridiculous.

Releasing a service-pack or at least a patch would be VERY simple; but, the creators obviously have moved on to bigger and better things-- that is, sadly, pretty common for MS these days-- they move on to a new technology before they have fixed Version 1 of a release product. They keep adding bells-and-whistles but they often miss the core features. Oh well. They still have some of the best tools; I just wish there were a little more support for products by the way of services-packs, patches, and add-ons. In fact, I am sure they could have charged a nominal fee ($20, $50, even $100) for the Express tools and then they would have had a budget for product support.

Thank you.

-- Mark Kamoski

|||I wish I could give you a definitive answer, but as I said earlier, I switched to VS 2003 and the problem went away, so I never tried the solution proposed by Chris Lovett. Did you try naming the file "mapping-schema.xsd"? The full path would then be "Program Files\Visual Studio 8\xml\schema\mapping-schema.xsd".|||

This is an actual microsoft.com forum - isn't there a microsoft support engineer that can give a definitive answer to the question, what xsd file contains the xml schema info for remoting configuration files?