可以读取但不能更新 [英] Can read but cannot update

问题描述

问题：更新数据库的任何尝试在SQL Server 2008 R2中使用SQL在传统的ASP页面否认

Problem: Any attempt to update the DB is denied in SQL Server 2008 R2 using SQL in classic ASP page.

在简单地说，可以读，但不能更新/ SQL使用ASP中的页写入数据库

In a nutshell, can read, but can't update/write to DB using SQL in ASP page

错误消息：

Microsoft OLE DB提供了SQL Server错误'80040E4D

Microsoft OLE DB Provider for SQL Server error '80040e4d'

用户登录失败

我花了6个多小时排除故障，但始终无人接听。

It has taken me more than 6 hours to troubleshoot, but still no answer

事情经过

1. 密码的用户是正确的。双重检查。测试了错误的密码，导致我无法从数据库读取。

1. Password for user is correct. Double checked. Tested a wrong password and resulted that I can't read from DB.

当用户密码正确后，可以从数据库中读取。可以使用SQL从数据库读取。只是不能更新使用SQL。

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权限检查，为用户

db_datareader & db_datawriter is checked for the user

经过SQL Server日志 - 错误的严重性18456状态14 8.这是密码不匹配。但我很肯定的密码是正确的，因为我可以从数据库读取。只有当在SQL尝试写入到数据库时被拒绝。

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.

提示

• 是 DBO 有需要的的db_datareader ＆安培; db_datawriter权限检查呢？我无法核对表，在SQL Server Management Studio中

• Is the dbo required to have db_datareader & db_datawriter checked 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/

它使用SQL Server 2000的完美的作品，并在正确的另一个网站当我迁移到SQL Server 2008 R2，这就是问题所在。

It works perfectly and correctly in another site using SQL Server 2000. When I migrate to SQL Server 2008 R2, this is the problem.

AA贾兹

推荐答案

请尝试从SQL Server Management Studio中，这个数据库被查询，在查询分析器更新任何表，如果它不工作，然后检查表权限或登录用户权限

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

这篇关于可以读取但不能更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！