Article ID: 321698 - View products that this article applies to.
This article was previously published under Q321698
If you try to open a SqlConnection object to a new installation of Microsoft SQL Server 2000 Data Engine (MSDE 2000) under the following conditions, a SqlException exception may by thrown:
If the exception is caught by a try-catch block, you receive the following error message:
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
The default authentication mode for MSDE 2000 is Windows Authentication. MSDE 2000 installs with a built-in system administrator (SA) user account. However, because SQL Server Authentication is disabled by default, you cannot access the built-in account after a typical installation.
To enable SQL Authentication, use one of the following methods:
285097Note When you change the default login authentication mode from Windows NT authentication to SQL authentication, we recommend that you change the sa password to a strong password.
(http://support.microsoft.com/kb/285097/ )How to change the default login authentication mode to SQL while installing SQL Server 2000 Desktop Engine by using Windows Installer
For more information about how to change the SQL Server sa password, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/322336/ )How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition
If Microsoft SQL Server is installed on the same network as MSDE 2000, and if your network is using an NT Domain, you may be able to use the SQL Server Enterprise Manager utility to connect to your instance of MSDE 2000 and to enable Mixed Mode Authentication.
By disabling the built-in user account with a blank password, MSDE 2000 is kept more secure after a default installation. If you enable SQL Server Authentication, it is crucial to the security of your system that you immediately create a password for the SA account. To do this, you can use the sp_password stored procedure in the osql command-line utility that is installed with MSDE 2000. For more information, see the "References" section of this article.
Steps to reproduce the behavior
For more information about connecting to Microsoft Desktop Engine, click the following article number to view the article in the Microsoft Knowledge Base:
319930For more information about using Windows Installer if you are customizing setup for SQL Server 2000 Desktop Engine, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/319930/ )How to connect to an instance of SQL Server Desktop Edition or of SQL Server 2005 Express Edition
227091For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/227091/ )Command-line switches for the Microsoft Windows Installer Tool
325022For more information, visit the following Microsoft Web sites:
(http://support.microsoft.com/kb/325022/ )MSDE security and authentication
SQL Server Enterprise Manager
How to set up Mixed Mode security
Using the osql utility
SQL Server 2000 Desktop Engine (MSDE 2000)
Integrating MSDE 2000 with your Applications
Article ID: 321698 - Last Review: April 28, 2007 - Revision: 3.8