{"id":6564,"date":"2018-12-13T18:10:16","date_gmt":"2018-12-13T18:10:16","guid":{"rendered":"https:\/\/dbtut.com\/?p=6564"},"modified":"2018-12-21T13:09:14","modified_gmt":"2018-12-21T13:09:14","slug":"the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/","title":{"rendered":"The server principal “login_name” is not able to access the database “database_name” under the current security context."},"content":{"rendered":"

 <\/p>\n

ERROR MESAGGE:<\/h3>\n

“The server principal “login_name” is not able to access the database “database_name” under the current security context.”<\/p>\n

EXPLANATION:<\/h3>\n

You receive this error when you do not have sufficient privileges in the database that you are trying to access.<\/p>\n

SOLUTION:<\/h3>\n

Make sure that the Login you connect to SQL Server Instance has sufficient privileges to access the relavant database.<\/p>\n

 <\/p>\n

You can follow these steps:
\n– Run SQL Server Management Studio.
\n– Connect to the related SQL Server Instance with a user account that can modify Login.
\n– Expand the Logins under the Security to find the corresponding Login and right click on this login and then click Properties.
\n– Click User Mapping and select the database you want to give the access right to the login from “Users mapped to this login” list.<\/p>\n

In the screenshot below, we will map the login\u00a0 named test to the database AdventureWorks.<\/p>\n

<\/p>\n

 <\/p>\n

or you can use T-SQL code as follows:<\/p>\n

USE [database_name]\u00a0\r\nGO\u00a0\r\nCREATE USER [user_name] FOR LOGIN [login_name]\u00a0\r\nGO<\/pre>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  ERROR MESAGGE: “The server principal “login_name” is not able to access the database “database_name” under the current security context.” EXPLANATION: You receive this error when you do not have sufficient privileges in the database that you are trying to access. SOLUTION: Make sure that the Login you connect to SQL Server Instance has sufficient …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/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-6564","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"\nThe server principal "login_name" is not able to access the database "database_name" under the current security context. - Database Tutorials<\/title>\n<meta name=\"description\" content=\"The server principal "login_name" is not able to access the database "database_name" under the current security context.\" \/>\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\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The server principal "login_name" is not able to access the database "database_name" under the current security context. - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"The server principal "login_name" is not able to access the database "database_name" under the current security context.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-13T18:10:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-21T13:09:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/608.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\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"The server principal “login_name” is not able to access the database “database_name” under the current security context.\",\"datePublished\":\"2018-12-13T18:10:16+00:00\",\"dateModified\":\"2018-12-21T13:09:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/\"},\"wordCount\":184,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/608.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/\",\"name\":\"The server principal \\\"login_name\\\" is not able to access the database \\\"database_name\\\" under the current security context. - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/608.png\",\"datePublished\":\"2018-12-13T18:10:16+00:00\",\"dateModified\":\"2018-12-21T13:09:14+00:00\",\"description\":\"The server principal \\\"login_name\\\" is not able to access the database \\\"database_name\\\" under the current security context.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/608.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/608.png\",\"width\":618,\"height\":667},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The server principal “login_name” is not able to access the database “database_name” under the current security context.\"}]},{\"@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":"The server principal \"login_name\" is not able to access the database \"database_name\" under the current security context. - Database Tutorials","description":"The server principal \"login_name\" is not able to access the database \"database_name\" under the current security context.","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\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/","og_locale":"en_US","og_type":"article","og_title":"The server principal \"login_name\" is not able to access the database \"database_name\" under the current security context. - Database Tutorials","og_description":"The server principal \"login_name\" is not able to access the database \"database_name\" under the current security context.","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-13T18:10:16+00:00","article_modified_time":"2018-12-21T13:09:14+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/608.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\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"The server principal “login_name” is not able to access the database “database_name” under the current security context.","datePublished":"2018-12-13T18:10:16+00:00","dateModified":"2018-12-21T13:09:14+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/"},"wordCount":184,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/608.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/","name":"The server principal \"login_name\" is not able to access the database \"database_name\" under the current security context. - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/608.png","datePublished":"2018-12-13T18:10:16+00:00","dateModified":"2018-12-21T13:09:14+00:00","description":"The server principal \"login_name\" is not able to access the database \"database_name\" under the current security context.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/608.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/608.png","width":618,"height":667},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/the-server-principal-login_name-is-not-able-to-access-the-database-database_name-under-the-current-security-context\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"The server principal “login_name” is not able to access the database “database_name” under the current security context."}]},{"@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\/6564","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=6564"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6564\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}