SQL Server Active Directory Helper - Server Error 1073741724

Hello
The service SQL Server ACtive Directory Helper (Auto Start Service) has stopped running, when I go into Services in the MMC and try to manually start it I get the following error:
"Windows could not start the SQL Server Active Directory Helper on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code - 1073741724"

The error shown in the event log that shows up is:
"'0' is an invalid number of start up parameters. This service takes two start up parameters"
LVL 2
gavinandrewmcmillanAsked:
Who is Participating?
 
sguinn100Commented:
It is not supposed to strt automatically. It starts when needed.

 http://msdn2.microsoft.com/en-us/library/ms143504.aspx
0
 
gavinandrewmcmillanAuthor Commented:
Hi Again

Found an additional error in Event Viewer under System (previous under application), the error is:
"The SQL Server ACtive Directory Helper service terminated with service-specific error 3221225572 (0xC0000064)"

Cheers!
0
 
albemarlecityCommented:
Same issue here, and the service is set to start manual.  Interesting but the only info I can find has to do with Authentication issues but I can't seem to put it all together.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
gavinandrewmcmillanAuthor Commented:
Hi Guys

Just letting you all know how it went... sorry for such a late reply. Make sure you have the current service packs for SQL and SBS 2K3 (if you have SBS OS 2K3). This was my issue, I was a service pack behind. Once going through the update process all was corrected and I no longer get the error.

Currently SBS 2K3 is up to Service Pack 2
        https://www.microsoft.com/downloads/details.aspx?familyid=95AC1610-C232-4644-B828-C55EEC605D55&displaylang=en
and SQL 2005 is at Service Pack 2
        http://technet.microsoft.com/en-us/sqlserver/bb331754.aspx 

I hope this helps for reference.

Regards
Gavin
0
 
lieslkellyCommented:
Error also evident in SQL Server 2008 x64 enterprise installed on Windows Server 2008 x64.  Event Log also offers no help in this case.
0
 
znetindiaCommented:
If it is 2008 server then what is the solution for that error...

And also that solution of updating service pack doesn't work for me..

please suggest?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.