Best Practice setting up mutiple SQL Agent Domain Accounts???

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  February 11, 2004 at 8:42 am

  #359102

  Hi,

  What is the best practice/considerations in setting up the MSSQL and SQL Agent services for multiple servers? I want to use the same domain account for both services. However, should each server use a different domain account, or should all servers use the same 1 account? My initial thought is that how do you tell your alerts generated from the different servers?

  ie: Server 1 = for both services uses ... YourDomain\SqlService1

  Server 2 = for both services uses ... YourDomain\SqlService2

  Server 3 = for both services uses ... YourDomain\SqlService3

  or

  Server 1 = for both services uses ... YourDomain\SqlService1

  Server 2 = for both services uses ... YourDomain\SqlService1

  Server 3 = for both services uses ... YourDomain\SqlService1

  Many thanks. Jeff

  Many thanks. Jeff

• Jack Corbett

  SSC Guru

  Points: 184393

  More actions

  February 12, 2004 at 6:48 am

  #493790

  Alerts emailed to an Operator include the Server Name.  So I wouold use one account.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question