Article ID: 911839 - View products that this article applies to.
This article describes how to change the Microsoft SQL Server 2005 service accounts by using the Microsoft Windows Management Instrumentation (WMI) Provider for Configuration Management. This article contains a script sample. You can use this script sample to change the SQL Server service accounts.
Permissions on the accounts that are used by SQL Server 2005 services are managed by group membership. When you try to change the SQL Server service accounts by using the Windows Service Control Manager, you must manually remove the old accounts and then add the new accounts to the corresponding groups. Therefore, we recommend that you use SQL Server Configuration Manager to change the SQL Server service accounts.
SQL Server 2005 provides the WMI Provider for Configuration Management. You can use the WMI Provider for Configuration Management to manage changes to group membership and changes to service accounts. Specifically, you can use the WMI Provider for Configuration Management in a script file to simplify the operations. For example, you can repeatedly call a script file to automate changing the SQL Server service accounts each month.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
You can use the following script sample to change the SQL Server service accounts.
To use this script sample, follow these steps:
Article ID: 911839 - Last Review: January 23, 2006 - Revision: 1.1
Contact us for more help
Connect with Answer Desk for expert help.