So, I have an application that connects to our SQLServer. This works great on any server behind a firewall.
When I pulled it to our live server, outside of the firewall, the connection to sqlserver failed
A network-related or instance-specific error occurred while establishing a connection
to SQL Server. The server was not found or was not accessible. Verify that the instance
name is correct and that SQL Server is configured to allow remote connections. (provider:
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I know this is related to the firewall, although the network administrator claims that the firewall allows it (even went so far as to say "your mistake")
What can I do to see exactly where I can’t see if this is really a firewall and prove to him that it is. I use the IP address of the machine, so this is not a DNS problem. Any other ideas?
source
share