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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-13 : 08:21:42
|
| David writes "Ok, riddle me this Batman.I am running a Win 2000 server with SQL 2000 on it. I am coding my pages in ASP. I am trying to return a recordset and display some of the information (pretty simple). All the code looks fine but when I open up the page I get this Error Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'OIA\IUSR_OIAWEB'.Its basically telling me that the OIAWEB user does not have a username to access the database.So in the course of trying to figure out all of this I created new users for the database, used the sa and its pw in the code to try and access the database with no luck. So like a good Microsoft Minion i truddled to their site and downloaded the SP1 for SQL 2000 and a fix that was supposed to take care of an authentication bug.. (this second is what got me all happy and dancing)... now however both have been installed and inspected and I have retired most everything i can thing of and blam... same error.Ok, ye of SQL Goddliness, what the He** am I doing wrong.Thanks.David" |
|
|
|
|
|
SQL User login failed