install problem v2.2.3.8 mssql

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
9/12/2007 4:22:48 PM
glenravenmzb
Gravatar
Total Posts 1
View Posts

install problem v2.2.3.8 mssql

hi, i've a problem on installation. can you help me? Probing system... File system permissions ok. MSSQL database connection ok. database permissions are sufficient to alter schema. database initial schema already exists. database core schema needs upgrade. 0 site(s) found. Running script mojoportal-core - 2.2.1.5 - 00:00:00.0937596 An Error Occurred:EXECUTE permission denied on object 'mp_SchemaVersion_SelectOne', database 'glenrav_portal', owner 'dbo'. Source:.Net SqlClient Data Provider Stack Trace at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at mojoPortal.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at mojoPortal.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at mojoPortal.Data.dbPortal.SchemaVersion_GetSchemaVersion(Guid applicationID) at mojoPortal.Data.dbPortal.SchemaVersion_Exists(Guid applicationID) at mojoPortal.Business.DatabaseHelper.UpdateSchemaVersion(Guid applicationID, String applicationName, Int32 major, Int32 minor, Int32 build, Int32 revision) at mojoPortal.Web.UI.Pages.SetupHome.RunScripts(Guid applicationID, String applicationName, String pathToScriptFolder, Version versionToStopAt) at mojoPortal.Web.UI.Pages.SetupHome.UpgradeSchema(String applicationName) at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
9/12/2007 4:40:00 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: install problem v2.2.3.8 mssql

Hi,

Is this a new installation or an upgrade?

The error is saying that the user in your connection string does not have execute permission on the stored procedure. Given that the same user (unless you changed the user in the connection string after it ran once) would be the one that created the procedure, it should have permission by default unless you have a strange permission configuration.

Is the user in your connection string dbo of the database (database owner)?

You might try granting the user execute permission on all the existing stored procedures.

Joe

You must sign in to post in the forums. This thread is closed to new posts.