Article ID: 269587 - View products that this article applies to.
This article was previously published under Q269587
After a Typical installation of Microsoft SQL Server 2000 or of Microsoft SQL Server 2005, Windows Authentication is the default security mode. Therefore, after you install SQL Server 2000 and you attempt to connect to the SQL Server server by using a standard login like system administrator (SA), you may receive the following error message:
Unable to connect to server SERVER_NAME:
Server: Msg 18452, Level 16, State 1[Microsoft][ODBC SQL Server Driver][SQL Server]
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
SQL Server 2000 has three types of installations:
After you set up a SQL Server 2000 server by using the Setup Wizard to 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 mode is Mixed (Windows NT Authentication Mode and SQL Server Authentication).
You cannot use a SQL Server Standard security login account after a Typical installation of SQL Server 2000 until you change the authentication mode to Mixed.
To change the authentication mode from Windows NT Authentication Mode (only) to Mixed Mode, use the following steps:
Article ID: 269587 - Last Review: February 22, 2007 - Revision: 4.3
Contact us for more help
Connect with Answer Desk for expert help.