错误[42000] [Microsoft] [ODBC SQL Server驱动程序] [SQL Server] EXECUTE权限被拒绝 [英] ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied

问题描述

我使用IIs服务器部署我的项目

当我点击登录按钮时首页加载它出错了



错误[42000] [Microsoft] [ODBC SQL Server驱动程序] [SQL Server]对象存储过程名称，数据库数据库名称，架构dbo上的EXECUTE权限被拒绝。



Plz帮助我

I am Deploy My project using IIs Server
First page loaded currectly when i click on login button it gives an error

ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'Stored Procedure Name', database 'Database Name', schema 'dbo'.

Plz Help Me

推荐答案

应用程序连接字符串中使用的凭据无权执行任何过程。请检查用于申请的帐户的权利。

Credentials used in connection string of application doesn't have rights to execute any procedure. Please check rights on your account used for application.

这篇关于错误[42000] [Microsoft] [ODBC SQL Server驱动程序] [SQL Server] EXECUTE权限被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！