We have a MS SQL cluster database and 4 DB instances are currently running on it. For 4 DB instances, we have 4 virtual IP's and PI SDK is installed in all the four DB Instances.
When a PI SDK request goes from a virtual instance, by default the request should go with virtual IP to PI server. Instead of that PI SDK request goes with physical IP. for Example, PI SDK call is requested from virtual IP 10.123.45.100 and the physical IP of the SQL server is 22.214.171.124. In PI server message log, it's logged as the request went from 126.96.36.199 instead of 10.123.45.100.
Why the PI SDK call request goes with Physical IP instead of virtual IP.