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

  • 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

  • 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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply