Sql Express Web Sync, can't find snapshot? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Sql Express Web Sync, can't find snapshot?

Author

Topic

wscottp
Starting Member

1 Post

Posted - 2007-11-12 : 15:58:17

I'm using RMO to set up MergePullSubscription to a SQL Express database, the server is running SS2k5.

The subscription gets created just fine, and web sync seems to be working, going to replisapi.dll?diag in my new virtual directory returns no errors.

When creating the publication on the server (using management studio for this) the snapshot is created, and stored in the snapshot share. Creating the publication seems to go without any issues. When I open the "Configure Web Synchronization" wizard, and point it to my new snapshot share, it ALWAYS says that the snapshot folder appears to be empty, which it isn't.

I get an error when I attempt to sync the databases that I believe is caused by Web Sync not being able to find the snapshot. Here's the output from triggering the sync via RMO.

2007-11-12 14:45:49.225 The upload message to be sent to Publisher 'SandBoxWebApp' is being generated
2007-11-12 14:45:49.265 The merge process is using Exchange ID 'DF8FE565-F6BC-40B3-8AEA-7B6FA5EC225D' for this web synchronization session.
2007-11-12 14:45:49.928 No data needed to be merged.
2007-11-12 14:45:49.940 Request message generated, now making it ready for upload.
2007-11-12 14:45:49.952 Upload request size is 1290 bytes.
2007-11-12 14:45:49.988 Uploaded a total of 1 chunks.
2007-11-12 14:45:50.000 The request message was sent to 'https://SandBoxWebApp/WebSync/replisapi.dll'
2007-11-12 14:45:50.064 Downloaded a total of 3 chunks.
2007-11-12 14:45:50.076 The response message was received from 'https://SandBoxWebApp/WebSync/replisapi.dll' and is being processed.
2007-11-12 14:45:50.109 The process could not connect to Distributor 'SandBoxWebApp'.
A first chance exception of type 'System.Runtime.InteropServices.SEHException' occurred in Microsoft.SqlServer.Replication.dll
A first chance exception of type 'Microsoft.SqlServer.Replication.ComErrorException' occurred in Microsoft.SqlServer.Replication.dll
A first chance exception of type 'Microsoft.SqlServer.Replication.ComErrorException' occurred in Microsoft.SqlServer.Replication.dll

That's it, always end up with "Cannot connect to distributor".

I'm using a free cert for testing, hence the non-FQDN name SandBox, but I have added the root CA to my machine, and don't get any cert errors when visiting the ?diag page in my browser.

Any ideas? I've been beating my head against the same wall for 2 days now!

Thanks in advance,
Scott P

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-11-22 : 05:46:28

Are you running SP2 on the server?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources