Error: 18456, Severity: 14, State: 16(10) - by Srdjan

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


0
0
Sign in
to vote
ID 164046 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/14/2006 1:28:49 PM
Duplicates 164049 164050 164065 Access Restriction Public

Description

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"

and 
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

Srdjan
Srdjan
Sign in to post a comment.
Posted by Microsoft on 8/21/2006 at 3:21 PM
Hi,

Thank you for raising this issue. The error message appears to be by design. After SQL Server start up, the database is not immediately available and needs to come online before one can connect to it. Please see: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=552680&SiteID=1.

Regards,
Tomer Verona
SQL Server Engine