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.

Troubleshooting005-01

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 …

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: