| Author |
Topic |
|
hfchen86
Starting Member
12 Posts |
 Posted - 2006-08-29 : 10:19:54
|
| I am developing windows application that requires remote access on sql server 2000. It requires a port-forwarding from a subnet router (IP 192.168.0.150) to the server workstation. So I opened the port 1433(TCP) on the router. However, I keep getting "server does not exist or access denied" error message.I have tested the subnet from the client workstation using PortQry. It does say port 1433 is not listening. However, the other ports I set up on the router are all listening, such as RDP(3389) and other applications. So I am asking whether this is on the router configuration side or on the sql server configuration side. Both server and client network utility have been set up on both server and client workstations. There is no problems with connection string. Can anybody help me out there?Thanks,Haifeng |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-29 : 10:57:31
|
are you are able to connect to the SQL Server from workstation (using Query Analyser ) on the same subnet using the IP Address and port no ?
KH |
 |
|
|
hfchen86
Starting Member
12 Posts |
Posted - 2006-08-29 : 12:00:54
|
| Yes, on the same subnet I have no problem whatsoever accessing the server from client workstation. I can use Enterprise manager, or .NET 2003 programmingly. I don't even need the IP in the connection string. All I need is just the server name.The problem only occurs when I try to access the server outside the subnet.Haifeng |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-29 : 18:40:56
|
But have you tried connecting to the server using the IP Address and port no ? Just to confirm the settings is fine
KH |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-29 : 22:06:28
|
Thanks Tara
KH |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-29 : 22:44:18
|
| I'm curious about this problem, and would like to help fix it.lets start with the router. what is the router make and model? firmware revision? Can you paste the router config you currently have in place? make sure you sanitize it so as to not reveal any proprietary information.-ec |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-30 : 05:50:30
|
I think maybe a diagram showing how the various divices (Server, Router, firewall) are connected with IP info (IP addr, mask, gateway) of the various divices will be very much helpful.
KH |
|
|
|
hfchen86
Starting Member
12 Posts |
Posted - 2006-08-30 : 16:58:17
|
| Thanks guys, I was occupied the last 24 hours, so I didn't check this post. I am going to post the information of our network and some configuration of the router.I have trouble pasting a diagram here, so let me describe it.There is one router directly connected to the cable modem. The client workstation and a second router (IP 192.168.0.150 ) are connected to the first router, i.e. they are on the same subnet. The server is connected to the second router, which is a Linksys WRT54G. The second router's local IP is 192.168.1.1.Below is the configuration of the second router:Application Start End Protocol IP EnabledRemote 3389 to 3389 Both 192.168.1.104 Sqlserver 1433 to 1433 TCP 192.168.1.104 Sqlserver 1434 to 1434 UDP 192.168.1.104Above is the Gaming and Application page, I omitted the irrelevant information. All 3 application have their "Enabled" box checked. I put Remote here because the port is open for RDP, but not listening on Sqlserver. Static IP Internet IP Address: 192.168.0.150 Subnet Mask: 255.255.255.0 Gateway: 192.168.0.1Local IP Address: 192.168.1.1Above is the Set Up page of the second router.I hope the information above is helpful.Thanks again,Haifeng |
|
|
|
|
opening port on sql server 2000