Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
max_tcs
Starting Member
1 Post |
 Posted - 2002-03-07 : 23:26:45
|
| i'm a newbie of Ms.SQL Server, and i'm i'm building a data entry form with using ASP.i got confused the setting of ODBC asministrator configuring, the error message is: Connection failed: SQLState: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'admin'. Reason: No assicoated with a SQL Server Connection.this error message pop up when i choose wiith SQL server authentication using login ID and password entered by the userPlus, is there any SQL Server giude line website recommended for new user?thousand of thanks ............. |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-03-08 : 00:10:09
|
quote:
Plus, is there any SQL Server giude line website recommended for new user?
This is it! So - can you access the SQL server via Enterprise Manager?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-03-08 : 07:59:19
|
| I am assuming that you have a form on one page that accepts user input for username and password and then you are posting the form to an asp page. From the way it sounds, the ODBC driver is not finding the variable you have set up for username. Since the username (as far as ODBC is concerned) is blank, it defaults to a NT login. My suggestion is to comment out the section of your code that accesses the database and do a Response.Write for your username and password variables. Then you can see if the variable actually has a value in it when you complete your connect string.If the variables do have values, post some code here and I am sure someone will be able to figure out the problem.Jeremy |
|
|
|
|
|
|
SQL Server2000 & ODBC helps .. (very emergent!!)