Permission to alter 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.

8/25/2011 5:44:59 PM

mtownshe

Total Posts 3

View Posts

Permission to alter database schema

Hi All, I'm real beginner at this and desperately need some help.

When upgrading my mojo, I deleted all files in the web root and uploaded new files from version 2.3.6.7. net 35 MSSQL.

/setup/default.aspx gives the following response against the MSSQL database.

Probing system...
File system permissions ok.
MSSQL database connection ok.
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 already exists.
database core schema needs upgrade.
1 site(s) found.

I have no idea what the problem is with schema permissions and my web host is of little help.
Can these permissions be set in the connection string, or does the web host have to set them?

Any assistance on what to do next would be appreciated. I would be happy to provide my web host login details via email if someone could take a look!

I have searched these forums but cant find my problem discussed.
Files were uploaded from windows 7 pro using FileZilla. Im positive the upload was good and got all files without errors.
Web host confirmed they are running 3.5

Help Please.

Mark

8/25/2011 6:16:58 PM

SpikeMelbost

Total Posts 55

View Posts

Arvixe Web Hosting / mojoPortal Community Liaison Looking for quality mojoPortal hosting? Try Arvixe Check out the MojoPortal Blogs at Arvixe

Re: Permission to alter database schema

Hi Mark,

I've not seen this error myself, but it sounds to me like a problem with the database user id not having the necessary permissions.

The root directory of your published site has web.config and user.config files. Amongst other things, you will find a connection string for MSSQL in there. Check to find the database (MSSQL) user name.

Make sure the connection string is correct & you haven't overwritten it with the wrong info.

If you're still having problems, you can try this. I have MS SQL Server Management Studio installed (its a free download). If I connect to that, in databases find my database and under security, users I can find & double click on my user name & look under role members. I have db_owner ticked.

If you only have 3.5 available you might want to consider changing to someone who can give you 4. The right service provider can make life a lot easier.

Spike

8/25/2011 6:50:03 PM

mtownshe

Total Posts 3

View Posts

Re: Permission to alter database schema

Thanks for the prompt reply Spike.

I think the connection string is good...Its the same as the previous user.config connection string.

I will try your advice using Sql Server Management Studio to tweak the db username.

Will post back

Thanks

8/26/2011 10:04:46 PM

mtownshe

Total Posts 3

View Posts

Re: Permission to alter database schema

After looking at the users in MS SQL Management studio I noticed there was an additional user name that my web host was not showing me in my control panel! It was an old user name that I deleted from my control panel years ago.

I changed my connection sting to use this old user name, restarted the mojo and the setup completed without a problem.

Thanks for the direction Spike!

Mark

8/29/2011 5:23:39 AM

SpikeMelbost

Total Posts 55

View Posts

Arvixe Web Hosting / mojoPortal Community Liaison Looking for quality mojoPortal hosting? Try Arvixe Check out the MojoPortal Blogs at Arvixe

Re: Permission to alter database schema

No problem, glad you got it sorted.

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