Install and configure SQL AlwaysON AG with Listener on Azure

Configuring the Nodes - Security

On each node, perform the following

Local Administrators

Before:
localadmin_before
After:
localadmin_after

SQL Security

Add the service account user to sysadmin role on SQL server.

Before:
sql_security_before
After:
sql_security_after

SQL Service Accounts

Alter services so they use the service accounts you created. Launch and elevated Command Prompt and execute the following:

Before:
sql_service_before
Execute:
sql_service_execute
After:
sql_service_after

The following needs to be performed on each node in the cluster, plus each additional node that gets added.

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*