Authentication error in SQL Mobile

Hi ,

I was trying to run my application that has to Synchronize data between sql mobile and sql 2005. In the emulator all is fine and executes without any error.But when I deploy the application in real device it throws an exception:"Authentication failed in server running IIS". The device is WM5.0

The connection string is like this.

String strRemote = "Provider=SQLOLEDB;Data Source=servername;User ID=userid;Password=password;Initial Catalog=databasename";

I am getting the exception only when the application is deployed in the device.

The error log in C:inetpub/wwwroot/Sync is the following:

2007/05/25 12:54:29 Hr=00000000 SQLCESA30.DLL loaded 0
2007/05/25 12:54:29 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 12:54:58 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 12:57:00 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 13:00:37 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 14:55:07 Hr=00000000 SQLCESA30.DLL loaded 0
2007/05/25 14:56:10 Thread=1534 RSCB=2 Command=SCHK Hr=80040E2F The statement has been terminated. 3621
2007/05/25 14:56:10 Thread=1534 RSCB=2 Command=SCHK Hr=80040E2F Violation of PRIMARY KEY constraint 'PK_Orders'. Cannot insert duplicate key in object 'dbo.Orders'. 2627
2007/05/25 19:19:20 Hr=00000000 SQLCESA30.DLL loaded 0
2007/05/25 19:19:20 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 19:20:12 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 19:21:27 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 19:21:47 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1

Please reply....

It seems to be authenticating fine.

It looks like the error is a primary key constraint on the Orders table.

Just a first look,

Adamus