ReadWriteDeleteMessageFile FAILURE with SQL Server Mobile Server Agent Diagnostics

Hi all.

Is there a difference with sql replication between sql server 2005 64bit and sql server 2005 32bit?

Both are on a Windows 2003 server. One is 32 bit and the other one is 64 bit.

The first time I set up sql replication (test environment), it was on a 32 bit sql server. This worked fine.

The second time I wanted to set up replication (live environment), it was on a 64 bit sql server. This didn't worked fine.

I can't call the sqlcesa30.dll file on the 64bit server with IIS. So I called the dll via a remote IIS server.

This worked but gave me the following error when calling the following URL:

http://domain/PDASYNC/sqlcesa30.dll?diag

SQL Server Mobile Server Agent Diagnostics

2007/07/31 14:26:55

General Information Item Value Server Name domain URL /PDASYNC/sqlcesa30.dll Authentication Type Anonymous Server Port 80 HTTPS off Server Software Microsoft-IIS/6.0 Replication Allowed RDA Allowed Logging Level 0

Impersonation and Access Tests Action Status ErrorCode Impersonate User SUCCESS 0x0 ReadWriteDeleteMessageFile FAILURE 80070003

SQL Server Mobile Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5207.0 SQLCESA30.DLL SUCCESS 0x0 Unknown

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x8007007E

SQL Server Module Versions Module Version sqloledb.dll 2000.86.1830.0 9.0 replrec.dll 2005.90.2047.0 9.0 replprov.dll 2005.90.2047.0 9.0 msgprox.dll 2005.90.2047.0 8.0 replrec.dll 2000.80.760.0 8.0 replprov.dll 2000.80.760.0 8.0 msgprox.dll 2000.80.760.0

After seeing this I looked up what ReadWriteDeleteMessageFile could mean. It appeared to be some NTFS acces problem. But when I checked the security settings, it all seemed to be ok.

Has anyone any idea what else to check? Or is sure that I must have done something wrong?

Thanks in advance,

Arjan

Hello,

Currently there are some issues with server tools on 64 bit machines. I think, we can get 64 bit SQL CE, sometime, in near future.

Thanks

Udaya.

|||

Ok, thnx.

We currently got it working through a 32bit webserver