Hey guys,
This might be a common problem to MS SQL Server users but my problem is a bit different from many of the similar problem explained on many forums.
I have SQL server database located on remote server, whenever I tried to access the database by using LAN(other computer on the same network with server) I'm able to connect but when I try to use other network such as modem I got the following error:
"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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)"
I have try to allow port 1433 on firewall exception then turn off firewall but the problem continues.
When I try to telnet the port 1433 by using LAN network it seems to success but when I'm using modem network it refuse connection.
I used online tools to telnet port 1433 but the status showed that it is closed. I checked with my network administrator they said they allow port 1433 through central firewall so the problem might be on my server.
My assumption is that network infrastructure prohibit 1433 port but if the problem is on my server, what is it? as I'm able to access through the LAN.
Any help will be appreciated.