Hi

we do have two node SQL cluster on windows 2003
mssqlserver,sqlserveragent and clusterservice are using
same service account.
We need to change password for these service..
is there any article on how to change the password for sql
service and cluster service account on cluster

any pointers and suggestion would be highly appreciated

Thanks
gubba

It is best to do this using Enterprise Manager. Please refer to Books
Online topic "Changing Passwords and User Accounts".

You can download the latest SQL Server 2000 Books Online from
http://www.microsoft.com/downloads/d...1A6-BCF4-45A6-
A2E2-F6AB5BE3EF12&displaylang=en

Hope this helps,
Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Hi

Thanks for the reply,
i understood how to change password from Enterprise
manager but
changing password for one virtual server is enough or do
we need to change the password on other virtual server on
SQL Cluster

How many virtual SQL Servers do you have ? If you have one virtual SQL
Server and you want to change the password for the service accounts then
you need to do it once for the SQL Server Service and SQL Server Agent
service for that particular virtual SQL Server using SEM. This the same
that you would have done for a standalone (non-virtual) SQL Server.

Here are some knowledge base articles that you may find helpful

INF: How to Change Service Accounts on a SQL Virtual Server
http://support.microsoft.com/default...;en-us;Q239885

How to Change the Cluster Service Account Password
http://support.microsoft.com/?id=305813

HTH,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

For each SQL virtual server, you must change it in EM for
each instance. It is not a change once, apply to each
instance thing.

On Thu, 25 Dec 2003 02:03:25 -0800, "gubba"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Gubba,

Try this KB article :

INF: How to Change Service Accounts on a SQL Virtual Server
http://support.microsoft.com/default...;en-us;Q239885


Regards,

Paul Lynch
MCSE