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.
Comments
0 comments
Please sign in to leave a comment.