SQL Server Active Directory Helper - Server Error 1073741724

Posted on 2007-08-06
Last Modified: 2013-11-05
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"
Question by:gavinandrewmcmillan
    LVL 2

    Author Comment

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

    LVL 9

    Accepted Solution

    It is not supposed to strt automatically. It starts when needed.
    LVL 1

    Expert Comment

    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.
    LVL 2

    Author Comment

    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.


    Expert Comment

    Error also evident in SQL Server 2008 x64 enterprise installed on Windows Server 2008 x64.  Event Log also offers no help in this case.

    Expert Comment

    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?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now