Skip to content

ss-linux-cluster-pacemaker-create-login.md

Latest commit

 

History

History
21 lines (16 loc) · 876 Bytes

ss-linux-cluster-pacemaker-create-login.md

File metadata and controls

21 lines (16 loc) · 876 Bytes

  1. On all SQL Servers, create a Server login for Pacemaker. The following Transact-SQL creates a login:

    USE [master]
GO
CREATE LOGIN [pacemakerLogin] with PASSWORD= N'ComplexP@$$w0rd!'
	
ALTER SERVER ROLE [sysadmin] ADD MEMBER [pacemakerLogin]

At the time of availability group creation, the pacemaker user will require ALTER, CONTROL and VIEW DEFINITION permissions on the availability group, after it's created but before any nodes are added to it.

  1. On all SQL Servers, save the credentials for the SQL Server login.

    echo 'pacemakerLogin' >> ~/pacemaker-passwd
echo 'ComplexP@$$w0rd!' >> ~/pacemaker-passwd
sudo mv ~/pacemaker-passwd /var/opt/mssql/secrets/passwd
sudo chown root:root /var/opt/mssql/secrets/passwd
sudo chmod 400 /var/opt/mssql/secrets/passwd # Only readable by root