When connecting to the /Coresight/Admin page from a local computer (my local workstation) and I go to the PI Coresight Configuration Tab, the Database status shows a red 'X' and reads "SQL Server cannot be reached. Check the server's event log for details."
If I go to /Coresight/Admin from the server hosting Coresight, then it displays the green checkmark and reads configuration saved.
The error associated with the connection attempt from my local machine is this:
Timestamp: 1:12:41 PM
Message: Error while testing for SQL Server connectivity: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
App Domain: /LM/W3SVC/2/ROOT/Coresight/Admin-1-130203795693010984
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Anonymous Logon is disabled for the Coresight Application and under Admin.
The providers are set up to NTLM and negotiate.
IE settings are "Automatic logon with current user name and password."
Web.Config settings for the connection string is: "Integrated Security=True;" and for System.Web <identity impersonate="true" />
As a further note, from my local machine I can get the PI server status and the PI AF status. So, this is either because it is useing the app pool identity or a trust mapping. My initial inclination is that it is getting an error on the database connection because of a double hop if it is using my identity, which would explain the Anonymous Logon attempt.
So, I guess my question is, why is coresight trying to connect to the database as anonymous? is it because of the double hop? Or is there something missing that I need to fix, change, or set so that it impersonates me or the application pool?
Just trying to understand my system.
Thank you for any help.