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