| Q/. Login Failed for User 'ADMIN', Not Associated with a trusted SQL Server Connection. A/. When using SQL Server, you might get the following error:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'Admin'. 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:
- 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.
printable version Back to Main Page | 
