November 12, 2007 at 7:48 am
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
November 12, 2007 at 9:04 am
Hi,
Have you tested access to distributor from IIS server (e.g. ODBC test) to ensure you can see distribution server?
Thanks,
Phillip Cox
November 12, 2007 at 9:48 am
In this test setup the publisher, distributor, and IIS are the same machine. I'm using the SQL management studio to setup the web virtual directory.
The replisapi dll has a diag screen that returns no errors, so I thought I was good on that end.
The only error I get anywhere during the setup is that the wizard constantly says the snapshot share I pick is empty (which it isn't).
How would I further test the connection between IIS and the distributor?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply