Re: SQL Port issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Try using the client network utility, create an alias using
TCP/IP and use the IP address for the server, uncheck the
dynamically determine port and specify the port SQL Server
is using.

-Sue

On Mon, 28 May 2007 10:43:10 -0400, "Rogers"
<naissani@xxxxxxxxxxx> wrote:

I have Windows 2003 Server and installed SQL Server 2000 Sp 4 behind the
firewall. I open the Portal 3389 TCP, 1433 TCP, 1434 UPD. when I try to
connect SQL Server from my local box it says SQL Server doesn't exists or
access denied.

when I run the following query in my local box.

telnet 201.121.161.82 3389 (the window got clear that means this port is
working fine.)

telnet 201.121.161.82 1433 (Connecting To 201.121.161.82...Could not open
connection to the host, on port 1433: Connect failed)

I am wondering if I open both the port on the Server then why its giving me
an error for 1433 port, can you guide me?


.

Relevant Pages

  • Re: SQL2005: Cannot connect error 11001
    ... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • Re: Failed connections to remote 2k SQL Server
    ... It could be a port issue - that would be my first guess. ... you need to open up UDP 1434 for SQL Server name ... TCP Ports Needed for Communication to SQL Server ... >server's network utility, and client network utility, and ensured that they ...
    (microsoft.public.sqlserver.setup)
  • Re: Connecting to an instance in a cluster
    ... Each virtual server has its own IP address so you can reuse port numbers between instances. ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Opening a TCP/ IP Port or Port Listener
    ... > Go to server network utility and specify the new tcp port there (you have ... > restart the sql server service for this change to take effect). ...
    (microsoft.public.sqlserver.security)
  • RE: Some technical errors
    ... If the SMTP server is not running on port 25 TCP it is not a public ... Manager - Computer Assurance Services BDO Chartered Accountants & ...
    (Security-Basics)