469,621 Members | 1,802 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.

When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,

The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service."

Please help.

Jul 23 '05 #1
1 5026
Water Cooler v2 (wt*****@yahoo.com) writes:
I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.

When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,

The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service."


You need to check the SQL Server errorlog, which is in
C:\Progam Files\Microsoft SQL Server\MSSQL\Logs. There is ERRORLOG and
then ERRORLOG.1 to .6, which are the most recent logs.

The only reason I can think of why SQL Server would start and then
stop, is that it runs into a fatal error.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by wally | last post: by
5 posts views Thread by =?Utf-8?B?R2VyYXJk?= | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.