Confluence Server containing the SQL database have been moved to a new domain.

David_Ray_Isley

Confluence Server has been moved to a new domain.  Server is using Windows Authentication for SQL DB.  The Windows account has been migrated.  But when I change the DBO from the old account to the new account it breaks confluence.

Where are all the seeing I need to check for update the SQL DBO.

Stephen Sifers

Hello David,

Things to keep in mind when migrating your SQL database to a new server/domain are to ensure that SQL has access to the Database (MDF files) and Logs (LDF files). As well as ensuring your new database user exists within the SQL instance and has permissions on the Confluence database (in some cases you may have to remove the old user from the SQL database security settings and then re-add the user). The documentation for Database setup for SQL server states the database user needs the following:

Give this user full create, read and write permissions for the database tables. Confluence must be able to create its own schema. Refer to the SQL Server documentation for how to do this.

You will also need to ensure that your database connection is configured for the new users as well, you can find more on this here at Use a JDBC connection (default).

Additionally, more information can be found at Configuring a datasource connection.

If you are still having issues after adjusting the above, please let us know what the logs are outputting, we will need the output of atlassian-confluence.log. Here is how to locate the logs, if needed, Working with Confluence Logs.

Please let us know if this works or if you need further assistance.

Regards,
Stephen Sifers