SQL Port issue

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

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: Mysterious Port of SQL Server not shown by netstat
    ... If this fails then yoru SQL Server is not listening on 1433. ... port, only ms-sql-s). ... > My query analyzer client from local machine and remote machine> successfully connects to my server. ... There is a jdbc client which wants> to connect at port 1433 that fails saying could not establish network> connection at port 1433. ...
    (microsoft.public.sqlserver.programming)
  • Re: Parameterized query problem using Access Database in VS.NET2005
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... I want to have pramized query, ... I use SQL Server Management Studio Express and I applied the same ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADP problems after SQL 2005 Upgrade
    ... Use the SQL Server Configuration Manager to create aliases; ... each port can be associated only with a single instance. ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • [NT] Microsoft SQL Server 2000 Unauthenticated System Compromise
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Microsoft's database server SQL Server 2000 exhibits two buffer-overrun ... clients connecting to TCP port 1433 or both. ... This message is a single byte packet, ...
    (Securiteam)
  • Re: Do SqlServer 2000 & SqlServer 2005 co-exist
    ... Either SQL Server 2000 or SQL Server 2005. ... So you have to move one of them to another port. ... You could allow an program exception in your firewall instead of a port number exception. ... I understand that you can connect to SQL 2000 named instance on the local ...
    (microsoft.public.sqlserver.setup)