Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

External SQL connection

Status
Not open for further replies.

frosty90

Technical User
Aug 7, 2003
13
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top