Groups | Blog | Home
all groups > sql server replication > february 2006 >

sql server replication : Replication works only with PublisherLogin ="sa" ??


smalo NO[at]SPAM gazmetro.com
2/14/2006 12:03:52 PM
Hi,
I am testing the replication with SqlCeReplication and the only way I
have been able to make it works was by using the PublisherLogin="sa"
(or a user with server role sysadmin). What privileges a PublisherLogin
really needs? I find it risky to use sysadmin privilege.

It's on SqlServer 2005

Thanks

Stephane
Steve B.
2/15/2006 12:00:00 AM
The user must have access to the db, and to the publication itself (see the
tab publication access list).

In the doc, there is troubleshooter guide.

Steve
<smalo@gazmetro.com> a écrit dans le message de news:
1139947432.258285.17190@o13g2000cwo.googlegroups.com...
[quoted text, click to view]

AddThis Social Bookmark Button