Should each SQL Server service have its own domain account?

BENEFITS:

  1. Using a separate account for each SQL Service SQL instance gives maximum security.
  2. If you lock out a login, you only affect a single service.
  3. If a password is leaked, they only gain access to one service.
  4. In the event of a password change requirement, we will be aware that only one service will be impacted.

Comments