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 (SQL08DE01), you run the following GRANT (substituting [DBARCHLT\Paul Bertucci] with your specific login account to be used by database mirroring):
Then, from the mirror server instance ...
Get Microsoft® SQL Server 2008 R2 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.
