Can Read But Cannot Update

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 Err

Solution 1:

Looks like your login to the SQL Server have only the read permissions on the database (/table / server) and it dont have the write permissions, the dbwriter and dbreader are the roles in SQL Server 2000, in 2008 it all changed you have add roles to your login.

Please try to give the login all the permissions, as below

GRANT ALL ON <your_table> to <your_login>

Solution 2:

please try this db from sql server management studio to update any table by query in query analyzer if it does not work then check table permission or login user permission