/* 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 pri_cert AUTHORIZATION mirror_user FROM FILE = 'D:\Data\pri_cert.cer' GO CREATE CERTIFICATE witness_cert AUTHORIZATION mirror_user FROM FILE = 'D:\Data\witness_cert.cer' GO /* Grant the CONNECT permission to the endpoint */ GRANT CONNECT ON ENDPOINT::sb_endpoint TO [mirror_logon]; GO