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
Author
Message
Posted Wednesday, April 17, 2013 7:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:01 AM
Points: 112, Visits: 421
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