I'm seeing some odd behaviour with apps that use SQL where the app is on a terminal server. The terminal server has an app installed and works perfectly when the PAN TS agent is not running. When the agent is started, the application throws up lots of connection errors.
This happens with multiple terminal servers, multiple app and multiple SQL servers.
Has anyone else seen behaviour like this at all?
If im not mistaken using TS-agent will assign a portrange per user on the server which the TS-agent then informs the PA device of.
Like sending info to the PA device that if an outbound connection is made where sourceport is 1100-1199 then the PA should log this as userX. If port 1200-1299 is used then its userY and so on.
However im not sure if its the TS-server that does on its own and the TS-agent just reads these values or if its the TS-agent who configures the TS-server for this.
So my thought is if your application for some reason tries to use its own srcports which the TS-server simply just drops (because its not the srcports which is assigned to the user running your application) so your app logs connection errors?
Siebi and UKRB,,
I too have run into the same issue,,,we just spun up 300 TS-agents on the weekend and had to disable about 70 agents
due to issues with SQL connnections. One of my thoughts is reserved ports for system services. We may need to expand
these to say 1025-10000. I looked at the netstat -a table for some of these servers having the issue and most of the
sql connections are sourced from between 1025-7000....
Has anybody found a solution yet? At this point just shootin from the hip! 🙂
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!