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:
conn.Open "Provider=SQLOLEDB;Server=588B4A13EA;User ID=test;" & _
";Password=user;Initial Catalog=test;Network Library =dbmssocn"
I can also connect using internal IP address
ex:
conn.Open "Provider=SQLOLEDB;Server=192.168.2.136;User ID=test;" & _
";Password=user;Initial Catalog=test;Network Library =dbmssocn"
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.
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
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:
conn.Open "Provider=SQLOLEDB;Server=588B4A13EA;User ID=test;" & _
";Password=user;Initial Catalog=test;Network Library =dbmssocn"
I can also connect using internal IP address
ex:
conn.Open "Provider=SQLOLEDB;Server=192.168.2.136;User ID=test;" & _
";Password=user;Initial Catalog=test;Network Library =dbmssocn"
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.
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