sql server clustering: changing sql server service account password -- sql server clustering

changing sql server service account password

bill
3/21/2005 4:07:31 PM

sql server clustering: SQL Server 2000 running on W2K3 Advanced Server Cluster with 2 nodes.

We have a domain level account which the MSSQLSERVER and SQLSERVERAGENT
services use.

When I change the password for this account in active directory, I also
changed the password for the services in the Services properties on both
cluster nodes

The services Startup Type has to be Manual, or else the following error
occurs:

"17050: initerrlog: could not open error log file ... (the correct path
to the error log follows)"

The error log is on the shared drive of the cluster.

Also, when the servers boot up, the following error is in Event Viewer:

"The Data portion of event 19002 from MSSQLServer is invalid"

Microsoft (Q230393) says this is a bug and ignore it, but it didn't occur
until I changed the password.

Are these normal consequences of changing the account password?
Are there other steps I should take?

Thanks
Bill

Re: changing sql server service account password

Geoff N. Hiten
3/21/2005 4:26:09 PM

Go back into Enterprise Manager and change the service accounts there. That
will fix any permissions and setup issues. Service startup type as Manual
is correct. That allows the cluster service to control the actual service
start/stop.

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator

[quoted text, click to view]