Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
krajdba
Starting Member
43 Posts |
 Posted - 2008-02-14 : 02:09:08
|
| Hi SQL Server 2000 is installed(custom in stallation for the sake of collation) on windows 2003 SP2. However, SQL Server is not listening to any port....Please need urgent help.Here is the extract of the log file....2008-02-13 22:32:07.04 server All rights reserved.2008-02-13 22:32:07.04 server Server Process ID is 1544.2008-02-13 22:32:07.04 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.2008-02-13 22:32:07.06 server SQL Server is starting at priority class 'normal'(4 CPUs detected).2008-02-13 22:32:07.24 server Working Set size set to 1649536 kilobytes.2008-02-13 22:32:07.24 server SQL Server configured for thread mode processing.2008-02-13 22:32:07.24 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.2008-02-13 22:32:07.31 server Attempting to initialize Distributed Transaction Coordinator.2008-02-13 22:32:08.37 spid3 Starting up database 'master'.2008-02-13 22:32:08.50 server Using 'SSNETLIB.DLL' version '8.0.194'.2008-02-13 22:32:08.50 spid5 Starting up database 'model'.2008-02-13 22:32:08.50 spid3 Server name is 'HYDQASQLDB00'.2008-02-13 22:32:08.50 spid8 Starting up database 'msdb'.2008-02-13 22:32:08.50 spid10 Starting up database 'Northwind'.2008-02-13 22:32:08.50 spid9 Starting up database 'pubs'.2008-02-13 22:32:08.54 server SQL server listening on Shared Memory, Named Pipes.2008-02-13 22:32:08.54 server SQL Server is ready for client connections2008-02-13 22:32:08.64 spid5 Clearing tempdb database.2008-02-13 22:32:08.85 spid5 Starting up database 'tempdb'.2008-02-13 22:32:08.89 spid3 Recovery complete.2008-02-13 22:32:09.56 spid51 Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.2008-02-13 22:38:58.87 spid53 Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'sp_MSgetversion'.2008-02-13 22:39:10.66 spid54 Using 'xplog70.dll' version '2000.80.194' to execute extended stored procedure 'xp_msver'.Raj. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-14 : 02:24:25
|
| Open up Server Network Utility on the database server, enable TCP/IP, then select which port to use (default is 1433). Restart the SQL service.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
SQL Server 2000 not listening to any port