•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 456,552 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,426 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 5318 | Replies: 1 | Solved
 |
•
•
Join Date: Jul 2005
Posts: 35
Reputation: 
Rep Power: 4
Solved Threads: 0
Light Poster
Error in creating ODBC connection."Reason: Not assosiated with a trusted SQL Server"
#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.
•
•
Join Date: Nov 2005
Location: Dubai,UAE
Posts: 36
Reputation:
Rep Power: 4
Solved Threads: 0
Light Poster
Re: Error in creating ODBC connection."Reason: Not assosiated with a trusted SQL Server"
#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\
|
•
•
•
•
•
•
•
•
DaniWeb ASP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
.net adsl adsl1 adsl2 adsl2+ ajax algos asp cable connection custom database developer development dom download feed fortitude hacker hope internet kb kbps mbit microsoft msdn network news office per reader second security skin software sql struggle survey testing theme throughput trial-and-error upload victory vista weather xml xoap 240000
- 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 / 2003)
- 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: How can I send a Crystal Report to Email through Active Server Pages (ASP)?
