AlwaysOn Cluster Setup:

  • Use the same account to run all SQL Server service for all node in the cluster.
  • Account has Administrator permissions on all servers in node.
  • Account has sysadmin SQL permission on all servers in node.
  • Account has log on as service policy on all servers in node.

Note:

Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server Database Engine or SQL Server Agent services, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as updating the Windows local security store which protects the service master key for the Database Engine. Other tools such as the Windows Services Control Manager can change the account name but do not change all the required settings.

Last modified: July 7, 2020

Author

Comments

Write a Reply or Comment