Change MSSQLSERVER Service password on all SQL Instances

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Change MSSQLSERVER Service password on all...

Change MSSQLSERVER Service password on all SQL Instances

Rate Topic

Display Mode

Topic Options

Author

Message

franck.bots

Posted Wednesday, February 06, 2013 5:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 7:30 AM
Points: 2, Visits: 13

Hi SQL experts!

Problem of the week to solve is to change the SQL Server Service account (MSSQLSERVER) password. I use a domain account to run like a hundred SQL instances (SQL 2005 and SQL 2008 mostly). I have been ask to change this account password and i don't want to have to do it manually on every server.
Is there a way to script this change?

Thanks for your help!

Franck

Post #1416425

opc.three

Posted Wednesday, February 06, 2013 9:53 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:26 PM
Points: 6,696, Visits: 11,715

My first thought was to use PowerShell. Here is a script that looks promising

http://gallery.technet.microsoft.com/scriptcenter/79644be9-b5e1-4d9e-9cb5-eab1ad866eaf

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1416804

franck.bots

Posted Friday, February 08, 2013 1:17 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 7:30 AM
Points: 2, Visits: 13

Thanks opc.three!
I'm gonna try this on fex dev servers before going to prod.

Post #1417498

« Prev Topic | Next Topic »

Permissions