You need to be able to create database mirroring endpoints on both servers

You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted
domain.
You plan to configure database mirroring.
You need to be able to create database mirroring endpoints on both servers.
What should you do?

You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted
domain.
You plan to configure database mirroring.
You need to be able to create database mirroring endpoints on both servers.
What should you do?

A.
Configure the SQL Server service account to use Network Service.

B.
Use a server certificate.

C.
Use a database certificate.

D.
Configure the SQL Server service account to use Local System.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Kevin

Kevin

http://msdn.microsoft.com/en-us/library/cc917681.aspx

“We tested database mirroring between two remote database servers—one in Redmond, Washington, and the other in Charlotte, North Carolina. The two database servers are in different and untrusted domains. To establish database mirroring between untrusted domains, certificates are required to authenticate connection requests. Certificates have no impact on performance and provide a secured way of authenticating database mirroring connections. On each server (principal, mirror, and witness), the endpoint is configured with a locally created certificate. Then the certificates are copied to the other servers.”