Monday, March 19, 2012

mssqlserver service doesn't start

after installing report services and sp2 , the service mssqlserver does not
start in automatic mode and remain in starting. Only in manual mode.
Version
Sql server 2000 with sp3
Thank youGianluca
Make SQL Service is set to auto-start.
--
Paul Zanbaka
DBA, Programmer Analyst
"Gianluca Danielli" wrote:

> after installing report services and sp2 , the service mssqlserver does no
t
> start in automatic mode and remain in starting. Only in manual mode.
> Version
> Sql server 2000 with sp3
> Thank you|||Yes it is
"Paul Zanbaka" wrote:
[vbcol=seagreen]
> Gianluca
> Make SQL Service is set to auto-start.
> --
> Paul Zanbaka
> DBA, Programmer Analyst
>
> "Gianluca Danielli" wrote:
>|||Have you rebooted the server? Did you check the event logs?
"Gianluca Danielli" wrote:
[vbcol=seagreen]
> Yes it is
> "Paul Zanbaka" wrote:
>|||yes there are not errors in the event log
"fnguy" wrote:
[vbcol=seagreen]
> Have you rebooted the server? Did you check the event logs?
> "Gianluca Danielli" wrote:
>|||If the service attempts to start but fails then there should be an error in
the NT System log. Is there?
If not, and it is set to stat automatically (Verify through control panel
services) then I think you need to speak with MPSS. My guess is that there
are errors in the system event log.
"Gianluca Danielli" wrote:
[vbcol=seagreen]
> yes there are not errors in the event log
> "fnguy" wrote:
>

No comments:

Post a Comment