How to deal with error message 'error opening database' in Compass?
When you see below error message in Compass
A possible cause is that Compass database is not set up correctly. You can resolve it with below steps:
Please run Compass_SQLServerSetup.exe as administrator. (you can find it under Compass_SQLServerSetup folder - SQLServerSetup)
Run Microsoft SQL Server Management Studio, login to your Compass instance, you should see 4 databases as the picture below.
Run Compass, the error message should not appear again.