账号通
    

账号  

密码  

1491

查看

1

回复
主题:[ICMS]这是不是SQL Server 没有 dbo 权限的问题? [收藏主题]  
in_flight 当前离线

290

主题

2

广播

0

粉丝
添加关注
级别:二年级

用户积分:1497 分
登录次数:128 次
注册时间:2008/6/28
最后登录:2018/9/3
in_flight 发表于:2015/6/18 15:51:29   | 只看该作者 查看该作者主题 楼主 
做在线知识付费 选科汛云开店
Server Error in '/' Application.
拒绝了对对象 'KS_ProGetProFromCart' (数据库 'db_kesion',架构 'dbo')的 EXECUTE 权限。 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 拒绝了对对象 'KS_ProGetProFromCart' (数据库 'db_kesion',架构 'dbo')的 EXECUTE 权限。

Source Error:

 An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

 [SqlException (0x80131904): 拒绝了对对象 'KS_ProGetProFromCart' (数据库 'db_kesion',架构 'dbo')的 EXECUTE 权限。]   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1787814   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5341674   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1693   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61   System.Data.SqlClient.SqlDataReader.get_MetaData() +90   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +377   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1421   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +137   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +316   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +88   Kesion.DataBase.DBHelper.ExecuteDataset(DbConnection connection, CommandType commandType, String commandText, DbParameter[] commandParameters) +128   Kesion.DataBase.DBHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, DbParameter[] commandParameters) +84   Kesion.DataBase.DBHelper.ExecuteDataset(CommandType commandType, String commandText, DbParameter[] commandParameters) +26   Kesion.SqlDAL.ShopManage.GetProductFromShoppingCart(String userName) +176   Kesion.BLL.ShopManage.GetProductFromShoppingCart(String userName) +51   Kesion.APPCode.ShoppingCartUser.CheckShoppingCart() +103   Kesion.APPCode.ShoppingCart.initial() +6294   Kesion.NET.WebSite.Index.Page_Load(Object sender, EventArgs e) +5087   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51   System.Web.UI.Control.OnLoad(EventArgs e) +92   System.Web.UI.Control.LoadRecursive() +54   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772

这是不是SQL Server 没有 dbo 权限的问题?

 
南京茶叶网 http://www.025tea.com 茶叶网址:http://www.sochaw.cn
  支持(0) | 反对(0) 回到顶部顶端 回到底部底部
站长启航 当前离线

82

主题

7

广播

5

粉丝
添加关注
级别:学前班

用户积分:3747 分
登录次数:149 次
注册时间:2014/5/12
最后登录:2016/9/11
站长启航 发表于:2015/6/18 17:51:28   | 只看该作者 查看该作者主题 沙发 
科汛在线商城系统(NET)
你再创建  数据库  账户时   要勾选  点击查看原图点击查看原图

点击查看原图

点击查看原图



试试!





 
  支持(0) | 反对(0) 回到顶部顶端 回到底部底部
<上一主题 | 下一主题 >
Powered By KesionCMS Version X1
厦门科汛软件有限公司 © 2006-2016 页面执行0.09375秒 powered by KesionCMS 9.0