Microsoft KB Archive/911839

= How to change the SQL Server 2005 service accounts by using the Windows Management Instrumentation (WMI) Provider for Configuration Management =

Article ID: 911839

Article Last Modified on 1/23/2006

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Workgroup Edition

-





SUMMARY
''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.''



INTRODUCTION
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.



MORE INFORMATION
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. Set oArgs = WScript.Arguments

' Verify the inputs.

If oArgs.Count <> 5 Then WScript.Echo &quot;Usage: ChangeSQLServiceAccounts.vbs MachineName InstaNcename ServiceType SQLAccount SQLPassword&quot; WScript.Echo &quot;ServiceType = 1 (SQLServer), 2 (Agent), 3 (FTE), 4 (DTS), 5 (AS), 6 (RS), 7 (Browser)&quot; WScript.Echo &quot;Example: ChangeSQLServiceAccounts.vbs. MSSQLServer 1 BuiltIn\System NULL&quot; WScript.Quit(1) Else

' Load the inputs into variables.

strComputer = oArgs(0) strInstanceName = oArgs(1) strServiceType = oArgs(2) strAccountName = oArgs(3) strPassword = oArgs(4) End If

' Get a WMI object for the SQL namespace.

Set objWMIService = GetObject(&quot;winmgmts:&quot; & &quot;{impersonationLevel=impersonate}!\\&quot; & strComputer & &quot;\ROOT\microsoft\sqlserver\ComputerManagement&quot;)

' Get an instance for this specific service.

Set objSQLService = objWMIService.Get(&quot;SqlService.ServiceName=&quot;&quot;&quot; & strInstanceName & &quot;&quot;&quot;,SQLServiceType=&quot; & strServiceType)

' Obtain an InParameters object specific to the SQLService.SetServiceAccount method.

Set objInParam = objSQLService.Methods_(&quot;SetServiceAccount&quot;).inParameters.SpawnInstance_

' Add the input parameters to the input object.

objInParam.Properties_.item(&quot;ServiceStartName&quot;) = strAccountName objInParam.Properties_.item(&quot;ServiceStartPassword&quot;) = strPassword

' Call the SetServiceAccount method, and pass in the input object.

Set objOutParams = objSQLService.ExecMethod_(&quot;SetServiceAccount&quot;, objInParam)

'Check the return to see whether there were any errors.

If objOutParams.ReturnValue = 0 Then Wscript.Echo &quot;The service account was changed to &quot; & strAccountName Else Wscript.Echo &quot;Could not change the service account to &quot; & strAccountName & &quot; due to error &quot; & objOutParams.ReturnValue End If To use this script sample, follow these steps:
 * 1) Copy the code into a text file, and then save the file as ChangeSQLServiceAccounts.vbs.
 * 2) At a command prompt, locate the folder that contains this file, type ChangeSQLServiceAccounts, and then press ENTER.

Keywords: kbinfo kbexpertiseadvanced kbsql2005setup KB911839

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.