Re: How to change service accounts on a cluster

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 server 2005 clustered service group
    ... I always do this as part of cluster setup (prepoulate the groups with the ... Jasper Smith (SQL Server MVP) ... add accounts to the domain groups. ... needs rights to add the service accounts to the domain group ...
    (microsoft.public.sqlserver.setup)
  • Re: Sql server 2005 clustered service group
    ... Jasper Smith (SQL Server MVP) ... administrator for the names of existing domain groups, ... add accounts to the domain groups. ... needs rights to add the service accounts to the domain group ...
    (microsoft.public.sqlserver.setup)
  • Re: How to change service accounts on a cluster
    ... SQL Server Configuration Manager I always get the same error: ... to use SQL Configuration Manager to change the service accounts. ... click "OK" it says - specified network password is incorrect. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Newbie question on SQL connection
    ... > Let me educate you about SQL Server security. ... granting permissions to these accounts in SQL ... > maintain its own user accounts, which are separate from domain user ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Sql server 2005 clustered service group
    ... For each clustered service in the instance of SQL Server that you are ... administrator for the names of existing domain groups, ... Note that SQL Server accounts will not be removed from the groups if SQL ... I see with installing SS2005 cluster if forces me to use domain accounts ...
    (microsoft.public.sqlserver.setup)