"SQL Server Mobile encountered problems when opening the database."

Hi,

I am writing an application for a device (HP IPAQ 6828) having Windows Mobile 5.0 using

-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET

The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.

"SQL Server Mobile encountered problems when opening the database."

repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()

I also checked the the connection string and it seems to be fine. Both my device and server can ping each other. Moreever I can also access the Web syncronization folder(on server) from the device.

Is anyone having a resolution for this?

This problem may be caused by many reasons.

The most common is not disposing the replication object or other data related objects. Make sure there isn't any other arround.
Sql Mobile 2005 allows multiple connections except while syncronizing.

Another known cause is a bad path on the connection string.

Other forum entries referring this problem:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=334604&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478902&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=961633&SiteID=1|||

Hi,

I finally found the solution to this...

repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()

(Note: I am trying to synchronize on an exisiting database)

The problem was since my database is already in use by my application and I am trying to sync the same DB. Synchronization cannot occur if the connection is already open by the application. Sql Mobile 2005 allows multiple connections except while synchronizing.

Therefore we need to close and dispose the open connection used by the application as under before attempting to synchonize.

(Below is the sample code)

private sub SampleSync()

sharedCon.close
sharedCon.dispose

try

' TO DO: Set replication object properties here

repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()

finally
repl.dispose
end try

' TO DO: Open your shared connection here if required.

End sub

Note: Most of the times the connection string also causes a problem. A sample connection string would look like this...

repl.SubscriberConnectionString ="\Program Files\YourAppName\YourDb.sdf;Password =<...>"

"SQL Everywhere" is a Sybase trademark

It's all well and good that Microsoft has finally entered the well-established mobile database market (the market that iAnywhere Solution's SQL Anywhere product current *owns* by a wide margin). However, it should be noted that "SQL Everywhere" is a Sybase trademark. For confirmation of this fact, see http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.mro12.6.mro126ig/html/mro126ig/legal.htm

For confirmation of the fact that SQL Anywhere owns the mobile database market, note that it is the database of choice for the 500,000 mobile devices that will be used in the 2010 US Census; see http://www.internetadsales.com/modules/news/article.php?storyid=7347

Breck

The full name of the new mobile db is SQL Server Everywhere Edition, and I don't see that in the list you're linking.

Plus, wouldn't you think that a company like Microsoft has done some research before they decide on their product names?

|||

"Plus, wouldn't you think that a company like Microsoft has done some research before they decide on their product names?"

http://seattletimes.nwsource.com/html/businesstechnology/2002397450_microvista23.html

By naming the next version of Windows "Vista," Microsoft may have stepped on the toes of another software company just down the road in Redmond.

So, no, or: When an 800-lb gorilla has got to go, he doesn't ask where's the restroom, he just goes!

Whois vista.com?

Registrant:
CommunityIQ
11241 Willows Road
Redmond, WA 98052
US
Registrar: DOMAINBANK
Domain Name: VISTA.COM
Created on: 02-NOV-94
Expires on: 01-NOV-14
Last Updated on: 27-OCT-05
Administrative, Technical Contact:
Admin, Domain ***@.VISTA.COM
vista.com
11241 Willows Road
Redmond, WA 98052
US
3609208478

'She said the company filed for trademark protection of the words "Windows" and "Vista" used together. ..."The name Vista is commonly used by a variety of companies in a variety of industries," she said. "We are only using the word Vista paired with our trademark Windows so the two together - 'Windows Vista' - ...

If that's MS's stance, then it should have no problem with "Linux Windows". After all,
Windows is used by a variety of ... (yada-yada-yada).

"lenght cannot be less than zero. Parameter name : lenght"

I'm using Visual Studio 2005, and when i try to drop a table from a data source( SQL Mobile database), to a new or existing form, always occors the error ""lenght cannot be less than zero. Parameter name : lenght"" , my project has more than one forms.
If i make the same steps on a new project with only one form, i can drop the same table without problems.
Anyone can help with this problem?

best regards,

Pedro Nogueira

Pedro,

It sounds like you are using the drag and drop data binding in a Windows Forms application using SQL Mobile as the data source?

First I recommend ensuring that you are running VS2005 Service Pack 1. If you are or still have this issue after upgrading, to recreate

this, we would need some insight into your database schema and how you are doing the drag and drop onto the form (are you dropping

the whole table? are you bound to a datagrid or to another control, etc)

What I'm saying is that I don't hear of anyone having problems with drag & drop of SQL Mobile/SQL CE tables onto forms with

VS2005 SP1, so you either have a bad install or have indeed found a bug. Happy to help you with that but would need more info

on your database and how you're doing the binding.

Darren Shaffer

"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,