|
|
 |
| Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Databases section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
January 13th, 2008, 09:21 AM
|
|
Registered User
|
|
Join Date: Nov 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Login failed for user.
I'm getting the following error when I try to connect to MSDE from my web app:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'User'.
However, I can login via Enterprise Manager with the User I have created with no problems.
The user has been setup with all the appropriate permissions, etc. It's an SQL Server login and the server is running in Mixed mode.
The connection string I'm using is:
DSN=CorpEventsSQL;Uid=User;Pwd=;Password;Trusted_C onnection=yes
Now, as far as I can tell, there's absolutely nothing wrong with that string so I'm stumped!
Have I missed something?
|
January 13th, 2008, 09:29 AM
|
 |
Wrox Author
Points: 33,563, Level: 80 |
|
|
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 10,231
Thanks: 7
Thanked 203 Times in 201 Posts
|
|
Hi there,
There *is* something wrong with the connection string: you have Trusted_Connection=yes in there. With that setting the database is accessed in the context of the calling user (for example, the IUSR_MachineName account) and NOT with the user name and password from the connection string.
You should change your connection string to something like:
DSN=CorpEventsSQL;Uid=User;Pwd=;Password
For more info:
http://www.connectionstrings.com/
http://www.connectionstrings.com/?carrier=dsn
Cheers,
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004 |
January 13th, 2008, 10:01 AM
|
|
Registered User
|
|
Join Date: Nov 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Ok, I've now removed that, but I still have the same error.
|
January 13th, 2008, 01:23 PM
|
|
Wrox Author
Points: 33,563, Level: 80 |
|
|
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 10,231
Thanks: 7
Thanked 203 Times in 201 Posts
|
|
Could it be an incorrect password after all?
Or maybe User has the right password, but no access to the database defined in the DSN? Try renaming your user, and see what happens. Also, if possible, try replacing the DSN file with a "proper" connection string.
Cheers,
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post. |
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
