Can't Find Application When Attaching

Author: Joyce Zhou

Symptom

When trying to attach applications, this window doesn’t return any databases from the SQL Server.

Resolution

First, verify that you are pointing to the right SQL server. It is suggested to use the server name or IP address instead of localhost.

If you've confirmed you are referring to the right place, however nothing shows up, it might be a permission issue.

Locate your Kepion Service Identity in the IIS Manager.

Then open SQL Server Management Studio. Find the Kepion Service Identity in Security -> Logins. Right-click it and select Properties.

In Server Roles tab, ensure that  sysadmin is checked and click OK.

Navigate to the User Mapping tab, and for every Kepion Database in your environment that you want to attach, make sure that db_owner is checked.