- 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.
CAUSEBecause the computer is a stand-alone computer, the NetLogon service does not start on the server, hence no domain-wide logon authentications are possible.
RESOLUTIONTo resolve the problem, use these steps:
- Change the startup account of both the MSSQLSERVER and SQLServerAgent to use the Local System account.
- Restart the computer.
REFERENCESFor 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:
Article ID: 307288 - Last Review: Jul 10, 2008 - Revision: 1