November 7, 2006 at 11:05 am
Hello,
I have created a transactional replication database and trying to connect the subscriber. When I try to connect, I get an error "SQL server agent could not access the replication agent. Use the DCOMCNFG utility". I have tried using the SA as well as a SQLADMIN account that I created on both the publisher and the subscriber server.
Is this a security issue, and if so, what settings changes do I need to have on both the publisher and subscriber?
Thanks for your help
Michael
November 7, 2006 at 12:41 pm
I haven't seen that particular error before. Are both servers on the same domain ? If so, is your SQLADMIN account a windows account or SQL account ? I always use windows accounts unless I'm spanning domains, then I set up a SQL login that has the same password on both machines.
November 7, 2006 at 12:47 pm
The network is pretty small, so I am using a workgroup rather than a domain. Both servers are on the same workgroup - when ever I try to connect from one server to the other via SQL server I still get the error unable to connect to the database.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply