Change the default database to SQL Server

[Zhang Guochen]

I want to change the default hsql database to Microsoft SQL Server.

After I changed the value of "confluence.home" key in the file "C:\Program Files\Atlassian\Confluence\confluence\WEB-INF\classes\confluence-init.properties" to SQL server database location, and restart the service of confluence. I try to access the server address of confluence it will show the following error page. I can't re-select the external database.

ErrorImg.png

[Nic Brough -Adaptavist-]

You need to read the log file further up to see what has gone wrong.  

However, just changing one file to change the database in use is not enough.  For a start, you've hit completely the wrong file, and you've not mentioned the installation of the drivers either.

Please check https://confluence.atlassian.com/display/DOC/Migrating+to+Another+Database to see what you should be doing.