SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Change SQL Server Service Accounts with Powershell

By Michael D'Spain ,

I needed to change SQL Server Account and Agent Account names and passwords across 15 servers due to a compliance issue.  This script can streamline that process for you.   I have included detailed comments in the script.  This script is not a fire and forget script.  You must interact with the script to validate that a successful backup was taken prior to making any changes.  

If each instance that is to have an account changed needs a different name and password a variable will need to be added dynamically pass that into the script. 

I hope you find this useful.  

Michael 

http://thesurfingdba.weebly.com/

Total article views: 513 | Views in the last 30 days: 9
 
Related Articles
SCRIPT

Changing database mail account SMTP servers

This will generate a script that drops and recreates existing db mail accounts and change the smpt s...

FORUM

Auditing Account creation/changes

Trying to audit account creation and permission changes

FORUM

how to properly change the service accounts

how to properly change the service accounts

FORUM

CHANGING DB-OWNERSHIP TO SA ACCOUNT

CHANGING DB-OWNERSHIP TO SA ACCOUNT

FORUM

How to change dbo-login account is changed from DOM1\SQL_AC1 to DOM2\SQL_ACC1

Changing dbo_login Account to differnt one

 
Contribute