 |  |  |  |  |  |  |  |
Error in creating ODBC connection."Reason: Not assosiated with a trusted SQL Server"
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
Error in creating ODBC connection."Reason: Not assosiated with a trusted SQL Server"
0
#1 Jan 25th, 2007
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.
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.
Re: Error in creating ODBC connection."Reason: Not assosiated with a trusted SQL Server"
0
#2 Jan 25th, 2007
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\
go to regedit
and change permissions to odbc to everyone, i hope it will work
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\
 |
Similar Threads
- SQL DB Connection Problems (MS SQL)
- data base connection in vb.net (VB.NET)
- Error is [Microsoft][ODBC SQL Server Driver]Connection is busy (JSP)
- ODBC connection (PHP)
- SQL server error: 18452 - connection to SQL error (Windows NT / 2000 / XP)
- Error creating new ASP.Net project (ASP.NET)
- Error Creating Folder message during installation (OS X)
- odbc administrator (Visual Basic 4 / 5 / 6)
Other Threads in the ASP Forum
- Previous Thread: No Error, No Insert: ASP to Access
- Next Thread: Select + update not working together
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest ASP Posts
- Today's Posts
- Unanswered Threads
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection connection database databaseconnection dreamweaver excel fso iis msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption single specfic sqlserver sqlserverconnection windows7
