Setup issues with database create and 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.
11/22/2012 6:39:05 AM
João Falcão
Gravatar
Total Posts 40
View Posts

Setup issues with database create and login

Hello,

Every time i delete my database, and then run the setup, i get the following:

Probing system...
File system permissions ok.
MSSQL Trying To Create Database
The system cannot connect to the MSSQL database. Please check your connection string.

System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Portal" requested by the login. The login failed. Login failed for user 'sa'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource'1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource'1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource'1 retry) at System.Data.SqlClient.SqlConnection.Open() at mojoPortal.Data.DBPortal.DatabaseHelperGetConnectionError(String overrideConnectionInfo) in C:\Users\joao.falcao\Documents\Visual Studio 2010\Projects\Projectos_V12\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 402 ClientConnectionId:6c26ee72-96b0-49a1-8843-0bde51c081c5

(But the database is created successfully!!)

I then refresh the page and get:

Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
Running script mojoportal-core - 2.3.4.8 - 00:00:00.4390439
......

Any ideas why I always have to refresh for the setup to proceed?

Best regards,

João

11/23/2012 8:42:34 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Setup issues with database create and login

Why would you delete your database? There is no need to do that for upgrading.

"MSSQL Trying To Create Database"

I have no idea what that means or how the setup page could say that since mojoPortal does NOT create the MS SQL Database, the database must already exist in order for the setup page to work.

The only platform where the database is created automatically if it doesn't already exist is when using SQL CE, there is no code anywhere in mojoPortal that can create a database for any other platform.

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