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.

are u using server 2003?
go to regedit
and change permissions to odbc to everyone, i hope it will work
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\