Our sites that connect to mssql12 and mssql13 have been going down every couple of minutes all day. Your live chat system is taking 20 minutes for someone to answer and nobody is replying to my tickets either. Can someone look at this immediately? Thanks.
The live chat is not responding at all and your support staff is responding to my ticket saying nothing is wrong.
I can confirm that my site at teamcanadatourism.com is down and my development sites that connect to mssql13 are also still down. Can someone please look at this and help?
Ticket NSV-21960-873
There is nothing on MSSQL13 down, are you by any chance using the proxy IP/port for live websites? We have some people that have done that and it makes problems both for the proxy (too much load) and for the sites (they don’t need to use it at all) the proxy url on 173.0.136.201 is only for external management.
This was exactly the problem.
using the proxy URL and port for internal access. Making an extra step and cauisng extra proxy load.
The URL you gave was on MSSQL12, which is up and perfectly fine.
I changed the IP to the MSSQL12 IP and its loading great.
I will restart the proxy to get things up ASAP but PLEASE change thse strings as this will continue to happen and in fact the more people that use the EXTERNAL IP/PORT for live sites will make the proxy service more unreliable for the legit management uses.
What should I be using to connect to the database on MSSQL12 and 13 from my local machine instead of the IP/port? Thanks.
on YOUR machine use the string you had in the web.config, the 173.0.136.201,XXXX
But ONLY from your machine as you are in external network from the SQL server, the web servers and SQL are internal, so putting it through the external firewall is like sending your traffic out to come back in, and that makes a lot of continual sessions that can actually bring down the firewall/proxy as well due to the internal continual load levels.
Internally use the listed proper IP or name, always. It will be allowed to connect.
Hi Stephen,
A suggestion: can you block the proxy for internal access to prevent proxy overload? (by setting up firewall on the proxy-server for example)
Regards, Jan-Pieter
I will see if we can do that or not, not a bad idea but need to evaluate it if is feasible.