Re: How to change service accounts on a cluster

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: Restore access for sql service accounts
    ... SQL Server grant the need rights when you change the service account, ... Unfortunately, all service accounts of sql are not running anylonger, I ... assume the ahtorisation was reset to an initial value I don't know of. ...
    (microsoft.public.sqlserver.security)
  • Re: Changing Windows Domain
    ... are you saying to not start SQL through the Services applet as ... opposed to starting it through Cluster Administrator after completing the ... Make sure the service accounts have the ... >> Windows 2003 Active Directory Domain. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL service accounts
    ... I'm a SQL Server DBA - there is no good reason to make the service accounts domain admin. ... The service accounts do need to be given access to certain registry keys, NTFS file permissions and be given certain user rights on the local machine. ... This is done for you when you change the account using the built-in SQL Server tools rather than using the services mmc. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Changing Windows Domain
    ... Do not start SQL through the Services applet. ... prefer to use the Cluster admin tool. ... Make sure the service accounts have the ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
Loading