• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

[email protected]
#1 Posted : Thursday, April 16, 2009 5:55:27 AM(UTC)
aeromad@hotmail.com

Rank: Member

Joined: 4/9/2009(UTC)
Posts: 4

<H1>
</H1>
<H2>The SELECT permission was denied on the object 'foreign_keys', database 'mssqlsystemresource', schema 'sys'. </H2><FONT face=Verdana>Descript<b>ion:
</B>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.

[color=#ffffcc>

[tr ][td ]<CODE>The]1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

&lt;%@ Page Language="C#" Debug="true" %&gt;

or:

2) Add the following section to the configuration file of your application:

&lt;configuration&gt;
&lt;system.web&gt;
&lt;compilation debug="true"/&gt;
&lt;/system.web&gt;
&lt;/configuration&gt;

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.[/code] [/td][/tr]</TABLE>
<B><FONT face=Verdana>Stack Trace:[/color]



[table width="100%" bgColor=#ffffcc]
[tr ][td ]<CODE>
[SqlException (0x80131904): The SELECT permission was denied on the object 'foreign_keys', database 'mssqlsystemresource', schema 'sys'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1948826
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844747
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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +317
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.RunSingleStatement(String statement, SqlConnection&amp; c) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:545
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ParseSQLLines(String lines, SqlConnection&amp; c) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:533
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile, String&amp; ErrorMessage) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:510
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:524
BVSoftware.Bvc5.Core.Utilities.SqlPatchHelper.PatchVersion(Versions version) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\SqlPatchHelper.vb:21
BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:29
SqlPatch.StartButton_Click(Object sender, EventArgs e) +20
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
</PRE>[/code][/td][/tr][/table]
Marcus
#2 Posted : Thursday, April 16, 2009 6:43:43 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

Your SQL Server user account does not have enough permissions to correctly install the software. Have your web host run the install script manually or ask for permissions to "select foreign keys from the 'sys' schema"
TMaiden
#3 Posted : Friday, July 9, 2010 2:46:14 PM(UTC)
TMaiden

Rank: Member

Joined: 6/28/2010(UTC)
Posts: 38

Who is the web host? Some host may not grant certain permissions, for security reasons.

Also, if the database is shared with other customers, maybe changing permissions is not allowed.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012