Setting Window server 2003 which has SQL 2000 running on it to accept client query

Posted on 2007-09-28
Last Modified: 2010-04-21
How to setup my window server 2003 that has SQL server 2000 running so that
my client can query data to it?
Question by:xtran888
    LVL 18

    Expert Comment

    Do port connections not work?
    Make sure to allow TCP 1433 inbound.
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    ensure sql 2000 has at least SP3 (assuming that your windows 2003 has SP2 or higher)

    for the rest, you indeed need to ensure that there is no firewall, neither the windows firewall on the box itself nor some physical device on the network between the box and the client(s) that block the port, which is, by default 1433, but can be changed as needed.
    LVL 142

    Accepted Solution

    Now, you say you don't know how the sql network setup is done?

    in the start menu > program files> SQL Server > check out in the client tools, you should find a SQL Server Network Utility tool, which you should start up.
    in there, you find the config of the server.

    the rest that we explained about ports open, firewalls etc is completely outside of sql server...

    Author Comment


    Could you provide step by step to setup my SQL on Server 2003 (SP2) so that on WindowXP I can
    retrieve data from it?


    Author Closing Comment

    Could you provide step by step to resolve this issue. I don't know
    about SQL network setup.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    by Batuhan Cetin In this article I will be guiding through the process of removing a failed DC metadata from Active Directory (hereafter, AD) using the ntdsutil tool in a Windows Server 2003 environment. These steps are not necessary in a Win…
    by Batuhan Cetin Within the dynamic life of an IT administrator, we hold many information in our minds like user names, passwords, IDs, phone numbers, incomes, service tags, bills and the order from our wives to buy milk when coming back to home.…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    760 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

    10 Experts available now in Live!

    Get 1:1 Help Now