August 4, 2005 at 2:49 pm
Hi all,
I have a Transactional Replication process going on between SQL Server 2000 (services running under Domain Admin, TCP/IP and NAmed Pipes enabled for Trusted Connection) and MSDE (services running under a non-privileged domain account, Mixed mode authentication) with Pull susbscription. I also have a VB6 aplication to run Replication upon users request. If Sql Authentication is used, the Replication fails unless the user is part of System Administrators in SQL Server. If trusted connection is used, the user logged in is different from the user under which MSDE-SQLExec runs. I like to use trusted connection, but my users do not have administrative rights on their machines, and I assume no service can run under their login, and even if they can, I can't make everybody part of System Admin group in sQL Server (and/or Domain Administrator group). Everything runs fine, under my login, because I'm part of domain admin group, and part of System Admin in sQL Server.
Is this the only way Replication can work?
Thanks,
ej
August 5, 2005 at 4:59 am
use SQL Authentication. If you are using Replication ActiveX objects you need the following
Publisher account - should be in the PAL - in the publisher
Distributor account - should be in the dbo role - in the publisher
Subscriber account - should be in the dbo role in subscriber and distirbution database
You must configure your snapshot share so that the account the SQL Server agent on the subscriber runs under has read rights to this share.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
August 5, 2005 at 8:18 am
Thanks a lot Hilary. I was missing the Subscriber's account rights on the distribution database, which is in the same server as the publisher. I did and it worked.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply