Can the timeout period be extended?

Peter TPeter T Posts: 3
edited June 9, 2005 6:56AM in SQL Compare Previous Versions
In my environment, it can take 30 seconds or more to connect to SQL Server on one of the servers. Unfortunately, SQL Compare times out after about twenty seconds. Is there any way in which I can increase the timeout period used by SQL Compare?

(I am aware of the other thread about timeout expired. I have put this in as a new thread as the slowness is not specifically caused by running SQL Compare.)

Regards
Peter T
· Share on Twitter

Comments

  • Daniel HandleyDaniel Handley Posts: 214
    Hi Peter

    If you want to change the connection string to take into account extending the timeout, or a SQL Server that does not use the default port, here is what you can do.

    When choosing the databases, in the field for the server change the entry to 'servername;Connect Timeout=1', or 'TCP:10.1.1.2,1433;Connect Timeout=1' (ignore quotes). In both these examples you have altered the connection timeout to 1 second, and in the second the connection is forced to use the IP protocol over the default port of 1433.

    I hope this helps

    Regards
    Dan
    Daniel Handley
    Red Gate Software Ltd
    · Share on Twitter
  • Peter TPeter T Posts: 3
    Hi Dan

    That worked!

    Many thanks for your prompt reply.

    Regards
    Peter
    · Share on Twitter
This discussion has been closed.