PRB: SQL Server Agent Reports Event ID:106 If You Install SQL Server on a Windows 2000 Domain Controller (295670)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q295670

SYMPTOMS

When you install SQL Server 7.0 onto a Microsoft Windows 2000 domain controller, and you configure the service accounts for the SQL Server Agent and the Microsoft SQL Server per the "Creating SQL Server Services User Accounts" topic in SQL Server Books Online, if you use a different account for each service, the SQL Server Agent reports an error message, similar to the following, every five (5) seconds in the Microsoft Windows NT application log:
Event Type: Error Event Source: SQLServerAgent Event Category: Service Control Date: mm/dd/yyyy Time: Time of the day User: N/A Computer: Computer name Description: SQLServerAgent security context does not have server-autorestart privileges.
This problem only occurs on a Windows 2000 domain controller and does not occur on a Member server.

This problem may also occur when the startup accounts and the registry permissions for SQL Server and the SQL Agent service are not configured as stated in the "Creating SQL Server Services User Accounts" topic in SQL Server Books Online.

WORKAROUND

To work around this problem either:
  • Make the SQL Server service start up account to a Domain Admin account.

  • Make SQL Server and SQL Agent services start up under the same domain account with appropriate rights.

  • Install SQL Server 7.0 cluster servers on Windows 2000 Member servers only.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Install a Windows 2000 domain controller with Windows 2000 Service Pack 1 (SP1).
  2. Install SQL Server 7.0 with SQL Server 7.0 Service Pack 3 (SP3).
  3. Create two accounts. One account for SQL Server and one account for the SQL Agent service with rights as detailed in the "Creating SQL Server Services User Accounts" topic in SQL Server 7.0 Books Online.
  4. Start the SQL Server service and the SQL Server Agent. Although the SQL Server Agent is started, it reports the following error message every five (5) seconds, which causes the Application event log to fill up:
    Even id 106: SQLServerAgent security context does not have server-autorestart privileges.
Modification Type:MajorLast Reviewed:9/4/2002
Keywords:kbbug KB295670
©2002 Microsoft Corporation. All rights reserved.