sql server 2014 time out issue

am getting Time out issue some particular time only is there any database or connection issue Please find the below error and advice

Error Description :         Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=7; handshake=14

August 17th, 2015 1:59am

There can be many reasons. So you are getting timeout issue when connecting Via SSMS, Application, some other tool how ?

Free Windows Admin Tool Kit Click here and download it now
August 17th, 2015 3:04am

@Shanky_621

Via Application

August 17th, 2015 3:16am

@Shanky_621

Via Applic

Free Windows Admin Tool Kit Click here and download it now
August 17th, 2015 3:22am

make sure the credentials used in your connection string are working.

your application is causing this error may be you have ling running queries in the background. 

you need to find out what queries are running in your page that causing the time out.

 
August 17th, 2015 3:29am

yes am getting particular database it is cache-database

Any specific error message in errorlog :NO IN SQL ERRORLOG

Free Windows Admin Tool Kit Click here and download it now
August 17th, 2015 3:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics