dimanche 29 novembre 2015

Cannot connect to MSSQL server with IP remotely, after opening port + adding windows firewall inbound rules

I am having trouble connecting remotely to the a DB instance in a computer with sql server 2005.

I have checked the settings in sql configuration manager: IPALL have the port number "1466" set in "TCP Port" that I set

sql server + browser added to firewall allowed list

allowed both port "1434 + 1466" in windows firewall inbound rules

Forwarded both port 1434 + 1466 TCP/UDP

set IP Address to static IP address, same in cmd > ipconfig

I can connect with the local IP address with SQL authentication in "SQL Server Management Studio Express" ( "ipaddress/instancename, 1466"

but when I replaced the IP with the IP I get at Whatismyip.com, in the format of "ipaddress/instancename, 1466" I get error: 0 and cannot connect

try to ping the whatismyip.com IP address locally, it worked

but when I ping it from another computer remotely 4 request => 4 timeouts, 100% loss

Does this have anything to do with router firewall?

Aucun commentaire:

Enregistrer un commentaire