Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

David_Ray_Isley November 19, 2018

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.

1 answer

0 votes
Stephen Sifers
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 20, 2018

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events