I don't want to use the current Compass database and want to connect it to another database.
How to do it?
In order to connect Compass to another SQL database, please follow below steps
Find the Compass installer and run the Compass_Setup.exe.
In the Setup Wizard, select Modify
It brows the available SQL server on the network automatically.
Set the SQL Server hostname and the Instance name correctly.
There are two ways here. One is to select the instance from the list and click set. Another is to input the names manually.
Click Next, Compass will be redirected to the SQL database as you selected.