Member Avatar for k_en

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.

  • 2 Contributors
  • 1 Reply
  • 228 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by noman78
Member Avatar for noman78

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\

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.