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 isnt starting

Hi everybody!
I need to move data from SQL Server7 to SQLServer2000 that is installed on a different machine.
Could anybody please advise a good way to do that?

I've installed SQLServer7 on a new machine, stopped MSSQLSERVER service ,started SQLServer in a single user mode (using sqlservr.exe from Command Prompt),successfully restored master db from the backup. When I tried ro start MSSQLSERVER service via Services console, get message "Could not start the MSSQLSERVER service on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error." I have Windows 2000 server.
Thank you in advanceHave you tried a detach and attach?|||detach and attach what? I use these sps dor databases. But I even can't start server|||check your private messages for my reply I hit the private message button by mistake when replying|||Thank you for your response. I know why I can't start server after restoring master db on the new machine from backup made on the old machine -- the physical names of the system dbs in the master backup point to the drives that do not exist on the new machine.