Compartir a través de

SETUP - SQL 2005 and domain groups best practices

  • Artículo

Unlike SQL 2000, SQL 2005 setup on a cluster now requires you to provide domain groups for each clustered service – like SQL Database Engine, SQL Agent, FTS, Analysis Services.

Many customers have asked me interesting questions about domain groups and I wanted to take a moment to address them through this blog.

First, I would like everybody to read this KB article published by Microsoft which provides some of the best practice recommendations for using domain groups – KB 915846

Special considerations

The most important thing to understand about domain groups is that you CANNOT change them after installing SQL Server 2005 cluster.

If you want to change them, then you have to re-install SQL Server. Refer to the above KB on how to do this.

If you were to move your SQL Server 2005 cluster from one domain to another and decided to change the domain groups, you will have to re-install SQL Server. Refer to the above KB on how to do this.

Hope this helps!

Comments

  • Anonymous
    June 15, 2006
    TechEd is almost over and there hase been some great content for all aspects of development. Those of...
  • Anonymous
    September 19, 2006
    I disagree with this statement:"If you were to move your SQL Server 2005 cluster from one domain to another and decided to change the domain groups, you will have to re-install SQL Server."See my blog post for instructions on how to move a SQL 2005 cluster without reinstalling SQL. We're 4 weeks in with no problems at this point.http://dbaiq.blogspot.com/2006/07/changing-domain-for-sql-2005-cluster.html