Microsoft KB Archive/289633

= Error Message: Server: Msg 18452, Level 16, State 1[Microsoft][ODBC SQL Server Driver][SQL Server] =

Article ID: 289633

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition
 * Microsoft Site Server 3.0 Commerce Edition

-



This article was previously published under Q289633



SYMPTOMS
When a user creates a Commerce Store, the following error message may occur when the user attempts to connect to a SQL Server database:

Unable to connect to server :

Server: Msg 18452, Level 16, State 1[Microsoft][ODBC SQL Server Driver][SQL Server]

Login failed for user '?'.

Reason: Not associated with a trusted SQL Server connection.



CAUSE
This error can occur when the user's SQL Server authentication method is set to Windows NT Authentication Mode. If the authentication method is changed on the SQL Server computer, the changes do not take place until the next time the computer is restarted. This can also occur if you set up a SQL Server 2000 computer by using the Setup Wizard and perform a typical installation or by using the Sqlins.iss file for a typical unattended installation. The default security authentication mode is Microsoft Windows NT Authentication, which is different from Microsoft SQL Server 7.0. In SQL Server 7.0, the default authentication is Mixed Mode (Windows NT Authentication Mode and SQL Server Authentication). For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

269587 INF: Windows Authentication is the Default Security Mode



RESOLUTION
To change the authentication mode from Windows NT Authentication Mode (only) to Mixed Mode, use the following steps:
 * 1) Open the Enterprise Manager.
 * 2) Click to expand the server group.
 * 3) Right-click the server name, and then click Properties.
 * 4) Click the Security tab.
 * 5) Under Authentication, click the SQL Server and Windows option button.

NOTE: You may need to retype the &quot;SA&quot; password in the DSN.

Additional query words: &quot;sa&quot; &quot;iusr&quot;

Keywords: kbprb KB289633

-

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

© Microsoft Corporation. All rights reserved.