Help and Support
 

powered byLive Search

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

View products that this article applies to.
Article ID:295670
Last Review:September 4, 2002
Revision:1.1
This article was previously published under Q295670
On This Page

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.

Back to the top

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.

Back to the top

STATUS

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

Back to the top

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.

Back to the top

APPLIES TO
•Microsoft SQL Server 7.0 Standard Edition

Back to the top

Keywords: 
kbbug kbpending KB295670

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.