Microsoft KB Archive/130941

= How to Change the SQL Login ID for the SMS Database =

Article ID: 130941

Article Last Modified on 6/14/2005

-

APPLIES TO


 * Microsoft Systems Management Server 1.0 Standard Edition
 * Microsoft Systems Management Server 1.1 Standard Edition

-



This article was previously published under Q130941



SUMMARY
System Management Server uses a SQL Login Id to manage the its database on a SQL Server. Systems Management Server uses the SQL Server System Administrator (SA) account by default. The following procedure outlines how to change the SQL Login Id.



MORE INFORMATION
 Use the SQL Server Administrator Utility to login to the SQL Server 4.21a (or later) containing the Systems Management Server database. Login with an SA account. Open up the System Logins Window. If the Login Id you intend to use already exits on the SQL server proceed with Step 5. Choose Manage/Add Login... Specify the Login ID and password in the appropriate fields and choose OK. Open the Query Window. In the Query Window, type the following information:

use SMS

go

sp_changedbowner "login id", true

go

 Execute the Query.</li> Run the System Management Server setup utility on the Primary Site Server.</li> Choose continue, then choose Operations.</li> Choose SMS Database.</li> Change the Login ID and password.</li> Choose OK.</li></ol>

The Setup program will restart the Systems Management Server services. Once this has completed the setup program can be exited.

NOTE: The Login ID that you give to Systems Management Server should not be a user of the database prior to executing Step 6. If the Login ID is a user of the database, drop the Login ID from the database before proceeding with Step 6.

Additional query words: prodsms sms loginid login_id

Keywords: kbdatabase kbnetwork kbsmsadmin KB130941

-

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

© Microsoft Corporation. All rights reserved.