Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 37220
  • Last Modified:

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"
0
gavinandrewmcmillan
Asked:
gavinandrewmcmillan
1 Solution
 
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
 
sguinn100Commented:
It is not supposed to strt automatically. It starts when needed.

 http://msdn2.microsoft.com/en-us/library/ms143504.aspx
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now