Microsoft KB Archive/198168

= BUG: Problems Might Occur When You Change Account Information for SQL Server Cluster =

Article ID: 198168

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q198168



BUG #: 52892 (SQLBUG_70)



SYMPTOMS
If the cluster group that contains the SQL Server virtual server is taken offline, you cannot successfully change the Microsoft Windows NT account information under which the SQL Server service runs.

WARNING: If you do attempt to change the account information (such as account name or password) while SQL Server is clustered, the service fails to start when you try to bring the cluster group online.



CAUSE
With the cluster group offline, any attempts to change SQL Server service account information cause the password to change but not the account name. As a result, the SQL Server service fails to be validated by Windows NT security, and thus cannot be started successfully.



How to Change SQL Service Accounts on a Clustered SQL Server
The proper steps necessary to change the service startup accounts for a clustered SQL Server follow.  Make sure that the SQL Server Virtual Servers resource group is owned by the node on which it was initially installed. Run the Cluster Failover Wizard and select the option to remove the SQL Server Virtual Server. Change the service accounts for the MSSQLServer and/or the SQLExecutive or SQLServerAgent to the accounts you want. This account must be a valid domain account and should be in the local Administrators group on both nodes of the cluster. Also, the account must have the following rights:  Act as part of the operating system. Logon as a service. Logon locally.</li></ol> </li> Run the Cluster Failover Wizard to add back the SQL Server Virtual Server.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Additional query words: node domain local system info

Keywords: kbbug kbpending KB198168

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.