The following additional items need to be updated.
Open IIS on the server where web console is installed (GSS server)
Navigate to the Application Pools -> GSSWebConsole
Right Click on GSSWebConsole and click on “Advanced Settings” option
In “Advanced Setting” option edit the “Identity” option present under “Process Model” tab
Set the user for “Custom account” which has Database access.
Then go to …..\Sites\Default Web Site\gss\api level in IIS
Under Authentication disable the ASP.NET Impersonation option for AP.
Restart the IIS service
Open your browser and navigate to the web page of your Ghost console and Log in to the web console with an Admin user account.
http://localhost/gss/server as an example from the Ghost server.
On settings page of web console add and save any user which is present in Active Directory and has read level access
With these settings in place the web console should display proper data for both on box and off box SQL instances. Additionally these settings should allow for use of console security features to be enabled on the GSS server.
Subscribing will provide email updates when this Article is updated. Login is required.