SQL Server Active Directory Helper - Server Error 1073741724

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"
Who is Participating?
It is not supposed to strt automatically. It starts when needed.

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)"

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.
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
and SQL 2005 is at Service Pack 2

I hope this helps for reference.

Error also evident in SQL Server 2008 x64 enterprise installed on Windows Server 2008 x64.  Event Log also offers no help in this case.
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?
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.