{"id":6504,"date":"2018-12-11T18:09:08","date_gmt":"2018-12-11T18:09:08","guid":{"rendered":"https:\/\/dbtut.com\/?p=6504"},"modified":"2018-12-21T13:13:30","modified_gmt":"2018-12-21T13:13:30","slug":"login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/","title":{"rendered":"Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection."},"content":{"rendered":"

 <\/p>\n

ERROR MESAGGE:<\/h3>\n

Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)<\/p>\n

EXPLANATION:<\/h3>\n

If you try to connect to your Windows account with a domain that you are not a member of, you will encounter this error.<\/p>\n

SOLUTION:<\/h3>\n

You can connect with\u00a0a SQL Server Login instead of Windows account.<\/p>\n

Note:<\/strong> In this case, the SQL Server that you want to connect to needs to be set to “SQL Server and Windows Authentication mode”.<\/p>\n\n

<\/div>\n

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

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

  ERROR MESAGGE: Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) EXPLANATION: If you try to connect to your Windows account with a domain that you are not a member of, you will encounter this error. SOLUTION: You can connect with\u00a0a SQL Server Login …<\/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-6504","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"\nLogin failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.\" \/>\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\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-11T18:09:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-21T13:13:30+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<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\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.\",\"datePublished\":\"2018-12-11T18:09:08+00:00\",\"dateModified\":\"2018-12-21T13:13:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/\"},\"wordCount\":104,\"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\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/\",\"name\":\"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-12-11T18:09:08+00:00\",\"dateModified\":\"2018-12-21T13:13:30+00:00\",\"description\":\"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.\"}]},{\"@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":"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. - Database Tutorials","description":"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.","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\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/","og_locale":"en_US","og_type":"article","og_title":"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. - Database Tutorials","og_description":"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-11T18:09:08+00:00","article_modified_time":"2018-12-21T13:13:30+00:00","author":"Ekrem \u00d6nsoy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ekrem \u00d6nsoy"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.","datePublished":"2018-12-11T18:09:08+00:00","dateModified":"2018-12-21T13:13:30+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/"},"wordCount":104,"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\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/","name":"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-12-11T18:09:08+00:00","dateModified":"2018-12-21T13:13:30+00:00","description":"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/login-failed-for-user-null-reason-not-associated-with-a-trusted-sql-server-connection\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection."}]},{"@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\/6504","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=6504"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6504\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}