Ever encountered this problem “Not associated with a trusted SQL Server connection”?

Well you probably didn`t specify “Mixed Mode authentication” during the installation.

Well this error occurs because by default SQL 2000 does not support SQL Server authentication and supports only Windows authentication.

To solve this problem

1. Open The SQL Server Enterprise Manager
2. Expand the tree-control until you can your server
3. Right click on the server name((local)(Windows NT)) and “SQL Server Properties
4. Select the Security tab
5. For “Authentication”, select “SQL Server and Windows”
6. Click “OK” to close the window and then “Yes” to restart SQL Server