I have SQL 2005 Expess installed on Windows Server 2003 SP1.
My application is running as a service and is set to depend on SQL Server instance...
During the startup my app attempts to connect to the databes and it fails to do so, after 30 retries (1second appart). After I login and attempt to start the service manualy, everything is OK, and the service connects to Sql and runs fine....
SQL Server log has this error msg, if using SQL authentication:
Error: 18456 "Severity: 14, State: 10"
Error: 18456 "Severity: 14, State: 16"
if I use Windows authentication.
I've attached ERRORLOG and a trace dump created by running sql service with
'-y 18456' acommand arg.
That was suggested by Laurentiu Cristofor