Connecting to SQL server behind firewall advice
Posted on 2013-06-01
I have an app that I have written that uses a SQL server that is behind a firewall. Each user has to launch iexpolorer then click a web link that lists all our firewalls before launching my app.
The problem is that it takes 60 seconds or more for either the firewall or SQL server to timeout in my app (not sure which). After which I pop a messagebox with a link to the webpage with the firewall links. Users are impatient because my app gives the appearance that nothing is going on.
I need some way to check the firewall state as soon as my app opens.
I thought what about internet history, I could check that when my app opens. I found some code that gets the history which I search for the firewall link.
But is there a way to check if the user connected to the firewall today? is there a date associated with the history.