We deploy software on a dedicated server. It's a Windows 2003 server with SQL Server 2005 and IIS. We have four .Net Windows Services that run on the server. At one client location two of the four services are failing to connect to the database following a reboot.
The error for both is "Login failed for user 'NT Authority\System'".
Restarting the services fixes the problem...until the next reboot.
- Our Windows Services and SQL Server are all set to run as "Local System".
- SQL Server is a named instance with mixed-mode authentication; though it's the only instance on the server.
- 'NT Authority\System' and 'BuiltIn\Administrators' both have logins to SQL Server.
- It seems likely that the two services are starting before SQL Server, but all four services have "SQL Server (SQL01)" listed as a "dependency".
Any ideas?