Drop failed for Login ‘Login_Name’. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)

 

ERROR MESAGGE:

“Drop failed for Login ‘Login_Name’. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)”

EXPLANATION:

You may experience this error when you try to delete a Login in SQL Server. The reason is that this Login has an Endpoint.

In SQL Server, the Endpoints are based on the server, not the database. You can also access the endpoints with SSMS (SQL Server Management Studio) under the Server Object\Endpoints tabs in the Object Explorer window.

Note: Endpoints cannot be created from the SSMS interface. They can only be created using CREATE ENDPOINT commands using T-SQL. For more information about endpoints click here.

SOLUTION:

To avoid this error, you must first remove the Endpoints of the Login you want to delete.

You can do this by droping and creating endpoint with another user.

Ekrem Önsoy
Author: Ekrem Önsoy

The original article was written in Turkish by Ekrem Önsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.

Leave a Reply

Your email address will not be published. Required fields are marked *