October 28, 2012 at 5:38 am
Hello
Could any one explain which login acount we should use while configuring Replication or while providing security credentials during replication configuration what would be the login id's or under which account we should run this service?
Rgds,
Raman
November 1, 2012 at 3:58 pm
It is suggested you use a single domain account for all SQL server agents, a domain admin to allow access to share folders. Make sure it has 'log on as a service' on all machines.
What type of a replication set up are you using? Are all machines on the same domain?
----------------------------------------------------
November 1, 2012 at 10:19 pm
Hi
Thanks for your reply and I was trying it for Transactional Replication on the single machine (P/D-one instance and S on different).
So request you to explain the relevant logins and their relevance.(Though I've done or able to run the same somehow)
Rgds/Raman
November 2, 2012 at 12:02 pm
Hi - to answer your question, create a domain admin account on your network if you haven't done so already. Use this same account to run the Agent service on all machines involved in replication. This will minimize security related issues in the replication process.
IF you are unsure how to do this,
execute "services.msc" (without the quotes ) in a run or CMD window,
scroll down to SQL SERVER Agent
You will see a column that states the account the service is running under. You can change it here by accessing the properties dialogue.
Hope this helps.
----------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply