Mise en oeuvre du Database Mirroring avec SQL Server 2005 RTM (6/6) ...
Create Inbound certificates on ZAGREB.sql
:connect ZAGREB
USE master;
-- drop login BUDA_login
CREATE LOGIN BUDA_login WITH PASSWORD = <'1Sample_Strong_Password!@#'>;
CREATE LOGIN PEST_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 PEST_user
CREATE USER PEST_user FOR LOGIN PEST_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 PEST_cert
AUTHORIZATION PEST_user
FROM FILE = 'c:\backups\PEST_cert.cer'
GO
SELECT * FROM sys.certificates
USE master;
GRANT CONNECT ON ENDPOINT::Mirroring TO [BUDA_login];
GRANT CONNECT ON ENDPOINT::Mirroring TO [PEST_login];
GO