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.
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)MessagesThe operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib) |
|
MohammedU
Posting Yak Master
145 Posts |
|
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. |
|
|
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\ShareNameThe 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! |
|
|
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. |
|
|
|
|
|