[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

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

How to setup my window server 2003 that has SQL server 2000 running so that
my client can query data to it?
0
xtran888
Asked:
xtran888
  • 2
  • 2
1 Solution
 
BSonPoshCommented:
Do port connections not work?
Make sure to allow TCP 1433 inbound.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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...
0
 
xtran888Author Commented:
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
0
 
xtran888Author Commented:
Could you provide step by step to resolve this issue. I don't know
about SQL network setup.
Thanks,
xt
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now