Unblock port 1433

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello experts,

I got a problem connecting my SQL Server which is located in another
machine. This machine has Windows Server 2003, our Server (manages the
network) has Windows 2000 Advanced Server, I don't know where to look if the
specific port has been blocked and how to unblock it.

Thanks in advance
 
Use the command netstat -an on the target server to see if the proper ports
are listening. If it is then firewalls, tcp/ip filtering, or ipsec policy
could be blocking access. Try to ping the target server by both IP address
and name to establish basic connectivity. You can use telnet [for TCP] or
the portqury tool to check if a particular port is open on a target
computer. Telnet [ telnet xxx.xxx.xxx.xxx 1433 ] will not allow you to set
up a session on that port but it can indicate if the port is open or not,
usually just showing a blinking curor instead of a connection failed
message.. --- Steve

http://support.microsoft.com/default.aspx?scid=kb;en-us;310099 ---
portqry.

portqry -n sqlserver1.com -p tcp -e 1433 as an example
 
Back
Top