Mise en oeuvre du Database Mirroring avec SQL Server 2005 RTM (5/6) ...

  • Article

Create Inbound certificates on PEST.sql

:connect PEST

USE master;
-- drop login BUDA_login
CREATE LOGIN BUDA_login WITH PASSWORD = <'1Sample_Strong_Password!@#'>;
-- drop login ZAGREB_login
CREATE LOGIN ZAGREB_login WITH PASSWORD = <'1Sample_Strong_Password!@#'>;
GO

SELECT * FROM sys.server_principals

USE master;
-- DROP USER BUDA_user
CREATE USER BUDA_user FOR LOGIN BUDA_login;
-- DROP USER ZAGREB_user
CREATE USER ZAGREB_user FOR LOGIN ZAGREB_login;
GO

SELECT * FROM sys.sysusers;

USE master;
CREATE CERTIFICATE BUDA_cert
   AUTHORIZATION BUDA_user
   FROM FILE = 'c:\backups\BUDA_cert.cer'
GO
CREATE CERTIFICATE ZAGREB_cert
   AUTHORIZATION ZAGREB_user
   FROM FILE = 'c:\backups\ZAGREB_cert.cer'
GO
SELECT * FROM sys.certificates

USE master;
GRANT CONNECT ON ENDPOINT::Mirroring TO [BUDA_login];
GRANT CONNECT ON ENDPOINT::Mirroring TO [ZAGREB_login];
GO