SQL Server Timeout setting - multiple error

• SQL_Helper

  SSC Eights!

  Points: 837

  More actions

  May 6, 2011 at 1:29 am

  #145271

  Hi;

  Team; I want to change SQL server 2005 timeout setting for TCP/IP. I m facing issue bcz of timout session, during load time I m facing this issue mostly.

  Following are some issues

  1 - [DBNETLIB] [ConnectionOpen] (PreLoginHandshake().] General Network error. check network documentation

  2 - TCP Provider An existing connection was forcibly closed by remote host

  sometime application running fine but some time it is showing error. Please suggest solution.

  Also share the detial to increase the timeout value in SQL 2005. can we set timeout value by using SQL configuration manger. pls share steps.

  Thanks

• Nagesh S-432384

  SSCrazy

  Points: 2231

  More actions

  May 6, 2011 at 2:51 am

  #1320851

  Try restarting your netwrok services, I think that sould fix it.

  Nag
  ------------------------------------------------
  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537

• SQL_Helper

  SSC Eights!

  Points: 837

  More actions

  May 6, 2011 at 3:58 am

  #1320871

  Thanks for the reply.

  can u please share the steps to restart n/w services (SQL 2005)

  also please confirm steps to increase the value of timeout session frrom SQL server 2005.

• Nagesh S-432384

  SSCrazy

  Points: 2231

  More actions

  May 6, 2011 at 4:45 am

  #1320889

  I would suggest talk to your network admins if you are not aware of how to do it.

  Nag
  ------------------------------------------------
  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537