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.
Could you check the SQL Server error log and let us know if there are any
errors? Also check the event viewer. You can find the error log in MSSQL\Log
folder.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975209.034211.143030@.g49g2000cwa.googlegr oups.com...
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.

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.
Check the eventlog as well as SQL Servers errorlog file for error messages from SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975275.910843.25370@.g44g2000cwa.googlegro ups.com...
>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.
>

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.Water Cooler v2 (wtr_clr@.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, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

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.
Please do not multi-post. Many people have answered this in different
newsgroups.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975222.812999.50190@.g49g2000cwa.googlegro ups.com...
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.

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.Please do not multi-post. Many people have answered this in different
newsgroups.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975222.812999.50190@.g49g2000cwa.googlegroups.com...
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.