SQL Server startup problem - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Server startup problem

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-03 : 08:27:41

Ken writes "Hi,

I have a tough question here.
I have tried to start the SQL server it keeps showing me that connection timeout while I open enterprise manager.
And in SQL Analyzer, I got the same error message. And when i expand the object explorer, there is no database shown in it.
When i examined the Server log file, I got the following:

2004-06-30 12:17:31.59 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2004-06-30 12:17:31.59 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-06-30 12:17:31.59 server All rights reserved.
2004-06-30 12:17:31.59 server Server Process ID is 6624.
2004-06-30 12:17:31.59 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-06-30 12:17:31.60 server SQL Server is starting at priority class 'normal'(4 CPUs detected).
2004-06-30 12:17:31.73 server SQL Server configured for thread mode processing.
2004-06-30 12:17:31.73 server Processor affinity turned ON, processor mask 0x3
2004-06-30 12:17:31.73 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2004-06-30 12:17:31.76 server Attempting to initialize Distributed Transaction Coordinator.
2004-06-30 12:17:33.81 spid2 Starting up database 'master'.
2004-06-30 12:17:33.89 spid2 0 transactions rolled back in database 'master' (1).
2004-06-30 12:17:33.89 spid2 Recovery is checkpointing database 'master' (1)
2004-06-30 12:17:33.95 server Using 'SSNETLIB.DLL' version '8.0.760'.
2004-06-30 12:17:33.95 spid5 Starting up database 'model'.
2004-06-30 12:17:33.96 spid2 Server name is 'COGNOS-TS'.
2004-06-30 12:17:33.96 server SQL server listening on 128.123.19.14: 1433.
2004-06-30 12:17:33.96 server SQL server listening on 192.168.234.235: 1433.
2004-06-30 12:17:33.96 server SQL server listening on 127.0.0.1: 1433.
2004-06-30 12:17:33.96 spid8 Starting up database 'msdb'.
2004-06-30 12:17:33.98 spid9 Starting up database 'pubs'.
2004-06-30 12:17:33.98 spid10 Starting up database 'Northwind'.
2004-06-30 12:17:33.98 spid11 Starting up database 'AeonDW'.
2004-06-30 12:17:33.98 spid12 Starting up database 'AeonDW_backup'.
2004-06-30 12:17:34.01 spid8 Bypassing recovery for database 'msdb' because it is marked BYPASS.
2004-06-30 12:17:34.12 spid5 Clearing tempdb database.
2004-06-30 12:17:34.75 spid5 Starting up database 'tempdb'.
2004-06-30 12:17:36.25 server SQL server listening on TCP, Shared Memory, Named Pipes, Rpc.
2004-06-30 12:17:36.25 server SQL Server is ready for client connections
2004-06-30 14:27:13.50 spid52 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.

The problem seems to be related to the msdb.
Please help on this issue since I have struggled for this for 2 weeks.

Thanks in advance!!"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-03 : 12:31:53

I don't see anything wrong in your error log. Is the database server behind a firewall?

Tara