Can't start MSSQLServer services.

Hi,
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services 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 services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services 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 services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services 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 services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this problem?
>> I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>> Johny,
>> Are you using EM, Control Panel - Services or the Sevices Applet to start
>> the service? Might try using the local system account as a test to
>> ensure the service can start then check the permissions of the local
>> account you are using. Are there any informational errors reported in
>> the application event log?
>> A couple of things to look at.
>> HTH
>> Jerry
>> "Johnny Chow" <jchow10@.gmail.com> wrote in message
>> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services 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 services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this
>> problem? I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>>
>sql