Database server to server migration

[Dan Manson]

Has anyone migrated a SQL DB from one server to another without reinstalling Confluence?  I've seen the Migrating to Another Database with "Step 4. Install Confluence (same version number) in a new location" a step that requires another server since the setup doesn't support two installations on the same machine.

I backed up and restored our SQL DB on another server, updated the clear text connection information in "C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml"  Confluence returns error 500 

[Dan Manson · Accepted solution]

It was connection data in the server.xml I needed to update the jwt.private.key, and jwt.public.key values.

see https://jira.atlassian.com/browse/CONFSERVER-45657?src=confmacro 

[Nic Brough -Adaptavist-]

Error 500 just means it's not serving, which could be caused by a lot of things.

You'll need to read the application logs to find out what has gone wrong.  It's almost always recorded in <confluence home where the confluence.cfg.xml file is>/log/atlassian-confluence.log