Can I create one domain user account and use it as a service account for Services on multiple SQL servers?

Eudias Kifem 20 Reputation points
2023-03-13T17:32:45.5633333+00:00

Can I create a domain user account A and use it as a logon account for multiple servers?

example... SvcA(service account), used as logon account for

Server1 instance1 -engineservice, Agentservice

Server 2 instance1 - engineservice, Agentservice

a. what are the possible effects

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,700 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,121 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
5,850 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Thameur-BOURBITA 32,501 Reputation points
    2023-03-13T22:15:08.72+00:00

    Hi @Eudias Kifem

    Yes , you can use the same service account to configure multiple instance and SQl servers.

    A service account can be used to configure one or multiple SQL server without any issue. In the other hand I recommend you to use GSMA to avoid use a standard user account as service account with password nerver expired.

    Please don't forget to mark helpful answer as accepted


  2. Erland Sommarskog 100.9K Reputation points MVP
    2023-03-13T22:16:49.4366667+00:00

    Yes, you can do that. The main consideration is security, as the instances can access each other's data folders. One of my clients has it set up this way, but it is a dev shop, and all the instances are test/dev servers, not production.


  3. Seeya Xi-MSFT 16,436 Reputation points
    2023-03-14T07:45:22.55+00:00

    Hi @Eudias Kifem ,

    Yes, you can create a domain user account and use it as a logon account for multiple servers.

    By using a single service account, you can simplify the management of service accounts. You can update the password or make any changes in the service account in a centralized location.

    However, there are some possible effects of using a single service account across multiple servers. If the service account is compromised, it can impact all the servers where it is used. Therefore, you need to ensure that the service account is adequately secured with strong passwords and proper access controls.

    Best regards,

    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".