PrepAway - Latest Free Exam Questions & Answers

You need to be able to create database mirroring endpoi…

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?

PrepAway - Latest Free Exam Questions & Answers

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.

Explanation:
To enable certificate authentication for database mirroring on a given server instance, the system administrator
must configure each server instance to use certificates on both outbound and inbound connections.
https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/use-certificates-for-adatabase-mirroring-endpoint-transact-sql


Leave a Reply