Showing posts with label mergereplication. Show all posts
Showing posts with label mergereplication. Show all posts

Sunday, 12 February 2012

Configure web synchronization wizard error

I am trying to confugure SQL Server 2005 (wrokgroup edition) for merge
replication with web synchronisation. The server will be publisher and
distributor and the remote client will be running SQL Server 2005
Express.
I have set up two directories under Inetpub on the server. The access
directory is set up as a virtual directory for web access and the
snapshot directory is set up as a network share.
I have set up a local account for replication / synchronization.
The SQL Agent runs under the admin account, I have logged on to SQL
management studio under the admin account and created the publication.
When I run the configure web synchronisation wizard I keep getting an
error occuring when it gets to the step "Setting the snapshot share
permissions" which then rolls back the previous actions.
A message comes up for each user I have specified (three in the last
case) saying "Setting the snapshot share permissions (error)" and then
"The operation completed successfully. (Exception from HRESULT:
0x8007) (mscorlib)" for each user.
I have tried manually configuring both directories for permissions for
all three accounts (admin account running SQL agent, local account for
replication/synchronisationand login on remote client). Starting to
clutch at straws!
Any help greatly appreciated. It appears to be something to do with
permissions but I am not sure what to set for which account and where.
Many thanks.
On 1 Jun, 10:37, JDS <a...@.jeremysage.com> wrote:
> I am trying to confugure SQL Server 2005 (wrokgroup edition) for merge
> replication with web synchronisation. The server will be publisher and
> distributor and the remote client will be running SQL Server 2005
> Express.
>...
> A message comes up for each user I have specified (three in the last
> case) saying "Setting the snapshot share permissions (error)" and then
> "The operation completed successfully. (Exception from HRESULT:
> 0x8007) (mscorlib)" for each user.
>
I think problem solved but just in case anyone else comes across the
same thing (I have seen a few similar post with no resolution) the
change that seemed to make the difference was the specification of the
location of the snapshot folder. I clicked on the "Browse..." button
to specify the location but this does not seem to insert the correct
reference - it gives the full path - I changed this to //ServerName/
ShareName and the wizard complete OK.
I hope this was of use to someone.