{"id":6872,"date":"2018-12-24T07:20:08","date_gmt":"2018-12-24T07:20:08","guid":{"rendered":"https:\/\/dbtut.com\/?p=6872"},"modified":"2018-12-24T07:20:08","modified_gmt":"2018-12-24T07:20:08","slug":"the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/","title":{"rendered":"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service"},"content":{"rendered":"

 <\/p>\n

ERROR:<\/h3>\n

The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.<\/p>\n

EXPLANATION:<\/h3>\n

You receive this error because you are trying to make an SPN record from Active Directory when the SQL Server service that is running with a Windows Domain account does not have the necessary privileges.<\/p>\n

SOLUTION:<\/h3>\n

First, I recommend that you make sure that the connection you make to the server is NTLM or KERBEROS; you can see it by running the following code on the corresponding server:<\/p>\n

SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@SPID<\/pre>\n
If the result returned is KERBEROS, it means that SPN records are already present in the related server in Active Directory; if the returned result is NTLM, then the SPN record is not available.<\/p>\n
In this case, you can create SPN records according to your company organization, you can also ask the system administrators to do so.<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  ERROR: The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication …<\/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-6872","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"\nThe SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service - Database Tutorials<\/title>\n<meta name=\"description\" content=\"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service\" \/>\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\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-24T07:20:08+00:00\" \/>\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\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service\",\"datePublished\":\"2018-12-24T07:20:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/\"},\"wordCount\":207,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/\",\"name\":\"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-12-24T07:20:08+00:00\",\"description\":\"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service\"}]},{\"@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 SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service - Database Tutorials","description":"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service","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\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/","og_locale":"en_US","og_type":"article","og_title":"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service - Database Tutorials","og_description":"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-24T07:20:08+00:00","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\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service","datePublished":"2018-12-24T07:20:08+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/"},"wordCount":207,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/","name":"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-12-24T07:20:08+00:00","description":"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/the-sql-server-network-interface-library-could-not-register-the-service-principal-name-spn-for-the-sql-server-service\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service"}]},{"@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\/6872","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=6872"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6872\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}