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 |
|
sim085
Starting Member
1 Post |
 Posted - 2006-02-04 : 09:15:10
|
| Hi,I am trying to do replication between Microsoft SQL Server 2000 SP4 and Microsoft SQL 2005 Mobile Edition.I have found downloaded all the needed pre-requisites. However I am having a problem inside the Snapshot Share Access screen. I set the folder (C:\snapsot) I want to use for the snapshot, and clicked Finnish. However in the Configure Web Synchronization screen it gives me an error on the ‘Setting the snapshot permission’ task (0x80070000). I tried searching on Google about the error but could not find much.However I found a tutorial on Microsoft Website saying how to create this folder. One of the tasks to create this folder is:Assign Full Control permission to SQL Server Service and SQL Server Agent Service.(from http://msdn2.microsoft.com/en-us/library/ms172371.aspx)However I can not find from where I can do this. I set all the others steps, however this one I do not know from where I can do it.Thanks in advance for any suggestions.Regards,Sim085 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-06 : 04:16:24
|
| from my understanding...you need to allow the account that runs both services full access permission on the folderyou can check the folder properties, security tab and verify if the service account has full access--------------------keeping it simple... |
 |
|
|
mblythe
Starting Member
16 Posts |
Posted - 2006-02-06 : 18:23:33
|
| By "service" they mean the account under which Sql Server and Sql Server Agent run, as in YourDomain\YourAccount. Depending on how you configured SQL Server, each service could run under a different account or they could both use the same account.Michael Blythe Technical WriterSQL Server Replication - Microsoft --------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. |
|
|
|
dlcollison
Starting Member
8 Posts |
Posted - 2007-01-30 : 09:17:26
|
| I need assistance on this same topic. I'm using SQL Server 2005/IIS on the server and want to replicate to a SQL Server Compact Edition database. I've setup the users and authority as guided by the MS On-Line articles on replication and receive the same error. I then went in and added all SQL Server users, the Anonymous user and Administrator and gave them all full access rights to the snapshot directory - not what I want in production, but am trying to get rid of the error. Anyhow, I am still getting the error message: "The operation completed successfully. (Exception from HRESULT: 0x80070000)(mscorlib)"What do I need to change to get around this security issue.Thanks ...David L. Collison Any day above ground is a good day! |
|
|
|
|
|
|
|
|
Snapsot Folder Problem