Replication user account

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Replication user account

Replication user account

Rate Topic

Display Mode

Topic Options

Author

Message

raman.gulati

Posted Sunday, October 28, 2012 5:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 1:37 AM
Points: 2, Visits: 58

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

mmartin1

Posted Thursday, November 01, 2012 3:58 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 4:43 PM
Points: 192, Visits: 640

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

raman.gulati

Posted Thursday, November 01, 2012 10:19 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 1:37 AM
Points: 2, Visits: 58

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

mmartin1

Posted Friday, November 02, 2012 12:02 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 4:43 PM
Points: 192, Visits: 640

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 »

Permissions