Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've got SQL Server 2000 running on Win7. There's no management tools so I wonder how do I configure/interact with the server. Main purpose for me is to enable remote connections. I know how to do this with SQL Server 2008/Win7 but not with SQL Server 2000?

Is 1433 a default port for SQL Server 2000?

Is it possible to allow port thru Windows Firewall with Win7 Home Basic?


share|improve this question

closed as off topic by Massimo, Chopper3, Scott Pack, RobM, Sven Oct 28 '12 at 0:28

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

Do we want to know why you are trying to run an ancient SQL Server on a non-server OS? o.O You could turn off Windows Firewall to see if that is causing the issue. – tombull89 Feb 1 '12 at 10:35
@helicera - this is a site for PRO sysadmins, who wouldn't consider such a pointless and stupid configuration. – Chopper3 Feb 1 '12 at 10:37
up vote 1 down vote accepted

SQL Server 2000 allowa remote connections by default; Windows Firewall is what's probably stopping remote clients from connecting.

The default port for SQL Server 2000 (as for any SQL Server version) is TCP 1433.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.