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"
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"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
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
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
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?
And also that solution of updating service pack doesn't work for me..
please suggest?
ASKER
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!