--RUN ON MIRROR SERVER

select  * from sys.database_mirroring_endpoints
GO
USE master;
 

go

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'MEDSYS';

GO

ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'MEDSYS';
GO

CREATE CERTIFICATE HOST_B_cert 
   WITH SUBJECT = 'HOST_B certificate for database mirroring';
GO
drop endpoint Endpoint_Mirroring
go
drop endpoint Mirroring
go
CREATE ENDPOINT Endpoint_Mirroring
   STATE = STARTED
   AS TCP (
      LISTENER_PORT=7025
      , LISTENER_IP = ALL
   ) 
   FOR DATABASE_MIRRORING ( 
      AUTHENTICATION = CERTIFICATE HOST_B_cert
      , ENCRYPTION = REQUIRED ALGORITHM AES
      , ROLE = ALL
   );
GO 
BACKUP CERTIFICATE HOST_B_cert TO FILE = 'C:\HOST_B_cert.cer';
GO 




 
--RUN ON MAIN SERVER

USE master;
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'MEDSYS';
GO

ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'MEDSYS';

GO
USE master;



drop  ENDPOINT Endpoint_Mirroring
go

drop CERTIFICATE HOST_A_cert 
go


CREATE CERTIFICATE HOST_A_cert 
   WITH SUBJECT = 'HOST_A certificate';
GO

CREATE ENDPOINT Endpoint_Mirroring
   STATE = STARTED
   AS TCP (
      LISTENER_PORT=7024
      , LISTENER_IP = ALL
   ) 
   FOR DATABASE_MIRRORING ( 
      AUTHENTICATION = CERTIFICATE HOST_A_cert
      , ENCRYPTION = REQUIRED ALGORITHM AES
      , ROLE = ALL
   );
GO
BACKUP CERTIFICATE HOST_A_cert TO FILE = 'C:\HOST_A_cert.cer';
GO



-- COPY Cert files to both computers