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

Timeout error while connecting to SQL instance Expand / Collapse
Author
Message
Posted Wednesday, December 4, 2013 7:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 4:19 AM
Points: 43, Visits: 106
Hi Experts,

I have one server with SQL server 2005 and 2008 R2, I am getting timeout error while connecting to SQL 2005 server.
When I restart the SQL server service, it shows error message 1053 and the service stops after that. It works without any error when I start the service again.
The SQL server works fine for one day but after sometime it again starts showing timeout error message when I try to connect this instance through SSMS.

Can you please help.
Post #1519622
Posted Wednesday, December 4, 2013 11:45 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 8:28 AM
Points: 588, Visits: 897
Have you viewed the error log? http://technet.microsoft.com/en-us/library/ms187885(v=sql.105).aspx If so, what was listed?



Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1519744
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse