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.
Citation from
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.”
C
I think its B?
I think the right answer is B.
I think it is B too.
C:
https://msdn.microsoft.com/en-us/library/ms191140.aspx
?
Goofy is right. Answer is C. As this example the certificate created is a database-level securable.
Make a certificate for the server instance.
Answer B
certificate is server-level not database-level.