Created
April 16, 2022 01:54
-
-
Save kyle-hailey/dc778cc1aaeab8c31cd5c7a743b07f8b to your computer and use it in GitHub Desktop.
Secondary "db2 Always ON
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
drop availability group AG1; | |
drop endpoint [Hadr_endpoint] | |
drop CERTIFICATE aoag_certificate | |
drop master key; | |
drop user aoag_user_db2 | |
drop login aoag_login_db2 | |
CREATE LOGIN aoag_login_db2 WITH PASSWORD = 'XXXXXX1!, DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF' | |
CREATE USER aoag_user_db2 FOR LOGIN aoag_login_db2 | |
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'XXXXXX1!' | |
CREATE CERTIFICATE aoag_certificate | |
AUTHORIZATION aoag_user_db2 | |
FROM FILE = '/var/opt/mssql/shared/aoag_certificate.cert' | |
WITH PRIVATE KEY ( | |
FILE = '/var/opt/mssql/shared/aoag_certificate.key', | |
DECRYPTION BY PASSWORD = 'XXXXXX1!' | |
) | |
CREATE ENDPOINT [Hadr_endpoint] | |
STATE=STARTED | |
AS TCP ( | |
LISTENER_PORT = 5022, | |
LISTENER_IP = ALL | |
) | |
FOR DATA_MIRRORING ( | |
ROLE = ALL, | |
AUTHENTICATION = CERTIFICATE aoag_certificate, | |
ENCRYPTION = REQUIRED ALGORITHM AES | |
) | |
GRANT CONNECT ON ENDPOINT::Hadr_endpoint TO [aoag_login_db2]; | |
ALTER AVAILABILITY GROUP [AG1] JOIN WITH (CLUSTER_TYPE = NONE) | |
ALTER AVAILABILITY GROUP [AG1] GRANT CREATE ANY DATABASE |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment