Installed SQL Server, yet not listening on any port

Hi all,

I'm working on a school project on web and mobile applications, and had decided to use MS SQL Server for my backend database.

However, after I've installed MS SQL Server 2000, I ran a port scan and I couldn't find the server running on any ports (MySQL is running on my port 3306, but I guess it doesn't matter) Can something drop some hints on how to debug the problem?

I'm running on Athlon XP 2000+ w/ Windows XP Professional SP2

Thanks a lot!SQL Server runs on port 1433 by default, I believe. In your SQL Server group on the machine running SQL Server, there is a Client Network Utility. Go into that and ensure that TCP/IP is enabled.|||yes i went to the Enterprise Manager, under my Server Group's properties, went to Network Configuration and enabled both TCP/IP on port 1433 and Named Pipes. It still didn't work though.

Another thing I've noticed is that my server is named "(LOCAL) (Windows NT)." Could this be a hint that it's not listening for external connections?|||No, local is an alias for the machine you are on.

Are you certain that SQL Server is running? In Enterprise Manager, can you see the any databases?|||Yes I could see all the databases from the master database to the NorthWind and tempdb database.

The Distributed Transaction Coordinator, SQL Server and SQL Server Agent are all enabled.

Update: I've checked the Event Log. I think I probably know what's the problem.. Here is the message from the log:

You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with this version of Windows. To reduce your computer's vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install a patch, or the most recent service pack for Microsoft SQL Server 2000 or MSDE from http://www.microsoft.com/sql/downloads/default.asp

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I'll go patch up and reply if I had any more problems. Thanks for the help douglas.reilly!|||This is just to say that the problem is resolved after patching the SQL Server to SP3. Sorry for the trouble and thanks!sql