Re: How to change service accounts on a cluster

The problem remains - when I try to change the service account using
SQL Server Configuration Manager I always get the same error:

The network password you specified is not correct"




Geoff N. Hiten wrote:
You are correct. Configuration manager is the correct tool.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"Michael Hotek" <mhotek@xxxxxxxxxxxxxxx> wrote in message
news:upIscbtyGHA.3908@xxxxxxxxxxxxxxxxxxxxxxx
Actually, you CAN'T use SSMS to change service accounts in 2005. You need
to use SQL Configuration Manager to change the service accounts. You only
need to do this once and SQL Configuration Manager takes care of
everything else.

--
Mike Hotek
MHS Enterprises, Inc
http://www.mssqlserver.com


"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:%23JzRzSKyGHA.1304@xxxxxxxxxxxxxxxxxxxxxxx
If you use SSMS you can change the account when you are connected to the
virtual SQL instance and it will do the job cluster-wide. You need to
make sure the new accounts are in the same groups as the original
accounts. Test the accounts by logging on to the console of each server
before trying to change the service accounts.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




<tootsuite@xxxxxxxxx> wrote in message
news:1156544616.512257.306490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

Need help. Have 2005 SQL Server cluster... I need to change the service
accounts for SQL Server, SQL Server Agent, etc to a non-administrator
domain user.

What is the correct way to do this? From which node do I change the
service accounts? Do I need to change them on both nodes?

I've tried to make the changes from one of the nodes, but every time I
click "OK" it says - specified network password is incorrect. I've
confirmed with our sysadmin here that it IS the correct password for
the domain user.

I'm not even sure if I'm approaching this correctly. Help.

Thanks,
Kat






.

Relevant Pages

  • Re: SQL 2000 Problems on One Node Only
    ... Since both the Cluster and SQL Server service accounts are Local ... how is SQL Server set up to allow Local Administrators to log into SQL ...
    (microsoft.public.sqlserver.clustering)
  • SQL Server Setup could not validate the service accounts
    ... Microsoft SQL Server 2005 Setup ... SQL Server Setup could not validate the service accounts. ... or the specified username or password is incorrect. ... service, specify a valid username, password, and domain, or specify a ...
    (microsoft.public.sqlserver.setup)
  • RE: SQL Server Setup could not validate the service accounts
    ... Microsoft SQL Server 2005 Setup ... > SQL Server Setup could not validate the service accounts. ... or the specified username or password is incorrect. ... > service, specify a valid username, password, and domain, or specify a ...
    (microsoft.public.sqlserver.setup)
  • Re: How to change service accounts on a cluster
    ... Configuration manager is the correct tool. ... Microsoft SQL Server MVP ... to use SQL Configuration Manager to change the service accounts. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL server disable in active directory
    ... Did you switch the SQL Server service accounts from Local System to Local or Domain User accounts or was there a switch in the service account names? ...
    (microsoft.public.sqlserver.server)