http://sqlblogcasts.com/blogs/markallison/default.aspxselect experiences from workingInTheFieldenCommunityServer 2007.1 (Build: 20917.1142)http://sqlblogcasts.com/blogs/markallison/archive/2009/09/01/cluster-service-login-missing-from-sql-server-how-to-recover.aspx#12402Sun, 11 Oct 2009 04:39:02 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12402adamsjs<p>Good post... helped me out tonight. &nbsp;Did the same thing, and already had two running SQL Server instances on the cluster that I could not afford to take down/failover. &nbsp;I waited out the AD replication after adding the cluster service account to a domain group with access to the newly-installed third instance, but still had issues getting the service to run. &nbsp;Figured out that the cluster service needed a restart, but I obviously didn't want to take down the running instances on the active node. &nbsp;So, here's what I did:</p> <p>The running instances were both running on the same node of a three-node cluster. &nbsp;After adding the cluster service to a group that had access to the newly installed instance, I moved the resource group for the new instance to one of the non-active nodes, restarted the cluster service on that node (to pickup the new group membership), and verfied the instance could be brought online. &nbsp;I then restarted the cluster service on the other non-active node, and moved the new instance that node.</p> <p>To convince myself that I was correct in my thinking, I tried to move the resource group back to the node where the other two active instances were running (where the new instance had been running when I removed the cluster service account's access). &nbsp;It would not come online (as expected). &nbsp;I brought the instance online on one of the other nodes, created the login for the cluster service account, moved the instance to the original node, and it came online. &nbsp;Lastly, I removed the cluster service account from the domain group to which it had been added.</p> <p>Hope this helps the next person out.</p> <img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12402" width="1" height="1">http://sqlblogcasts.com/blogs/markallison/archive/2009/09/01/cluster-service-login-missing-from-sql-server-how-to-recover.aspx#12220Tue, 01 Sep 2009 17:48:57 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12220SqlServerKudos<p>Kudos for a great Sql Server article - Trackback from SqlServerKudos</p> <img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12220" width="1" height="1">http://sqlblogcasts.com/blogs/markallison/archive/2008/01/30/how-to-change-my-pk-to-identity.aspx#6516Thu, 31 Jan 2008 08:07:34 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:6516GrumpyOldDBA<p>well I don't necesscarily agree that identity columns are the best solution - a real pain ina replicated database for instance. ?</p> <img src="http://sqlblogcasts.com/aggbug.aspx?PostID=6516" width="1" height="1">