Microsoft KB Archive/200783

= SQL Server standard security in SMS 2.0 =

Article ID: 200783

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q200783



SUMMARY
SQL Server standard security means that in order to connect to a SQL Server database, you must enter a user account and password. If you use the SMS Express Setup option in SMS 2.0, the SA account is used to access the database. If you use the Custom Setup option, SMS Setup prompts you to specify the account you want to use when the system accesses SQL Server.

No other accounts are necessary, because Windows Management Instrumentation (WMI) security controls access to the SMS site database. This is the maximum security option.

Tip:

To maximize security, you must set a strong password on the SQL SA account and configure SQL Server to use Windows Authentication only. Very few people should know the SA password. Create a different user account with access only to the SMS site database within SQL Server, and use that account in case anyone accesses the SMS site database directly. However, direct access to the database is not necessary because of the SMS Site Database provider in version 2.0.

Additional query words: prodsms smssql

Keywords: kbinfo KB200783

-

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

© Microsoft Corporation. All rights reserved.