mojoSetup has detected that the database user does not have permission to alter the database schema?

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.
6/3/2010 2:40:08 PM
TieriaETA
Gravatar
Total Posts 10
View Posts

mojoSetup has detected that the database user does not have permission to alter the database schema?

THe current error I am getting from mojoPortal is:

 

mojoSetup has detected that the database user does not have permission to alter the database schema. You need to correct this or provide a connection string with sufficient permission.

database initial schema needs to be created.

I've changed the user several times to match other users that are running on Mojo. Any clues?

6/4/2010 6:41:11 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: mojoSetup has detected that the database user does not have permission to alter the database schema?

You need to make the user dbo (database owner) of the database so it has permissions to create tables and stored procedures. It runs a test trying to make a table and if it cannot it gives this message.

Hope it helps,

Joe

10/25/2010 12:37:00 PM
Hans-Christian
Gravatar
Total Posts 5
View Posts

Re: mojoSetup has detected that the database user does not have permission to alter the database schema?

I have the same issue, when i upgraded from to .4 to .8 and above i get the same error, has something happened from version .5 to .8 which has something to do with the mssql DB?

10/26/2010 4:18:22 AM
Hans-Christian
Gravatar
Total Posts 5
View Posts

Re: mojoSetup has detected that the database user does not have permission to alter the database schema?

The place where i host my sites: www.surftown.dk has installed my databases on a MSSql 2000 that why it didn't work. from .8 version forward mojoportal does not support MSSql 2000.

10/26/2010 5:49:47 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: mojoSetup has detected that the database user does not have permission to alter the database schema?

That is correct, we dropped support for SQL 2000 in version 2.3.4.8 as indicated in the release announcement for that version back in July 2010 http://www.mojoportal.com/mojoportal-2348-released.aspx

I also initially asked for input about it back in March 2010 in the blog where I asked "Anyone Still Using SQL 2000", and the feedback indicated only a very few people were using it and even those few were supportive of us moving forward and dropping support for SQL 2000 since it would make it easier to manage development going forward to have a single data layer for SQL 2005/2008/SqlAzure. Prior to that we had introduced a separate data layer for SqlAzure because it was impossible to have a data layer that was compatible with both SQL 2000 and SQLAzure because SQL 2000 does not support nvarchar(max) and SqlAzure does not support ntext data types. By dropping support for SQL 2000 we were able to change all ntext fields to nvarchar(max).

Sorry for the inconvenience but time and progress move forward. I would ask your host about migrating to SQL 2005/2008.

Best,

Joe

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