<div>
Do port connections not work?<br />
Make sure to allow TCP 1433 inbound.
</div>


<div>
ensure sql 2000 has at least SP3 (assuming that your windows 2003 has SP2 or higher)<br />
<br />
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.
</div>


<div>
HI,<br />
<br />
Could you provide step by step to setup my SQL on Server 2003 (SP2) so that on WindowXP I can<br />
retrieve data from it?<br />
<br />
Thanks,<br />
X
</div>


<div>
Could you provide step by step to resolve this issue. I don't know<br />
about SQL network setup.<br />
Thanks,<br />
xt
</div>


<div>
<div class="content wysiwyg-content">
How to setup my window server 2003 that has SQL server 2000 running so that<br />
my client can query data to it?
</div>
</div>


How to setup my window server 2003 that has SQL server 2000 running so that
my client can query data to it?

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

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.

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

Could you provide step by step to resolve this issue. I don&#39;t know
about SQL network setup.
Thanks,
xt

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

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).