Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 886089 - Last Review: October 27, 2006 - Revision: 1.2
You cannot reset the site database connection to use Windows Authentication for the SQL Server account in the Systems Management Server (SMS) Administrator Console in SMS 2003
After you modify Microsoft Systems Management Server (SMS) 2003 site properties to specify a Microsoft SQL Server account, you cannot reset the site database connection to use Windows Authentication.
After you try to reset the site properties to use Windows Authentication by entering blank information for the SQL Server account, you receive an error message that is similar to the following:
Please enter a SQL Server user name.
This problem occurs because the SMS Administrator Console does not provide an interface to configure the SQL Server connection to use Windows Authentication.
To work around this problem, run a site reset, and then select Windows Authentication for the SQL Server connection. To do this, follow these steps:
- Click Start, point to All Programs, point to Systems Management Server, and then click SMS Setup.
- Click Next two times. The Setup Options page appears.
- Click Modify or reset the current installation, and then click Next three times.
- On the Authentication mode for SMS Site Database page, click Yes, use Windows Authentication, click Next, and then click Finish to complete the wizard.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
The SQL Server account lets SMS services access the SMS site database. Each primary site requires a SQL Server account. The SQL Server account can use either SQL Server Authentication or Windows Authentication.
Note SQL Server Authentication was previously named standard security. Windows Authentication was previously named integrated security.
When you specify SQL Server Authentication, you enter a user account and password to use to connect to a SQL Server database. When you specify Windows Authentication, SMS uses the SMS Service account to access the SQL Server database.
APPLIES TO
- Microsoft Systems Management Server 2003
| kbtshoot kbsmssecurity kbsmsadmin kbwinservperf kbmgmtservices kbprb KB886089 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate