Shopping Cart Software e-Commerce Forums > BV Commerce 5 > BV Commerce 5 Pre Sales Questions > Still trying

Forum Quick Jump

[ << Previous Thread | Show Newest Post First ]

JP
Registered Member

Date Joined Apr 2009
Total Posts : 4 Posted 4/16/2009 7:55 AM (GMT -4)

Having spoken to my hosters, they say the database I set up on my server is fine, and they say there are some tables missing in the bv database. So now when I browse I still get the grey page that says my database needs to be created but when I click start I get the following error below. I've been trying to get BV Commerce Trial for a week now and still cant even get started. its all alien to me. Any help before I finally call it a day and try something else would be greatly appreciated.

Server Error in '/' Application.

The SELECT permission was denied on the object 'foreign_keys', database 'mssqlsystemresource', schema 'sys'.

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: The SELECT permission was denied on the object 'foreign_keys', database 'mssqlsystemresource', schema 'sys'.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

  <%@ Page Language="C#" Debug="true" %>

or:

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

<configuration>
   <system.web>
       <compilation debug="true"/>
   </system.web>
</configuration>

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.

Stack Trace:

[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& c) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:545
   BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ParseSQLLines(String lines, SqlConnection& 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& 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

Marcus
Forum Moderator

Date Joined Nov 2003
Total Posts : 5609

Posted 4/16/2009 8:43 AM (GMT -4)

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"

Marcus

Shopping Cart Software

TMaiden
Registered Member

Date Joined Jun 2010
Total Posts : 38

Posted 7/9/2010 4:46 PM (GMT -4)

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 Information

Currently it is Wednesday, September 08, 2010 11:42 PM (GMT -4)
There are a total of 57,382 posts in 12,471 threads.
In the last 3 days there were 2 new threads and 19 reply posts. View Active Threads

Shopping Cart Software and complete e-Commerce solutions

Server Error in '/' Application.

The SELECT permission was denied on the object 'foreign_keys', database 'mssqlsystemresource', schema 'sys'.