Post reply

SQL Server Timeout setting - multiple error

  • 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

  • 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

  • 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.

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply