Microsoft KB Archive/295670

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

Article ID: 295670

Article Last Modified on 9/4/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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 &quot;Creating SQL Server Services User Accounts&quot; 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 &quot;Creating SQL Server Services User Accounts&quot; 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.



Steps to Reproduce Behavior
 Install a Windows 2000 domain controller with Windows 2000 Service Pack 1 (SP1). Install SQL Server 7.0 with SQL Server 7.0 Service Pack 3 (SP3). Create two accounts. One account for SQL Server and one account for the SQL Agent service with rights as detailed in the &quot;Creating SQL Server Services User Accounts&quot; topic in SQL Server 7.0 Books Online. 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.



Keywords: kbbug kbpending KB295670

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.