Authentication Failed On The Computer Running IIS?

Hi Friends,

I am currently trying to develop a small Windows Mobile Application with SQL server Mobile edition.



To develop this , I followed this link http://msdn2.microsoft.com/en-us/library/aa454892.aspx



As I dint find Vendors.sdf database I created My own Database with student table. My database name is MyDB. I created both Mobile database (.sdf) and the same database in sql server 2005



when I run the application I can update the database upto the mobile with no problem. But when I try to Sync I am facing the following exception at the following code.



private void SyncVendors()

{

if (File.Exists(this.DataFileName))

{

this.SaveData();

_repl.Synchronize(); //exception is raised at this line

this.GetData();

}

else

MessageBox.Show("The subscription database has not yet been created. You must first select the Init Sync menu item.");

}



For the replication I used



private void InitReplication()

{

_repl.InternetUrl = @"http://XXXXXXXX/MyDB/sqlcesa30.dll";\ for security reasons I am not using my system name

_repl.Publisher = @"XXXXXXXXX";

_repl.PublisherDatabase = @"MyDB";

_repl.PublisherSecurityMode = SecurityType.NTAuthentication;

_repl.Publication = @"MyDB";

_repl.Subscriber = @"MyDB";

_repl.SubscriberConnectionString = this.DataSourceConnectionString;

_repl.LoginTimeout = 120;
//_repl.InternetLogin = "XXXXXXXXXXXXXXXXXXXX€?; //Timely I used these 2

//_repl.InternetPassword = "XXXXXX€?;

}



"An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

Additional information: 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."



Or (Some times when I change the Directory Security in IIS)



An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

Additional information: Authentication failed on the computer running IIS







I tried in many ways like
Ø Resetting the firewalls ( to web server(http))
Ø In sql server I set " using both TCT/IP and named pipes
Ø In IIS virtual directory--> directory security à settings I used anonymous, base authentication, integrated Authentication. The same exception with any authentication.
Ø SQL Server Management studio à view à Registered Server Types à SQL Server Mobile. Here I added my data base MyDB.sdf.
Ø SQL Server CE Connectivity Management à selected my database à and select authentications




this is my log in virtual directory

2008/01/28 14:37:11 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:05:08 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:12:16 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:33:35 Hr=80004005 ERROR OpenDB failed getting pub version 28627


can any one please help me?

Thanks in Advance.