Installation Failed - Could not create database with user login

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/14/2009 9:51:57 PM
Gravatar
Total Posts 4

Installation Failed - Could not create database with user login

I am new to Mojo portal but having seen the other opensource products for cms I really like mojo and want to use for my website.  However I am having a number of issues with the installation.  It seems to fall over at the database creation/login stage. I am running Vista home and SQL Express 2008.  I tried it with SQL Express 2005 and I had a similar issue which I found the solution to be to install SP2 which allows you to add the computer admin user to the database users.  However I was getting another error which is the install failed because the microsoft.sqlserver.connectioninfo file cousl not be assembled as I think the file may have been missing.  The MSN site did recommend finding this file and adding it to the bin.  However I could not find the file so I decide to try SQL Express 2008.  Now I am back where I started as the problem I am having now seems to be the original problem of admin computer user is not a database user and does not have permission.  The current error states Install failed: database could not be created for the database user.  Can you assist me with this problem.

CK

 

6/15/2009 10:04:57 AM
Gravatar
Total Posts 18439

Re: Installation Failed - Could not create database with user login

I assume you are using the Platform Installer since that is the only package that can automatically create a db for you. If not then you must create the db yourself and set the conneciton string.

Probably your SQLExpress is only configured for Windows Authentication, the Platform imnstaller package expects a SQL user not a windows user, so I recommend reconfigure your SQLEXpress installation for "Mixed Mode" which enables both windows authentication and sql authentication. Though if you really are not admin on the machine it may not be possible to make this copnfiguration change. 

Hope it helps,

Joe

6/15/2009 6:54:11 PM
Gravatar
Total Posts 4

Re: Installation Failed - Could not create database with user login

Thank you Joe, I changed the authentication to SQl authentication as there was no option for mixed mode and entered a password for the sa account and the installation worked like a breeze.  For information on how to change authentication mode use this msdn link http://msdn.microsoft.com/en-us/library/ms188670.aspx

CK

6/15/2009 7:46:54 PM
Gravatar
Total Posts 4

Re: Installation Failed - Could not create database with user login

Hi Joe,

I have a new issue when trying to go into my application after the installation.  Using Internet explorer I try to browse to my mojo application and receive the following configuration error message;

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
Line 638:
Line 639: -->
Line 640: <machineKey validationKey="55BA53B475CCAE0992D6BF9FE463A5E97F00C6C16DA3D7DF9202E560078AB501643C15514785FEE30FEF26FC27F5CE594B42FFCA55452EF90E8A056B4DAE9F39" decryptionKey="939232D527AC4CD3E449441FE887DA110A16C1A36924C424CBAAE3F00282436C" validation="SHA1" decryption="AES" />
Line 641: <!--
Line 642: The above key is better so I changed it, but leaving this one here

I know it has to do with the web.config file but I don't know how to resolve it.  The user.config file is already in the application folder so I didn't think I needed to do anything else for the connection.  Obviously I am not doing something.  Can you tell me what it is?

CK

 

6/16/2009 5:11:04 AM
Gravatar
Total Posts 18439

Re: Installation Failed - Could not create database with user login

It sounds like you have mojoportal installed beneath another .NET app in the root of the web site and the Web.config in that app interferes with mojoportal.

You could try commenting out the <machinekey element in the mojoportal Web.config. The machine key is used in encrypting user passwords so changing/commenting it out can potentially lock you out if passwords are encrypted. 

Its also possible that after commenting it out the error will move to a different section it will complain about.

Hope it helps,

Joe

6/16/2009 10:01:07 PM
Gravatar
Total Posts 4

Re: Installation Failed - Could not create database with user login

Thankd Joe,

I was not able to get rid of the error and during the process of troubleshooting I caused a few other errors and in the end I reinstalled SQL Express 2008 and mojoportal.  Now when I go to the url to access the application I get the following error;

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0101: The namespace 'Resources' already contains a definition for 'FeedResources'

Source Error:

 

[No relevant source lines]
 

Source File: c:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\sustainability\68702ce4\2e610c2f\App_GlobalResources.ne-twjbn.29.cs Line: 25

Please assist.

CK

6/17/2009 5:59:58 AM
Gravatar
Total Posts 18439

Re: Installation Failed - Could not create database with user login

There is some information about the resource error on our FAQ page.

Hope it helps,

Joe 

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