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):

Click here to view code image

GRANT CONNECT ...

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial