Celebration, Florida 34747
407-551-0777 Phone

>> Login Failed for User 'BanManProSQL', Not Associated with a trusted SQL Server Connection.


Is using SQL 2000, you might get the following error:

Microsoft OLE DB Provider for SQL Server error '80004005'

Login failed for user 'BanManProSQL'. Reason: Not associated with a trusted SQL Server connection.

/dbconnect.asp, line 19

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

  1. Enter SQL Enterprise Manager.

  2. Find your server name in the tree on the left.

  3. Right mouse click on the server name and select properties.

  4. Click the Security folder.  You should now see the screen below with "Windows Only" set as the default authentication.

  5. Check SQL Server and Windows as the Authentication.

  6. Click OK.

  7. Click Yes to restart SQL.

Copyright 1999-2015, LLC All Rights Reserved