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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Sql Agent

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-03-25 : 07:16:35
Robin writes "Hello,

i have a problem with replicating my sql server, i've done the publishing part and but after when the snapshot agent has done it's job i get the following error

The publisher login of the snapshot agent must be a member of the sysadmin role or db_owner role.

I'm logged in as the SA user and the agent has Sa as owner so the permissions shouldn't give any problems. The snapshot folder also has the right permissions and isn't on a hidden administrative drive but on a normal share.

Any ideas?"

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-03-28 : 03:40:06
is this really the error message?

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -