Cannot start up local server

Recently I cannot start up my local SQL 2000.
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER 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 server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER 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 server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>|||Uri Dimant wrote:
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> > Recently I cannot start up my local SQL 2000.
> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
> > got a message box:
> > "The MSSQKSERVER 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 server"
> >
> > I tried to start 'Performance Logs and Alerts server' and still get the
> > same message box.
> >
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> Uri Dimant wrote:
>> Alan
>> Any errors in Event Viewer
>>
>>
>> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> > Recently I cannot start up my local SQL 2000.
>> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
>> > got a message box:
>> > "The MSSQKSERVER 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 server"
>> >
>> > I tried to start 'Performance Logs and Alerts server' and still get the
>> > same message box.
>> >
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>|||Alan T wrote:
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> >
> > Uri Dimant wrote:
> >
> >> Alan
> >>
> >> Any errors in Event Viewer
> >>
> >>
> >>
> >>
> >> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> >> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> >> > Recently I cannot start up my local SQL 2000.
> >> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
> >> > got a message box:
> >> > "The MSSQKSERVER 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 server"
> >> >
> >> > I tried to start 'Performance Logs and Alerts server' and still get the
> >> > same message box.
> >> >
> >
> > Try to find out errors in Event Viewer or SQL Server Errorlog.
> >
> > Regards
> > Amish Shah
> > http://shahamishm.tripod.com
> >
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com|||Hi,
Yes I opened the eventviewer and knowing my evaluation copy of SQL 2000
Enterprise has expired.
Can I install the SQL 2000 Developer Edition on the top of it?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161240339.590000.279530@.m7g2000cwm.googlegroups.com...
> Alan T wrote:
>> Sorry, how do I open the EventViewer ?
>> "amish" <shahamishm@.gmail.com> wrote in message
>> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
>> >
>> > Uri Dimant wrote:
>> >
>> >> Alan
>> >>
>> >> Any errors in Event Viewer
>> >>
>> >>
>> >>
>> >>
>> >> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> >> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> >> > Recently I cannot start up my local SQL 2000.
>> >> > I goto services panel, select MSSQLSEREVR, right click select
>> >> > 'Start',
>> >> > got a message box:
>> >> > "The MSSQKSERVER 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 server"
>> >> >
>> >> > I tried to start 'Performance Logs and Alerts server' and still get
>> >> > the
>> >> > same message box.
>> >> >
>> >
>> > Try to find out errors in Event Viewer or SQL Server Errorlog.
>> >
>> > Regards
>> > Amish Shah
>> > http://shahamishm.tripod.com
>> >
> go to start--> run
> type eventvwr
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>