I am moving my DNN community 6.1.3 website from one host to another.
Have set up and tested the webmatrix publish parameters for the new site.
Files are all uploaded to new hosting service, but problem with getting database uploaded.
It seems to involve the database administrator name for the old site - not sure where that comes from - is there somewhere in the DNN configuaration or database that might hold the database admin account details?
Microsoft Forum suggests updating connection string in web.config, but that doesn't have the old hosting details in it so I think is not relevant.
Publication log follows (only database being published 'cos everything else ok) - the create schema is referencing the old host id:
16/02/2012 07:54
07:57:16: Using ID 'fd8b43ab-f277-4d45-bdcc-c2f164fcb94e' for connections to the remote server.
08:02:15: Updating setAcl (localhistory.me.uk).
08:02:15: Updating setAcl (localhistory.me.uk/App_Data).
08:02:15: Updating setAcl (localhistory.me.uk/App_Data).
08:02:15: Using ID 'e9b04545-3aca-4926-8bda-8f31680f1519' for connections to the remote server.
08:05:37: Updating setAcl (localhistory.me.uk).
08:05:37: Updating setAcl (localhistory.me.uk/App_Data).
08:05:37: Updating setAcl (localhistory.me.uk/App_Data).
08:05:37: Adding child sqlScript (MSDeploy.Continous/dbFullSql[@path='data source=ASPHOST75\SQL2008,777;initial catalog=Shanedhorloc_WLHG;user id=Shanedhorloc_host']/sqlScript).
08:05:37: Opening SQL Connection with connection string 'data source=ASPHOST75\SQL2008,777;initial catalog=Shanedhorloc_WLHG;user id=Shanedhorloc_host;pooling=False'. The 'transacted' setting for this connection is 'True'.
08:08:33: Unable to publish the database. For more information, see "http://go.microsoft.com/fwlink/?LinkI..."
08:08:33: Unable to publish. Unable to publish the database. For more information, see "http://go.microsoft.com/fwlink/?LinkI..."
08:08:33: Error detail:
08:08:33: An error occurred during execution of the database script. The error occurred between the following lines of the script: "3856" and "3858". The verbose log might have more information about the error. The command started with the following:
08:08:33: "CREATE SCHEMA [prvcsdvy_host] AUTHORIZATION [prvcs"
08:08:33: Cannot find the user 'prvcsdvy_host', because it does not exist or you do not have permission.
08:08:33: CREATE SCHEMA failed due to previous errors. http://go.microsoft.com/fwlink/?LinkI... Learn more at: http://go.microsoft.com/fwlink/?LinkI....
08:08:33: at Microsoft.Web.Deployment.StatusThreadHandler.CheckForException()
08:08:33: at Microsoft.Web.Deployment.AgentClientProvider.RemoteDestSync(DeploymentObject sourceObject, DeploymentSyncContext syncContext)
08:08:33: at Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable)
08:08:33: at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
08:08:33: at Microsoft.Web.Deployment.DeploymentObject.SyncTo(String provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
08:08:33: at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentWellKnownProvider provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
08:08:33: at Microsoft.WebMatrix.Deployment.MsDeployWorker.Execute(CommandManager commandManager, CertificateValidationService certificateValidationService, Boolean skipHiddenFiles)
08:08:33: Cannot find the user 'prvcsdvy_host', because it does not exist or you do not have permission.
08:08:33: CREATE SCHEMA failed due to previous errors.
08:08:33: at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
08:08:33: at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
08:08:33: at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
08:08:33: at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
08:08:33: at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
08:08:33: at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
08:08:33: at Microsoft.Web.Deployment.DBStatementInfo.Execute(DbConnection connection, DbTransaction transaction, DeploymentBaseContext baseContext, Int32 timeout)