How can we help you today? How can we help you today?

Can the timeout period be extended?

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
Peter T
0

Comments

2 comments

Sort by
  • Daniel Handley
    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
    0
  • Peter T
    Hi Dan

    That worked!

    Many thanks for your prompt reply.

    Regards
    Peter
    Peter T
    0

Add comment

Please sign in to leave a comment.