Synchronizing Data (Error)

- 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)

The operation could not be completed.

I have got this error when trying to create the SQL mobile replication using SQL 2005 CTP.
The publication was created successfully, as well as the web synchronization setup, snapshot agent running fine. I am using annonymous login option, is that sth to do with the IIS user profile configeration? I am really stuck...could someone help?

thanx in advance.

[769 byte] By [Kylin.Sandfield] at [2008-2-20]

«« Publishing a project
»» Clearing Remote Share File sessions

# 1

Make sure that the IUSR_xxx has appropriate access to the snapshot folder.
Also take a look at this whitepaper and see if it helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlce/html/sqlce_secmodelscen20.asp

What version of CE is this?
Has the SQL 2005 server configured for remote connections? See if you can connect to this server from a remote machine using osql.

MaheshDudgikar at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Replication...

# 2

careless on me..forgot to add the user IUSR_computername as the user of the SQL server and grant it the proper access to the database. thanx Mahesh, your reply definitely inspired me.

Kylin.Sandfield at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech