I have SQL Server 2000 running on my laptop at work as part of our development platform. I noticed recently when trying to export a database from another machine that the server on my machine was no listening on port 1433 like it should be. It is only using named pipes from what I can tell. I have set exceptions in my Windows XP firewall that allow both the program (sqlservr.exe) as well as the ports 1433TCP and 1434UDP from anywhere. There are no other firewalls. I have also done a netstat -an to get a listing of open and listening ports and it is not listed among them. If anyone has any ideas I would greatly appreciate the help getting this fixed. Thanks. Below is my error log:
2005-05-03 15:32:29.26 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2005-05-03 15:32:29.28 server Copyright (C) 1988-2000 Microsoft Corporation.
2005-05-03 15:32:29.28 server All rights reserved.
2005-05-03 15:32:29.28 server Server Process ID is 4132.
2005-05-03 15:32:29.28 server Logging SQL Server messages in file 'd:\MSSQL Datafiles\MSSQL\log\ERRORLOG'.
2005-05-03 15:32:29.31 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2005-05-03 15:32:29.81 server SQL Server configured for thread mode processing.
2005-05-03 15:32:29.83 server Using dynamic lock allocation.  Lock Blocks,  Lock Owner Blocks.
2005-05-03 15:32:29.88 spid3 Starting up database 'master'.
2005-05-03 15:32:30.11 spid3 0 transactions rolled back in database 'master' (1).
2005-05-03 15:32:30.12 spid3 Recovery is checkpointing database 'master' (1)
2005-05-03 15:32:30.21 server Using 'SSNETLIB.DLL' version '8.0.194'.
2005-05-03 15:32:30.21 spid5 Starting up database 'model'.
2005-05-03 15:32:30.26 server SQL server listening on Shared Memory, Named Pipes.
2005-05-03 15:32:30.26 server SQL Server is ready for client connections
2005-05-03 15:32:30.28 spid3 Server name is 'HM-ISDEV08'.
2005-05-03 15:32:30.28 spid3 Skipping startup of clean database id 5
2005-05-03 15:32:30.28 spid3 Skipping startup of clean database id 6
2005-05-03 15:32:30.28 spid3 Starting up database 'msdb'.
2005-05-03 15:32:30.48 spid5 Clearing tempdb database.
2005-05-03 15:32:31.47 spid5 Starting up database 'tempdb'.
2005-05-03 15:32:31.52 spid3 Recovery complete.