| Author |
Topic |
|
carloscol
Starting Member
4 Posts |
 Posted - 2006-08-29 : 13:48:51
|
| Hi.I'm working with a new software here in the corporation and it uses the sql server to monitoring the information from a remote station or server.I can connect to the server from any PC in the same network segment (in the same vlan), but the problem appear when I need to connect from a computer in other vlan or in other site of the network.We use Cisco equipments; I think the problem is when the information pass trought the router, maybe it blocking the packets.I almost used a Port Scanner; the port 1433 is open from my pc to the remote server, but i can't connect.I hope you can help me.Grettings,Carlos C. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-29 : 14:50:34
|
| You should ask your network administrators for help with this.CODO ERGO SUM |
 |
|
|
carloscol
Starting Member
4 Posts |
Posted - 2006-08-29 : 15:03:09
|
| I'm the network administrator, but I don't have any idea to solve this. I'm tried everything...Thanks anyway...Carlos C. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-29 : 15:13:03
|
| First, what is the error that you are getting. Second, since you are the network administrator, you should know whether or not the packets are being blocked. Is there a firewall in between the SQL Server and the PC? Are you sure SQL Server was setup to use port 1433? We use ports that are 5 digits since 1433 isn't recommended when clients are connecting from the Internet.Tara Kizer |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-29 : 15:54:00
|
| a couple more questions to add to the mix:1. are you connecting to a named instance of sql server? does the instance have a backslash character in it's name?2. try using the portqryui tool from microsoft to test if you port is open. You can get it from here http://support.microsoft.com/kb/832919/-ec |
|
|
|
carloscol
Starting Member
4 Posts |
Posted - 2006-08-30 : 07:47:30
|
| The error in the software is: "Error communicating with the DAQ Server"No Firewalls between then.We use the sql into the same Corp Network, not across Internet.I'm connecting to a named (server name), We're sure i'm using the correct name, with backslash.I used the sniffer "Ethereal". The port is 1433 because I saw it in the sniffer. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-30 : 08:11:00
|
| Are you using different subnets?Peter LarssonHelsingborg, Sweden |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-30 : 08:57:23
|
| if you are connecting to a named server then UDP port 1434 must be open. have your network admin check to see if UDP 1434 is getting filtered at your router.-ec |
|
|
|
carloscol
Starting Member
4 Posts |
Posted - 2006-08-31 : 07:24:28
|
| Yes, I'm using different subnets. In the same subnet I don't have problems.When I use the "port scanner" the UDP port 1434 is not open, between the same subnet and in the different subnets. Also, if it is the problem, why we can connect in the same vlan?? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-31 : 07:44:23
|
| You have to configure your router to allow cross subnet access.Peter LarssonHelsingborg, Sweden |
|
|
|
|
SQL server connect problems