SQL 存储过程的问题
中看到以下条目
我可以在 ULS 日志02/08/2010 14:36:46.12 w3wp.exe (0x15F4) 0x18A0 CMS Publishing 8x0a High AppDomainUnloadListener.RegisterSelf() 输入锁定(this=15368010)
02/08/2010 14 : 37:25.59 w3wp.exe (0x15F4) 0x1744 Windows SharePoint Services 数据库 880i 高 System.Data.SqlClient.SqlException: 找不到存储过程“dbo.proc_GetDatabaseInformation”。
02/08/2010 14:37:32.53 w3wp.exe (0x15F4) 0x1744 Windows SharePoint Services 数据库 98rs 高 尝试向用户“X”授予对 SQL Server 上“Y”数据库的访问权限时发生错误。如果调用者无权在 sql server 中执行此操作或者数据库是只读的,则可能会出现这种情况。为了确保 SharePoint 正常运行,请在执行此操作之前手动授予该用户对数据库的访问权限。该用户还必须被授予对数据库中 db_owner 组的访问权限。此错误提供了以下信息: 用户无权执行此操作。
02/08/2010 14:37:32.53 w3wp.exe (0x15F4) 0x1744 Windows SharePoint Services 数据库 880i 高 System.Data.SqlClient.SqlException: 用户无权执行此操作。
有什么线索吗?
I could see the below entries in the ULS log
02/08/2010 14:36:46.12 w3wp.exe (0x15F4) 0x18A0 CMS Publishing 8x0a High AppDomainUnloadListener.RegisterSelf() entered lock(this=15368010)
02/08/2010 14:37:25.59 w3wp.exe (0x15F4) 0x1744 Windows SharePoint Services Database 880i High System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.proc_GetDatabaseInformation'.
02/08/2010 14:37:32.53 w3wp.exe (0x15F4) 0x1744 Windows SharePoint Services Database 98rs High An error occured while trying to grant the user "X" access to the "Y" database on the SQL server. This may be expected if the caller does not have permission to perform this operation in sql server or if the database is read-only. To ensure that SharePoint functions correctly, manually grant this user access to the database before performing this operation. The user must also be granted access to the db_owner group in the database. The following information was provided with this error: User does not have permission to perform this action.
02/08/2010 14:37:32.53 w3wp.exe (0x15F4) 0x1744 Windows SharePoint Services Database 880i High System.Data.SqlClient.SqlException: User does not have permission to perform this action.
Any clues?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
无论数据库用户调用此存储过程,都需要具有该存储过程的特定执行权限或一般执行权限。您的客户端程序可能对应于一个或多个数据库用户。
Whatever database user is calling this stored procedure will either need to have execute permissions for the stored procedure specifically or execute permissions in general. Your client program probably corresponds to one or more database users.
您遇到权限被拒绝的问题。如果您在数据库上设置了权限并且刚刚添加了过程“dbo.proc_GetDatabaseInformation”,您可能需要授予用户访问它的权限。具体来说,您的网站使用的任何用户。否则这些用户将无法调用该过程,并且您将看到上述错误。
You have a permission denied issue. If you have permissions set on your database and you just added the proc 'dbo.proc_GetDatabaseInformation' you may need to give your users access to it. Specifically, any users that your website uses. Otherwise those users will not be able to call that proc and you will see the above error.
与 dbo.proc_GetDatabaseInformation 相关的错误是 Sharepoint 2007 基础结构更新的一个已知问题 - 微软表示您应该忽略该错误消息: http://support.microsoft.com/kb/951695
The error relating to dbo.proc_GetDatabaseInformation is a known issue with the Sharepoint 2007 infrastructure update - microsoft say you should ignore that error message: http://support.microsoft.com/kb/951695