Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL 2005 login time out Expand / Collapse
Posted Wednesday, April 17, 2013 7:13 AM


Group: General Forum Members
Last Login: Thursday, October 1, 2015 12:29 AM
Points: 169, Visits: 559
Hi Team,

Not able to connect to sql from mgment studio and using sqlcmd.

Also attached error from mgment studio
Getting below error using sqlcmd

HResult 0x102, Level 16, State 1
TCP Provider: Timeout error [258].
Sqlcmd: Error: Microsoft SQL Native Client : Unable to complete login process du
e to delay in login response.
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

CPU usage is 95 % and it is used by SQL server.

What should I do as not able connect using DAC as well.

  Post Attachments 
1.png (5 views, 39.10 KB)
Post #1443247
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse