Home Dashboard Directory Help
Search

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


Status: 

Closed
 as By Design Help for as By Design


0
0
Sign in
to vote
Type: Bug
ID: 164046
Opened: 7/14/2006 1:28:49 PM
Access Restriction: Public
Duplicates: 164049 164050 164065
0
Workaround(s)
view
0
User(s) can reproduce this bug

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
Details
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
Sign in to post a workaround.