{"id":268,"date":"2015-12-16T16:03:35","date_gmt":"2015-12-16T21:03:35","guid":{"rendered":"https:\/\/www.ccrossan.com\/?p=268"},"modified":"2015-12-16T16:06:20","modified_gmt":"2015-12-16T21:06:20","slug":"sql-alwayson-availability-group-user-accounts","status":"publish","type":"post","link":"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/","title":{"rendered":"SQL AlwaysOn Availability Group User Accounts"},"content":{"rendered":"\n<div class=\"twitter-share\"><a href=\"https:\/\/twitter.com\/intent\/tweet?via=crossan007\" class=\"twitter-share-button\">Tweet<\/a><\/div>\n<p>When creating SQL 2014 AlwaysOn Availability Groups, careful attention is required when provisioning the logins on each member server.<\/p>\n<p>While the databases may contain user accounts for the appropriate members, the cluster member servers may not contain login information for said users. This can result in a seemingly &#8220;happy&#8221; fail over cluster (according to the dashboard in SQL Server Management Studio), but upon fail over, much pain will occur.<\/p>\n<p>From a 10,000 foot view, the Logins on each server need to have the same SID, Username, and Password.<\/p>\n<p>More detail (along with a script to rectify any &#8220;on-noes&#8221; that may have occurred in your environment): <a href=\"https:\/\/support.microsoft.com\/en-us\/kb\/918992\">https:\/\/support.microsoft.com\/en-us\/kb\/918992<\/a><\/p>\n<p>This page contains some best practices for avoiding the described issue:\u00a0<a href=\"https:\/\/aalamrangi.wordpress.com\/2015\/02\/09\/avoid-orphan-users-in-alwayson\/\">https:\/\/aalamrangi.wordpress.com\/2015\/02\/09\/avoid-orphan-users-in-alwayson\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When creating SQL 2014 AlwaysOn Availability Groups, careful attention is required when provisioning the logins on each member server. While the databases may contain user accounts for the appropriate members, the cluster member servers may not contain login information for said users. This can result in a seemingly &#8220;happy&#8221; fail over cluster (according to the &hellip; <a href=\"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">SQL AlwaysOn Availability Group User Accounts<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[8,47,109,60],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL AlwaysOn Availability Group User Accounts - Charles&#039; Blog\" \/>\n<meta property=\"og:description\" content=\"When creating SQL 2014 AlwaysOn Availability Groups, careful attention is required when provisioning the logins on each member server. While the databases may contain user accounts for the appropriate members, the cluster member servers may not contain login information for said users. This can result in a seemingly &#8220;happy&#8221; fail over cluster (according to the &hellip; Continue reading SQL AlwaysOn Availability Group User Accounts &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/\" \/>\n<meta property=\"og:site_name\" content=\"Charles&#039; Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-16T21:03:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-12-16T21:06:20+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"crossan007\" \/>\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\":\"WebSite\",\"@id\":\"https:\/\/crossan007.dev\/blog\/#website\",\"url\":\"https:\/\/crossan007.dev\/blog\/\",\"name\":\"Charles&#039; Blog\",\"description\":\"SharePoint | PowerShell | Exchange | SCCM | Ubuntu | PHP | JavaScript | A\/V Live Production | More...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/crossan007.dev\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/#webpage\",\"url\":\"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/\",\"name\":\"SQL AlwaysOn Availability Group User Accounts - Charles&#039; Blog\",\"isPartOf\":{\"@id\":\"https:\/\/crossan007.dev\/blog\/#website\"},\"datePublished\":\"2015-12-16T21:03:35+00:00\",\"dateModified\":\"2015-12-16T21:06:20+00:00\",\"author\":{\"@id\":\"https:\/\/crossan007.dev\/blog\/#\/schema\/person\/bd99569cd81332c8fd866d023848b979\"},\"breadcrumb\":{\"@id\":\"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/crossan007.dev\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL AlwaysOn Availability Group User Accounts\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/crossan007.dev\/blog\/#\/schema\/person\/bd99569cd81332c8fd866d023848b979\",\"name\":\"crossan007\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/crossan007.dev\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fff72c74fb6a0da29accf0db83ad4b4b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fff72c74fb6a0da29accf0db83ad4b4b?s=96&d=mm&r=g\",\"caption\":\"crossan007\"},\"url\":\"https:\/\/crossan007.dev\/blog\/author\/crossan007\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"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:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/","og_locale":"en_US","og_type":"article","og_title":"SQL AlwaysOn Availability Group User Accounts - Charles&#039; Blog","og_description":"When creating SQL 2014 AlwaysOn Availability Groups, careful attention is required when provisioning the logins on each member server. While the databases may contain user accounts for the appropriate members, the cluster member servers may not contain login information for said users. This can result in a seemingly &#8220;happy&#8221; fail over cluster (according to the &hellip; Continue reading SQL AlwaysOn Availability Group User Accounts &rarr;","og_url":"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/","og_site_name":"Charles&#039; Blog","article_published_time":"2015-12-16T21:03:35+00:00","article_modified_time":"2015-12-16T21:06:20+00:00","twitter_misc":{"Written by":"crossan007","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/crossan007.dev\/blog\/#website","url":"https:\/\/crossan007.dev\/blog\/","name":"Charles&#039; Blog","description":"SharePoint | PowerShell | Exchange | SCCM | Ubuntu | PHP | JavaScript | A\/V Live Production | More...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/crossan007.dev\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/#webpage","url":"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/","name":"SQL AlwaysOn Availability Group User Accounts - Charles&#039; Blog","isPartOf":{"@id":"https:\/\/crossan007.dev\/blog\/#website"},"datePublished":"2015-12-16T21:03:35+00:00","dateModified":"2015-12-16T21:06:20+00:00","author":{"@id":"https:\/\/crossan007.dev\/blog\/#\/schema\/person\/bd99569cd81332c8fd866d023848b979"},"breadcrumb":{"@id":"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crossan007.dev\/blog\/sql\/sql-alwayson-availability-group-user-accounts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/crossan007.dev\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL AlwaysOn Availability Group User Accounts"}]},{"@type":"Person","@id":"https:\/\/crossan007.dev\/blog\/#\/schema\/person\/bd99569cd81332c8fd866d023848b979","name":"crossan007","image":{"@type":"ImageObject","@id":"https:\/\/crossan007.dev\/blog\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/fff72c74fb6a0da29accf0db83ad4b4b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fff72c74fb6a0da29accf0db83ad4b4b?s=96&d=mm&r=g","caption":"crossan007"},"url":"https:\/\/crossan007.dev\/blog\/author\/crossan007\/"}]}},"_links":{"self":[{"href":"https:\/\/crossan007.dev\/blog\/wp-json\/wp\/v2\/posts\/268"}],"collection":[{"href":"https:\/\/crossan007.dev\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/crossan007.dev\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/crossan007.dev\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/crossan007.dev\/blog\/wp-json\/wp\/v2\/comments?post=268"}],"version-history":[{"count":2,"href":"https:\/\/crossan007.dev\/blog\/wp-json\/wp\/v2\/posts\/268\/revisions"}],"predecessor-version":[{"id":270,"href":"https:\/\/crossan007.dev\/blog\/wp-json\/wp\/v2\/posts\/268\/revisions\/270"}],"wp:attachment":[{"href":"https:\/\/crossan007.dev\/blog\/wp-json\/wp\/v2\/media?parent=268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/crossan007.dev\/blog\/wp-json\/wp\/v2\/categories?post=268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/crossan007.dev\/blog\/wp-json\/wp\/v2\/tags?post=268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}