{"id":9926,"date":"2019-02-28T06:31:28","date_gmt":"2019-02-28T06:31:28","guid":{"rendered":"https:\/\/dbtut.com\/?p=9926"},"modified":"2019-02-28T06:31:28","modified_gmt":"2019-02-28T06:31:28","slug":"the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/","title":{"rendered":"The target principal name is incorrect. Cannot generate SSPI context(Set SPN)"},"content":{"rendered":"

 <\/p>\n

If the domain user that you set for SQL Server Service Account does not have the following rights on the active directory, you will get this error. Open your SQL Server Log file to make sure that your error is related to this.<\/p>\n

If you see that you received an error such as the following in your log file, you are in the correct article.<\/p>\n

The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc\/ ] for the SQL Server service. Windows return code: 0x2098, state: 15.<\/em><\/span><\/p>\n

It gives an error as follows when you want to connect to the corresponding server via SSMS.<\/p>\n

\"\"<\/p>\n

There are three ways to solve this problem.<\/p>\n

    \n
  1. Change the SQL Server service account to Local System or Network Service. Once you have established the connection, you can change it back to the old service account.<\/li>\n
  2. Make the SQL Server service account Domain Admin. Solves your problem, but it is a ridiculous method. \ud83d\ude42<\/li>\n
  3. If you give the following privileges to your sql server service account on Active Directory, the problem will be resolved.<\/li>\n<\/ol>\n

    “Read servicePrincipalName”<\/p>\n

    “Write servicePrincipalName”<\/p>\n

    Regardless of this error, you must give log on as a service to the sql server service account. To achive this, read the following article.<\/p>\n

    “Security Policy for SQL Server(secpol.msc)<\/a>”<\/p>\n

    If you are going to use the sql server’s always on availability group feature, you must also give the privilege “Create Computer Object” to the sql server service account on the active directory.( in the Organization Unit where sql server servers are located)<\/p>\n

    I recommend you read the article “SQL Server Service Account’s Permissions on Windows<\/a>“.<\/p>\n\n

    <\/div>\n

    <\/path><\/svg><\/i> \"Loading\"<\/p>\n

    <\/div>\n","protected":false},"excerpt":{"rendered":"

      If the domain user that you set for SQL Server Service Account does not have the following rights on the active directory, you will get this error. Open your SQL Server Log file to make sure that your error is related to this. If you see that you received an error such as the …<\/p>\n

    <\/div>\n

    <\/path><\/svg><\/i> \"Loading\"<\/p>\n

    <\/div>\n","protected":false},"author":1,"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":[2237,2236,2238],"class_list":["post-9926","post","type-post","status-publish","format-standard","","category-mssql","tag-set-spn","tag-spn","tag-the-sql-server-network-interface-library-could-not-register-the-service-principal-name"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":3744,"today_views":0},"yoast_head":"\nThe target principal name is incorrect. Cannot generate SSPI context(Set SPN) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"The target principal name is incorrect. Cannot generate SSPI context(Set SPN)\" \/>\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\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The target principal name is incorrect. Cannot generate SSPI context(Set SPN) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"The target principal name is incorrect. Cannot generate SSPI context(Set SPN)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-28T06:31:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c777f71c602e.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"The target principal name is incorrect. Cannot generate SSPI context(Set SPN)\",\"datePublished\":\"2019-02-28T06:31:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/\"},\"wordCount\":288,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c777f71c602e.png\",\"keywords\":[\"Set SPN\",\"SPN\",\"The SQL Server Network Interface library could not register the Service Principal Name\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/\",\"name\":\"The target principal name is incorrect. Cannot generate SSPI context(Set SPN) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c777f71c602e.png\",\"datePublished\":\"2019-02-28T06:31:28+00:00\",\"description\":\"The target principal name is incorrect. Cannot generate SSPI context(Set SPN)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c777f71c602e.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c777f71c602e.png\",\"width\":1004,\"height\":233},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The target principal name is incorrect. Cannot generate SSPI context(Set SPN)\"}]},{\"@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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The target principal name is incorrect. Cannot generate SSPI context(Set SPN) - Database Tutorials","description":"The target principal name is incorrect. Cannot generate SSPI context(Set SPN)","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\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/","og_locale":"en_US","og_type":"article","og_title":"The target principal name is incorrect. Cannot generate SSPI context(Set SPN) - Database Tutorials","og_description":"The target principal name is incorrect. Cannot generate SSPI context(Set SPN)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-28T06:31:28+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c777f71c602e.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"The target principal name is incorrect. Cannot generate SSPI context(Set SPN)","datePublished":"2019-02-28T06:31:28+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/"},"wordCount":288,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c777f71c602e.png","keywords":["Set SPN","SPN","The SQL Server Network Interface library could not register the Service Principal Name"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/","name":"The target principal name is incorrect. Cannot generate SSPI context(Set SPN) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c777f71c602e.png","datePublished":"2019-02-28T06:31:28+00:00","description":"The target principal name is incorrect. Cannot generate SSPI context(Set SPN)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c777f71c602e.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c777f71c602e.png","width":1004,"height":233},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/the-target-principal-name-is-incorrect-cannot-generate-sspi-contextset-spn\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"The target principal name is incorrect. Cannot generate SSPI context(Set SPN)"}]},{"@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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9926","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9926"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9926\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}