Re: Problem: Changing the SQL Server services password - round 2

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ok, new saga...........................
Tried changing SQL Server 2005 service passwords on a second unrelated
cluster (Only difference was W2K3 R2).
Same problem.
Even with the [/computer:SQLSVR] as a parameter, the SSCM will only update
one node (the node that SSCM was running on), not both. The SSCM did show
that it was connected to the virtual SQL Server not "local".

As the passwords were set to expire (no hope of an extension) , I tested
this in VMWARE numerous times.
Having done this kind of hack on SQL Server 2000 (when passwords expired) I
hoped it would be the same in 2005.

The process I used to change the SQL Server 2005 service account passwords
is:
This appears to have worked every time, no errorr or complaints from any
service or log.

1) On Node 1, change the passwords in SSCM. (This node owns the SQL Server
resource group)
2) On Node 1, in SSCM, restart the SQL Browser service.
3) On Node 2, change the SQL Server services password in Services Manager
(services.msc). (This is done so that the services will start on Node 2,
otherwise they will fail due to password mismatch.)
4) On Node 2, restart the SQL Browser service (in SSCM or services.msc).
5) Move the SQL Server resource group to Node 2 (So that the services will
start on Node 2 and you can connect with SSCM)
6) On Node 2, start the SSCM and change the services account passwords. (in
case there are any registry items that needed updating because I went
through services.msc instead of SSCM)
7) Then I move the SQL Server resource groups a couple of times from node to
node to verify all is well.


BTW - the command line cluster service password change
(http://support.microsoft.com/default.aspx/kb/305813)
worked like a dream. Thanks MS. All without a restart. And a nice output
telling you all the nodes that it was successful on.





"frankm" <frankm@xxxxxxxxxxxxxxxx> wrote in message
news:Y-udnWYjFKbkhpHXnZ2dnUVZ_gCdnZ2d@xxxxxxxxxxxxxxxxx
I have a Windows Server 2003 Enterprise Edition sp2 - 2 node cluster.
Installed is SQL Server 2005 sp2 across both nodes.

I am logged into the node (node 1) that owns the resources.
I am using the command line [C:\WINDOWS\system32\mmc.exe /32
"C:\WINDOWS\system32\SQLServerManager.msc" /computer:SQL2005] [SQL2005 is
the virtual server] to change the passwords.

When I try to change the SQL Server service account password through SQL
Server configuration manager, it looks like only one nodes 1's services
are changed.
When I move the group to the second node (node 2), both FullText and
SQLServer fail (Agent doesn't have a chance to start because of the
dependencies.)

I thought that the above for SSCM would change all the services across all
cluster nodes.
To actually change the password I have had to go to the plain old
services.msc, change the passwords there,
then move the sql group to that node (this allows the services to start on
that node) then using the SSCM on node 2 with the same command line start
as above, I change the passwords there. This seems to right the wrong I
did when I had to use services.msc.

Any ideas of what is wrong or what I may be doing wrong?
Thnaks in advance.
frankm



.

Relevant Pages