Article ID: 2019402 - View products that this article applies to.
Consider the following scenario:
In this scenario, if you try to add a new node to an existing instance, the SQL Server Setup program fails, and you receive the following error message:
The security ID (SID) that was originally assigned to the domain group is no longer valid. Changing the domain groups that are used for SQL Server 2008 Failover cluster installation is not supported. This is because the security configuration information is set by using the SID of the domain groups that are used during the original setup. An example of such security configuration information is an access control list on files and folders that are used by the SQL Server Failover instance. Even though you re-create the domain group by using the same name, the SID will be different. Therefore, the permission set of the original SID is no longer valid.
Note: Domain migration for SQL Server 2008 Failover Cluster instance is also not supported.
Reinstall the SQL Server Failover instance.
Note This issue was first fixed in SQL Server 2008 Service Pack 2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
968382 How to obtain the latest service pack for SQL Server 2008
If the domain local groups are deleted and re-created, you might receive the following error message when you try to start the SQL Server service:
initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).
Article ID: 2019402 - Last Review: August 25, 2010 - Revision: 6.0