“Drop failed for Login ‘Login_Name’. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)”<\/p>\n
You may experience this error when you try to delete a Login in SQL Server. The reason is that this Login has an Endpoint.<\/p>\n
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.<\/p>\n
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.<\/p>\n
To avoid this error, you must first remove the Endpoints of the Login you want to delete.<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"excerpt":{"rendered":"
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 …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"author":423,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6493","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"\n
Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-11T12:21:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-21T13:14:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/252.png\" \/>\n<meta name=\"author\" content=\"Ekrem \u00d6nsoy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ekrem \u00d6nsoy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"Drop failed for Login ‘Login_Name’. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)\",\"datePublished\":\"2018-12-11T12:21:06+00:00\",\"dateModified\":\"2018-12-21T13:14:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/\"},\"wordCount\":164,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/252.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/\",\"name\":\"Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/252.png\",\"datePublished\":\"2018-12-11T12:21:06+00:00\",\"dateModified\":\"2018-12-21T13:14:30+00:00\",\"description\":\"Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/252.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/252.png\",\"width\":808,\"height\":247},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Drop failed for Login ‘Login_Name’. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\",\"name\":\"Ekrem \u00d6nsoy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"caption\":\"Ekrem \u00d6nsoy\"},\"description\":\"The original article was written in Turkish by Ekrem \u00d6nsoy 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.\",\"url\":\"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141) - Database Tutorials","description":"Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/","og_locale":"en_US","og_type":"article","og_title":"Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141) - Database Tutorials","og_description":"Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-11T12:21:06+00:00","article_modified_time":"2018-12-21T13:14:30+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/252.png","type":"","width":"","height":""}],"author":"Ekrem \u00d6nsoy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ekrem \u00d6nsoy","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"Drop failed for Login ‘Login_Name’. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)","datePublished":"2018-12-11T12:21:06+00:00","dateModified":"2018-12-21T13:14:30+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/"},"wordCount":164,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/252.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/","name":"Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/252.png","datePublished":"2018-12-11T12:21:06+00:00","dateModified":"2018-12-21T13:14:30+00:00","description":"Drop failed for Login 'Login_Name'. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/252.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/252.png","width":808,"height":247},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/drop-failed-for-login-login_name-the-server-principal-owns-an-endpoint-and-cannot-be-dropped-microsoft-sql-server-error-15141\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Drop failed for Login ‘Login_Name’. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46","name":"Ekrem \u00d6nsoy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","caption":"Ekrem \u00d6nsoy"},"description":"The original article was written in Turkish by Ekrem \u00d6nsoy 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.","url":"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/423"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=6493"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6493\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![](\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/252.png\")
<\/p>\n