Our server connects to a firewall and then out to the internet. For some reason, when our external connection is lost, I can no longer connect to the SQL Server. I am connected to the server in Enterprise Manager by using the server name "myserver1" and using windows authentication. We are using internal IPs (192.168.*.*).
When our internet connection goes down, I get a timeout error when trying to connect to the SQL Server. I can still access files from the server though. Any idea why I wouldn't be able to see SQL server when our connection is lost?
It's almost as though Enterprise Manager is trying to connect to the server through an external IP. Why would this be?
Any help would be much appreciated. Our connection keeps going down and I am dead in the water when this happens. Please Help!
Thanks.
When our internet connection goes down, I get a timeout error when trying to connect to the SQL Server. I can still access files from the server though. Any idea why I wouldn't be able to see SQL server when our connection is lost?
It's almost as though Enterprise Manager is trying to connect to the server through an external IP. Why would this be?
Any help would be much appreciated. Our connection keeps going down and I am dead in the water when this happens. Please Help!
Thanks.