Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  SQL Server 6.5 \ SQL Server 7.0  Connect using external IP

Author  Topic  pccrypt Starting Member 1 Post Posted - 2007-02-20 : 12:48:43 I have setup SQL 6.5 on a machine. I have verified that port 1433 is opened for SQL. I am also using a router dell 2300. I am running Windows XP. I have set up my machine to port forward and have setup a static ip 192.168.2.136 nothing I do seems to work. I can connect to the server by name ex: MyStr = "Provider=sqloledb;Data Source=MYSQLPC,1433;Network Library=DBMSSOCN;Initial Catalog=master;User ID=myusername;Password=password;" Conn.open MyStr I can also connect using internal IP address ex: MyStr = "Provider=sqloledb;Data Source=192.168.2.136,1433;Network Library=DBMSSOCN;Initial Catalog=master;User ID=username;Password=password;" Conn.open MyStr but when I try to connect to the external IP 12.xxx.xxx.xxx I get the dreaded sql does not exist error. I can register the server by external ip. When I try to start the server I get an (RPC server unavailable) error. I can ping the external ip. I can telnet 192.168.2.136 1433 without error I can connect though security manager using 12.xxx.xx.xx I can't telnet 12.xxx.xx.xx. I think its router but I do not know what I'm missing. I have static ip 192.68.136 set up. I have also read that some ISP's block port 1433 due to the worm problem. So I changed the listining port from 1433 to 1971. I am still able to connect using this new port. Cannot connect to external IP. Router Port Forward Settings Service Enabled In Port Dest Addy Dest Port Type MSSQLSER Y 1433-1434 192.168.2.136 1433-1433 TCP MSSQLSER Y 1434-1434 192.168.2.136 1434-1434 UDP I am not sure what I missing. Thanks in advance for any help Chris