MSSQLServerADHelper Service

I noticed on both nodes in my 2 node cluster the MSSQLServerADHelper service
was not started and set to manual. Is there a reason why this isnt started?
Is it safe to start and set to Automatic on both nodes?
Thanks,
JBaileyHere you can read about MSSQLServerADHelper here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9mhx.asp
Regards
---
All information provided below AS IS.
"JBailey" <abc@.123.com> wrote in message
news:uWZv$$8nDHA.488@.tk2msftngp13.phx.gbl...
> I noticed on both nodes in my 2 node cluster the MSSQLServerADHelper
service
> was not started and set to manual. Is there a reason why this isnt
started?
> Is it safe to start and set to Automatic on both nodes?
> Thanks,
> JBailey
>|||"JBailey" <abc@.123.com> wrote in message
news:uWZv$$8nDHA.488@.tk2msftngp13.phx.gbl...
> I noticed on both nodes in my 2 node cluster the MSSQLServerADHelper
service
> was not started and set to manual. Is there a reason why this isnt
started?
> Is it safe to start and set to Automatic on both nodes?
>
My understanding is this is only needed if you want to register your SQL
Server instance in Active Directory. It's not needed for your cluster...
from books online (see BOL for more information0:
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of
Microsoft® SQL ServerT 2000 relational database engine or Analysis server in
the Microsoft Windows® 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service
is running has permissions to update all of the Active Directory objects for
the instance, as well as any replication publications and databases for that
instance.
Steve

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 you
Gianluca
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 not
> 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:

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:
>

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 not
> 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:
> Gianluca
> 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 not
> > start in automatic mode and remain in starting. Only in manual mode.
> > Version
> > Sql server 2000 with sp3
> >
> > Thank you|||Have you rebooted the server? Did you check the event logs?
"Gianluca Danielli" wrote:
> Yes it is
> "Paul Zanbaka" wrote:
> > Gianluca
> > 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 not
> > > start in automatic mode and remain in starting. Only in manual mode.
> > > Version
> > > Sql server 2000 with sp3
> > >
> > > Thank you|||yes there are not errors in the event log
"fnguy" wrote:
> Have you rebooted the server? Did you check the event logs?
> "Gianluca Danielli" wrote:
> > Yes it is
> >
> > "Paul Zanbaka" wrote:
> >
> > > Gianluca
> > > 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 not
> > > > start in automatic mode and remain in starting. Only in manual mode.
> > > > Version
> > > > Sql server 2000 with sp3
> > > >
> > > > Thank you|||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:
> yes there are not errors in the event log
> "fnguy" wrote:
> > Have you rebooted the server? Did you check the event logs?
> >
> > "Gianluca Danielli" wrote:
> >
> > > Yes it is
> > >
> > > "Paul Zanbaka" wrote:
> > >
> > > > Gianluca
> > > > 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 not
> > > > > start in automatic mode and remain in starting. Only in manual mode.
> > > > > Version
> > > > > Sql server 2000 with sp3
> > > > >
> > > > > Thank you