MSSQLServerADHelper – Event Id 100

Error Message:
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 10/12/2007
Time: 10:30:47 AM
User: N/A
Computer: SQLSRV
Description:
‘0’ is an invalid number of start up parameters. This service takes two start up parameters.

Cause.
You should get this error when MSSQLServerADHelper service is set to automatic or you started the service manually.

Solution
The MSSQLServerADHelper service should be set to manual. SQL Server will start and stop the service itself when needed. You should let SQL Server manage it.

Information

The MSSQLServerADHelper service performs two functions:

• It adds and removes the objects used to register instances of Microsoft® SQL Server™ 2000 relational database engine or Analysis server in the Microsoft Windows® 2000 Active Directory™.
• It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.

The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.

For more information about this service …