You are currently offline, waiting for your internet to reconnect

The SQL Server service and the SQL Server Agent Service fail to start on a stand-alone server

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

This article was previously published under Q307288
SYMPTOMS
On a stand-alone server the MSSQLSERVER service may fail to start, and the following error message displays:
An error 1068 - (The dependency service or group failed to start.) occurred while performing this service operation on the MSSQLServer Service.
Similarly, the SQLServerAgent service may also fail to start, and this error message displays:
An error 1068 - (The dependency service or group failed to start.) occurred while performing this service operation on the SQLServerAgent Service.
This problem occurs if both of the following conditions are met:
  • The server computer is in a workgroup and not part of a domain.
  • Both the MSSQLSERVER and SQLServerAgent services are set to use a domain account for the startup.

CAUSE

Because the computer is a stand-alone computer, the NetLogon service does not start on the server, hence no domain-wide logon authentications are possible.

RESOLUTION

To resolve the problem, use these steps:
  1. Change the startup account of both the MSSQLSERVER and SQLServerAgent to use the Local System account.
  2. Restart the computer.
MORE INFORMATION
On a stand-alone computer, the NetLogon Service should be set for "manual" startup.

REFERENCES

For additional information running the NetLogon service on a stand-alone computer, click the article number below to view the article in the Microsoft Knowledge Base:
182720 Event IDs 7024 and 3095 on Stand-Alone Server
Properties

Article ID: 307288 - Last Review: 02/22/2007 22:33:50 - Revision: 4.3

Microsoft SQL Server 2000 Standard Edition, Microsoft SQL Server 7.0 Standard Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Express Edition, Microsoft SQL Server 2005 Workgroup Edition

  • kbinfo KB307288
Feedback
tml>