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)
 error on web synchronization wizard

Author  Topic 

danmbuen
Starting Member

4 Posts

Posted - 2007-01-28 : 20:53:20
Got the following error on the last part of the wizard, after setting all the requirements:

Setting the snapshot share permissions (Error)

Messages

The operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib)

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-01-30 : 01:23:00
Check the following link.. it may help you...
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1113361&SiteID=1


MohammedU
Go to Top of Page

danmbuen
Starting Member

4 Posts

Posted - 2007-01-30 : 03:32:21
Thanks for the reply. I dont know if these information would help... The machine publishing the articles is running on Windows Server 2003 using SQL Server 2005 Enterprise Edition while the subscribing machine is running on Windows XP Home Edition using SQL Server 2005 Express Edition.
Go to Top of Page

dlcollison
Starting Member

8 Posts

Posted - 2007-02-20 : 11:50:50
I finally ended up initiating an incident with Microsoft on this same issue and have found a resolution to the problem.

1) You must create a Network share - I was forced to use the NET SHARE command from a Command Prompt - for whatever reason, the system would not recognize the share created via Windows.

2) Next, during the Wizard, you get to the screen labeled "Snapshot Share Access". In this window, I had browsed to the physical directory directory where the snapshot exists - THIS IS NOT VALID (note to MS - remove the Browse function). Here, you must enter the share created in the previous step - \\ComputerName\ShareName

The wizard then completes normally.

Side note, during all of this, MS tech support had me delete the Snapshot and recreate the snapshot. Once I deleted the snapshot and was attempting to recreate the snapshot, I began receiving errors that certain system tables did not exist. I was forced to manually remove the replication functionality by opening SQL Server Management Studio and executing the following:

1) USE <dbName>

2) EXEC sp_removedbreplication '<dbName>'

I was then able to recreate the snapshot.

Hope this helps others out who are having similar issues.

David L. Collison
Any day above ground is a good day!
Go to Top of Page

Bit Wrangler
Starting Member

9 Posts

Posted - 2009-12-04 : 14:17:35
Thank you, David, for posting this. I was able to get my configuration to proceed by entering \\ComputerName\ShareName as created via Windows. Getting the path specified correctly was the key for me.
Go to Top of Page
   

- Advertisement -