I have a problem creating a ODBC connection. I am using MS SQL server 2000. Local access. I create it in System DSN.

1. I select the "With SQL Server authentication using a login ID and password entered by the user rather than Windows NT. But the error message occur "Connection Failed: SQLState:'28000' SQL Server Error: 18452[micorsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'user1'. Reason: Not assosiated with a trusted SQL Server connection." after i click the OK button.

2. I have change the SQL server properties (configure) in the SECURITY tab under authentication from Windows only to SQL Server and Windows.

3. I'm using IIS version 5.1

Anyone has any idea on solving this problem.

11 Years
Discussion Span
Last Post by noman78

are u using server 2003?
go to regedit
and change permissions to odbc to everyone, i hope it will work

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.