Re: How to change service accounts on a cluster

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: Restoring a SSP 3.0
    ... Also make sure this accounts are configured correctly in the IIS application ... Backup ContentDB in SQL Server using SQL Managagement Studio ... Restore the ContentDB from step 1 to new env. ...
    (microsoft.public.sharepoint.portalserver)
  • RE: local admin account password
    ... Subject: local admin account password ... > 4) Only use domain accounts so delete the local ones. ... > The DB file would be encrypted with EFS so only the limited user SQL ... > backup user can make a zip backup of the DB whenever it gets changed ...
    (Focus-Microsoft)
  • RE: local admin account password
    ... Say you have more then 1000 systems, how do you handle the local admin ... Only use domain accounts so delete the local ones. ... The DB file would be encrypted with EFS so only the limited user SQL ... There would be basically two stored procs, ...
    (Focus-Microsoft)
  • RE: "login failed for user ..." appears in event viewer repeatedly
    ... OK, did I hear you right, you've determined that the attacks are coming from ... holes to that segment and/or box to just the SQL ports. ... I looked closer at the SQL accounts. ... I used SQL profiler to audit logins and login failures. ...
    (microsoft.public.sqlserver.security)
  • Re: Sql server 2005 clustered service group
    ... but they did things differently in SQL 2005 than they did in SQL 2000. ... For each clustered service in the instance of SQL Server that you are ... Note that SQL Server accounts will not be removed from the groups if SQL ... service account to the domain group, instead of letting the SQL Server ...
    (microsoft.public.sqlserver.setup)
Loading