How to Grant CONNECT on a Mirroring Endpoint in SQL Server

To Grant CONNECT on a previously created Mirroring Endpoint in SQL Server run following query:

USE master;
GO
CREATE LOGIN [domain_name\user_name] FROM WINDOWS;


GO
GRANT CONNECT on ENDPOINT::Mirroring_Endpoint_Name TO [domain_name\user_name];
GO

If the post helped you, please share it:
Pin It

2 comments to How to Grant CONNECT on a Mirroring Endpoint in SQL Server

  • lokesh jawane

    I was trying to setup AG, but MSSQL service account is 'NT service\MSSQLSERVER' & it is failing to setup AG properly.

    So how can i add 'NT service\MSSQLSERVER' login. os is there any other way without changing service account?

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">