Another Server Error Creating the Database

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.

7/25/2009 9:02:18 PM

HenryStock

Total Posts 2

View Posts

Another Server Error Creating the Database

I also had a Server Error when trying to create the database. I was wondering if I could get the script for the database creation and run it through Management Studio.

Here is the error, or part of the error from the log file:

[21:36:70]Updating setAcl (Default Web Site/mojoportal)
Details:
operationType: Update
providerName: setAcl
path: Default Web Site/mojoportal
[21:36:176]Destination dbFullSql (data source=.\SQLExpress;initial catalog=mojoportal;user id=mojouser) does not match source (msdeploy.config) differing in attributes (path['msdeploy.config','data source=.\SQLExpress;initial catalog=mojoportal;user id=mojouser'],databaseName). Update pending
[21:36:176]Adding dbFullSql (data source=.\SQLExpress;initial catalog=mojoportal;user id=mojouser)
Details:
operationType: Add
providerName: dbFullSql
path: data source=.\SQLExpress;initial catalog=mojoportal;user id=mojouser
[21:36:709]The database 'mojoportal' could not be created.. Retrying operation 'Add' on object dbFullSql (data source=.\SQLExpress;initial catalog=mojoportal;user id=mojouser). Attempt 1 of 5.
Details:
originalMessage: The database 'mojoportal' could not be created.
operationType: Add
retryAttempt: 1
retryCount: 5

I can't tell from the message whether the problem is related to security or something else. I know I can login to the Database server via Management Studio, so if I can get the DB creation script I could run it and create the database that way.

7/25/2009 9:04:48 PM

HenryStock

Total Posts 2

View Posts

Re: Another Server Error Creating the Database

Additional Info from the log file:

EXCEPTION: Microsoft.Web.Deployment.DeploymentException: The database 'mojoportal' could not be created. ---> System.Data.SqlClient.SqlException: Login failed for user 'mojouser'. The user is not associated with a trusted SQL Server connection.
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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.Web.Deployment.SqlDatabaseProvider.AddHelper(DeploymentObject source)
--- End of inner exception stack trace ---
at Microsoft.Web.Deployment.DeploymentObject.Add(DeploymentObject source, DeploymentSyncContext syncContext)
at Microsoft.Web.Deployment.DeploymentSyncContext.HandleUpdate(DeploymentObject destObject, DeploymentObject sourceObject)
at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject dest, DeploymentObject source)
at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject dest, DeploymentObject source)
at Microsoft.Web.Deployment.DeploymentSyncContext.ProcessSync(DeploymentObject destinationObject, DeploymentObject sourceObject)
at Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(String provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentWellKnownProvider provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.PlatformInstaller.MsDeployProxy.Install(InstallerItemInstallContext context, RemoteCredentials remoteCredentials)

7/26/2009 5:50:51 AM

Joe Audette

Total Posts 18439

View Posts

Re: Another Server Error Creating the Database

Hi,

The most likely cause of this is if your SQLExpress is only configured for Windows Authentication. You can change it to Mixed Mode which allows both windows and SQL users. Then if the sa user exists you can set a new password on it and then the web app installer should be able to work. If you have troubole configuring the sa user, just create a new SQL user named admin and add it to all the server roles under the Security node in SQL Management Studio. Then you can use this new SQL admin user instead of sa.

If you want to work in Visual Studio, I recommend you use the source code download which has a VS solution. You can also run the deployment package (which is pre-compiled and has no C# code) in VS, but the advantage of working with the source code is there are code examples for almost ay common task you want to do by looking at code for existing features.

Hope it helps,

Joe

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