Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication user account Expand / Collapse
Author
Message
Posted Sunday, October 28, 2012 5:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 2, 2014 1:31 AM
Points: 2, Visits: 196
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
Post #1378023
Posted Thursday, November 1, 2012 3:58 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 6:59 PM
Points: 464, Visits: 1,074
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?

Post #1380070
Posted Thursday, November 1, 2012 10:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 2, 2014 1:31 AM
Points: 2, Visits: 196
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
Post #1380131
Posted Friday, November 2, 2012 12:02 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 6:59 PM
Points: 464, Visits: 1,074
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.
Post #1380543
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse