944,120 Members | Top Members by Rank

Web Development > ASP > Error in creating ODBC connection."Reason: Not assosiated with a trusted SQL Server"
Ad:
  • ASP Discussion Thread
  • Marked Solved
  • Views: 8445
  • ASP RSS
Permalink
Jan 25th, 2007
0

Error in creating ODBC connection."Reason: Not assosiated with a trusted SQL Server"

Expand Post »
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.
Similar Threads
Reputation Points: 13
Solved Threads: 0
Light Poster
k_en is offline Offline
35 posts
since Jul 2005
Permalink
Jan 25th, 2007
0

Re: Error in creating ODBC connection."Reason: Not assosiated with a trusted SQL Server"

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\
Reputation Points: 10
Solved Threads: 0
Light Poster
noman78 is offline Offline
40 posts
since Nov 2005

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP Forum Timeline: No Error, No Insert: ASP to Access
Next Thread in ASP Forum Timeline: Select + update not working together





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC