Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to connect.

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)

Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to connect.

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-31 : 08:15:01

Gabriel Vaca writes "Hi,

I installed SQL Server 2000 SP3 on Windows 2003 Server. Installation went fine and SQL Server started ok. After restarting the server, MSSQLSERVER service didn't start. This is the error I'm getting on the event viewer:

==============================================================
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7009
Date: 1/26/2005
Time: 8:06:43 PM
User: N/A
Computer: NMXTOT04
Description:
Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to connect.

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

But the strange thing is that I can manually start the service.

Have someone gotten this problem? How was it solved? any ideas?

Thanks sa lot.

Gabriel Vaca"

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-01-31 : 11:51:34

Does the user that SQL Server is trying to startup using (look in the services control panel) have SA privileges to the database? Did the password change?

Have you removed the BUILTIN\Administrators group from SQL Server?

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources