Issue
When attempting to restore a ContinuumDB database while using SQL Express Management Studio, you receive the following error:
The database ContinuumDB is not accessible.
If you click Ok, you are able to continue, but when you select Restore from Device and click the Add button, you get the error:
Cannot access the specified path of file on the server.
Environment
SQL Express Studio
Cause
The most common reason for receiving this error is because when SQL Management Studio is started and you are prompted for a username and password, Windows authentication is selected instead of selecting SQL Server Authentication.
Resolution
Verify that you have the necessary security privileges and that the path or file exists.