O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Granting Permissions

It is possible to have an AUTHORIZATION [login] statement in the CREATE ENDPOINT command that establishes the permissions for a login account to the endpoint being defined. However, separating this out into a GRANT greatly stresses the point of allowing this connection permission. From each SQL query connection, you run a GRANT to allow a specific login account to connect on the ENDPOINT for database mirroring. If you don’t have a specific login account to use, default it to [NT AUTHORITY\SYSTEM].

First, from the principal server instance (SQL2012DXD01), you run the following GRANT (substituting [NT AUTHORITY\SYSTEM] with your specific login account to be used by database mirroring):

GRANT CONNECT ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required