Question
How to deal with error message 'error opening database' in Compass?
Answer
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:
Step 1
Please run Compass_SQLServerSetup.exe as administrator. (you can find it under Compass_SQLServerSetup folder - SQLServerSetup)
Step 2
Run Microsoft SQL Server Management Studio, login to your Compass instance, you should see 4 databases as the picture below.
Step 3
Run Compass, the error message should not appear again.