Problem: Any attempt to update the DB is denied in SQL Server 2008 R2 using SQL in classic ASP page.
In a nutshell, can read, but can't update/write to DB using SQL in ASP page
Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user
It has taken me more than 6 hours to troubleshoot, but still no answer
Password for user is correct. Double checked. Tested a wrong password and resulted that I can't read from DB.
When user password is correct, can read from database. Can use SQL to read from DB. Just cannot update using SQL.
db_datareader& db_datawriter is checked for the user
Checked the SQL Server log - error 18456 severity 14 state 8. This is the password mismatch. But I am very sure the password is correct, because I can read from DB. It is ONLY when the SQL attempt to write to DB, it is denied.
dborequired to have
db_datawriterchecked as well? I am not able to checklist that in SQL server Management studio
Anything about the schema I need to do?
Anybody help. Thanks a lot/
It works perfectly and correctly in another site using SQL Server 2000. When I migrate to SQL Server 2008 R2, this is the problem.