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 - 2005-04-27 : 08:05:15
|
| Crystal writes "HiMy sql server was recently upgraded and I am getting this error when I try to connect thru asp program.Microsoft OLE DB Provider for ODBC Drivers error '80040e4d' [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'OFFICE\IUSR_SERVER'. Please help.Crystal." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-27 : 08:12:16
|
Ahhhhh, I just went through this hellish nightmare joyous experience and had a similar problem. Make sure that the login in question has been granted access to the SQL Server (Enterprise Manager->Security Tab->Logins) If the login doesn't appear there then add it, and check the databases it requires access to.Other login/user related problems you might have:-Users mismatched to logins, this can fix it: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12615-Users missing from or have wrong permissions in tempdb-Jobs assigned to missing logins-Logins missing from server roles (sysadmin, etc.) |
 |
|
|
|
|
|
login failed for user