SQL Server specialists

Identify and change a SQL Server endpoint owner

It is quite common for a DBA or consultant to setup database mirroring or an always on availability group and then leave the organization.
When it is time to clean up SQL Server logins on your SQL Server you discover, that although you have revoked access for the login to all databases and server roles, you are still unable to delete the login as it is reported to own an endpoint.
Below shows the error reported in SQL Server 2014.
To confirm the endpoint owner you could use the following:

To change the endpoint owner to sa for an endpoint called Mirroring you would use the following:

Confirm that the endpoint is now owned by sa:
The legacy DBA or consultant’s login can now be removed from the SQL Server.

Category: Tips