/* Create a login account and add a user to the account */ USE master; CREATE LOGIN mirror_logon WITH PASSWORD = 'Pa$$w0rd'; GO CREATE USER mirror_user FOR LOGIN mirror_logon; GO /* Add certificates to the user account */ CREATE CERTIFICATE sb_cert AUTHORIZATION mirror_user FROM FILE = 'D:\Data\sb_cert.cer' GO CREATE CERTIFICATE mirror_cert AUTHORIZATION mirror_user FROM FILE = 'D:\Data\witness_cert.cer' GO /* Grant the CONNECT permission to the endpoint */ GRANT CONNECT ON ENDPOINT::pri_endpoint TO [mirror_logon]; GO