Connect to SQL server 2000 with TCP/IP not working

Posted on 2007-10-13
Last Modified: 2012-08-13

I have a SQL 2000 box which works fine with Named Pipes.
I'm trying to connect via TCP/IP. However, I get a connection error message of SQL Error : 10054 and SQL Error 11 even when trying to connect locally when testing a System DSN against the database.
Tried other databases on the same box and get the  same connection error.

TCP/IP is installed in SQL Server Network Utility, default port.
Still no luck.
Question by:Waxed
    LVL 8

    Expert Comment

    have you tried to turn off the windows firewall?
    LVL 8

    Expert Comment

    go into the command prompt, and type

    netstat -an

    to see if the ports are open. you can also use a port monitoring tool like tcpview

    LVL 8

    Expert Comment

    is the sql server installation upgraded to the latest version? before a version sql server 2000 blocks tcp/ip connections due to a security problem.

    Author Comment

    I have
    TCP               LISTENING
    Don't see the local socket.

    Author Comment

    SQL SP4 installed.
    no windows firewall.
    Box is Win2k/SP4
    LVL 8

    Expert Comment

    hey waxed,

    Sorry for the latency.

    have you checked the sql server logs for further info on the error? I have read several ms forum threads and articles on the subject, it seems like nobody got a proper solution or the cause of the problem, seems to be an odbc issue with tcp/ip connections. may be related to the network libraries, re-installation of some components may work here.

    Due to the error message, you can connect to the server, but your connection is getting reset by the server. So the server listens to the ports and get connections.

    At first, we haven't talk about the details on the server configuration. The tcp/ip may be enabled but not for the network interface the software tries to connect, so try this one;

    Secondly, try to directly connect using Enterprise Manager, to see if the problem is related with ODBC or a command sent by the application at the first connection.

    It may be related with the instances, here is a good compiled list of connection issues, mostly valid for sql server 2000:

    Here is why it may be the result of an action :

    There are also some threads related to this problem in Experts Exchange, they can give an idea, but they are mostly resolved in a different way, like moving the databases to another software, anyway here they are for your info:

    In my opinion, it is probably related to network configuration, existance of unused protocols (named pipes etc), instances, or broken network library.

    Please let me know any improvements. Good luck.

    LVL 1

    Accepted Solution

    PAQed with points refunded (500)

    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now