我的网站打不开了 “/”应用程序中的服务器错误。
--------------------------------------------------------------------------------拒绝了对对象 'sp_SiteSettings_Get'(数据库 's433083db0',所有者 'dbo')的 EXECUTE 权限。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 拒绝了对对象 'sp_SiteSettings_Get'(数据库 's433083db0',所有者 'dbo')的 EXECUTE 权限。源错误: 执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。 堆栈跟踪:
[SqlException (0x80131904): 拒绝了对对象 'sp_SiteSettings_Get'(数据库 's433083db0',所有者 'dbo')的 EXECUTE 权限。]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior) +181
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command) +130
Hishop.SystemServices.Data.SqlCoreDataProvider.LoadSiteSettings() +74
Hishop.SystemServices.SiteSettingsManager.GetSiteSettings(Boolean flush) +62
Hishop.SystemServices.HiContext.get_SiteSettings() +25
Hishop.SystemServices.SiteUrls.Instance() +175
Hishop.SystemServices.Globals.GetSiteUrls() +5
Hishop.SystemServices.HiUrlReWriter..cctor() +21[TypeInitializationException: “Hishop.SystemServices.HiUrlReWriter”的类型初始值设定项引发异常。][TargetInvocationException: 调用的目标发生了异常。]
System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) +0
System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) +86
System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) +230
System.Activator.CreateInstance(Type type, Boolean nonPublic) +67
System.Activator.CreateInstance(Type type) +6
Hishop.SystemServices.UrlReWriteProvider..cctor() +16[TypeInitializationException: “Hishop.SystemServices.UrlReWriteProvider”的类型初始值设定项引发异常。]
Hishop.SystemServices.UrlReWriteProvider.Instance() +0
Hishop.SystemServices.HiHttpModule.ReWriteUrl(HttpContext context) +34
Hishop.SystemServices.HiContext.Create(HttpContext context, UrlReWriterDelegate rewriter) +55
Hishop.SystemServices.HiHttpModule.Application_BeginRequest(Object source, EventArgs e) +507
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:2.0.50727.3603; ASP.NET 版本:2.0.50727.3082
--------------------------------------------------------------------------------拒绝了对对象 'sp_SiteSettings_Get'(数据库 's433083db0',所有者 'dbo')的 EXECUTE 权限。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 拒绝了对对象 'sp_SiteSettings_Get'(数据库 's433083db0',所有者 'dbo')的 EXECUTE 权限。源错误: 执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。 堆栈跟踪:
[SqlException (0x80131904): 拒绝了对对象 'sp_SiteSettings_Get'(数据库 's433083db0',所有者 'dbo')的 EXECUTE 权限。]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior) +181
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command) +130
Hishop.SystemServices.Data.SqlCoreDataProvider.LoadSiteSettings() +74
Hishop.SystemServices.SiteSettingsManager.GetSiteSettings(Boolean flush) +62
Hishop.SystemServices.HiContext.get_SiteSettings() +25
Hishop.SystemServices.SiteUrls.Instance() +175
Hishop.SystemServices.Globals.GetSiteUrls() +5
Hishop.SystemServices.HiUrlReWriter..cctor() +21[TypeInitializationException: “Hishop.SystemServices.HiUrlReWriter”的类型初始值设定项引发异常。][TargetInvocationException: 调用的目标发生了异常。]
System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) +0
System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) +86
System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) +230
System.Activator.CreateInstance(Type type, Boolean nonPublic) +67
System.Activator.CreateInstance(Type type) +6
Hishop.SystemServices.UrlReWriteProvider..cctor() +16[TypeInitializationException: “Hishop.SystemServices.UrlReWriteProvider”的类型初始值设定项引发异常。]
Hishop.SystemServices.UrlReWriteProvider.Instance() +0
Hishop.SystemServices.HiHttpModule.ReWriteUrl(HttpContext context) +34
Hishop.SystemServices.HiContext.Create(HttpContext context, UrlReWriterDelegate rewriter) +55
Hishop.SystemServices.HiHttpModule.Application_BeginRequest(Object source, EventArgs e) +507
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:2.0.50727.3603; ASP.NET 版本:2.0.50727.3082
登陆到SQL SERVER 管理控制台,检查你当前连接数据库的用户名是否是dbowner 权限。
为什么不用sa啊
也可以
integrated security =SSPI