Knowledgebase

error:Login Failed for User 'testSQL', Not Associated with a trusted SQL Server Connection

This error occurs because by default SQL 2000 does not support SQL Server authentication and supports only Windows authentication. To overcome this limitation:

Enter SQL Enterprise Manager.
Find your server name in the tree on the left.
Right mouse click on the server name and select properties.
Click the Security folder. You should now see the screen below with "Windows Only" set as the default authentication.
Check SQL Server and Windows as the Authentication.
Click OK.
Click Yes to restart SQL.

Add to Favourites

Print this Article

Also Read

Microsoft OLE DB Provider for ODBC Drivers error '80004005' (Access Driver) Not a valid password... (Views: 664)

error: file already in use (Views: 677)

ERROR 2008: MySQL client ran out of memory (Views: 671)

Can I connect to your MS SQL 2000 server with MS SQL 7.0 Enterprise Manager? (Views: 686)

error:Why do I get the error 8000045 when running my MS Access scripts? (Views: 668)