# \ issue **URL:** \ **Category:** Toad for SQL Server\ **Created:** [December 25, 2012, 12:46am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108 "2012-12-25T00:46:53Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![vane](https://avatars.discourse-cdn.com/v4/letter/v/f1d935/32.png) [@vane](https://forums.toadworld.com/u/vane)\ **Post date:** [December 25, 2012, 12:46am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/1 "2012-12-25T00:46:53Z")
I encountered a problem when connecting to Server 1. The error message is “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.” I think the cause is in the server, because I can connect to server 2 which has similar environment to server 1 but Active Directory uninstalled. Does anyone know how to solve it? Thanks. Client: Win 7 Pro SP1 64-bit / ToadSS 5.8.0.831 Server 1: Win Server 2003 SP2/ SQL Server 2000 / Active Directory installed. Server 2: Win Server 2003 SP2/ SQL Server 2000 ---
**Author:** ![vane](https://avatars.discourse-cdn.com/v4/letter/v/f1d935/32.png) [@vane](https://forums.toadworld.com/u/vane)\ **Post date:** [December 28, 2012, 1:45am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/2 "2012-12-28T01:45:54Z")
Now I found that ToadSS 5.7.0.605 works well so I’ve downgraded to this version. Connection failure occurs only in 5.8 (including beta). Hope this issue won’t take place in 5.9. \>\_\< ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [January 25, 2013, 9:26am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/3 "2013-01-25T09:26:42Z")
Hello, Sorry for the silence. I’m afraid we do not fully understand the issue and therefore can’t reproduce it on our side. I’ve never confronted with such kind of issue and do not remember any complaints from the users… Can you please describe a bit more the differences between these two servers? What do you mean by Active Directory installed/uninstalled? Another supposition - can you reset TSS 5.8/6.0 settings to the default values to see if it can help? Also - can you try to connect to Server 1 from any other machine from your network or outside? Alexander Message was edited by: Alexander.Maximov ---
**Author:** ![vane](https://avatars.discourse-cdn.com/v4/letter/v/f1d935/32.png) [@vane](https://forums.toadworld.com/u/vane)\ **Post date:** [January 28, 2013, 1:58am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/4 "2013-01-28T01:58:03Z")
I've tried to connect to Server 1 from other machines on my network and the result is successful. I think the problem is in my machine. However, I can't find the cause of the issue and don't know why 5.7 works well but 5.8/6.0 doesn't. How to reset settings to the default values? I used Configuration Wizard and chose Default and then reconnect, but it doesn't help. ![2013-01-28_151536.png](https://global.discourse-cdn.com/quest/original/2X/f/f23f9af1b82e951c695888324887ade49c196f07.png) ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [January 29, 2013, 8:10am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/5 "2013-01-29T08:10:55Z")
To reset settings to default values - close Toad instance and rename or delete this folder: Vista/W7: c:\Users\AppData\Roaming\Quest Software\Toad for SQL Server 6.0 XP: C:\Documents and Settings\Application Data\Quest Software\Toad for SQL Server 6.0\ Start Toad and do not migrate settings from any previous version. Please get back with results. In case of error - I need some more information about your environment, ---
**Author:** ![vane](https://avatars.discourse-cdn.com/v4/letter/v/f1d935/32.png) [@vane](https://forums.toadworld.com/u/vane)\ **Post date:** [January 29, 2013, 9:04pm UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/6 "2013-01-29T21:04:34Z")
The result is still the same. Please tell me what kind of information do you need? ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [January 30, 2013, 7:54am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/7 "2013-01-30T07:54:19Z")
You mentioned this difference between Server 1 and 2: Active Directory installed. I’m afraid I don’t fully understand what does it mean. BTW, please review TSS 5.8 Release Notes - starting from this release Toad started to loose support for SS 2000 in some areas. Sorry, but it it too old server version to fully support it. ---
**Author:** ![vane](https://avatars.discourse-cdn.com/v4/letter/v/f1d935/32.png) [@vane](https://forums.toadworld.com/u/vane)\ **Post date:** [January 30, 2013, 8:22am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/8 "2013-01-30T08:22:32Z")
Active Directory is installed in Server 1, therefore I thought maybe I don’t have permission to access Server 1 because my PC isn’t joined AD. However, I found the cause of connection failure isn’t related to it after trying to connect to Server 1 using other machines; moreover, my PC can connect to Server 1 by using TSS 5.7. I have noticed Release Notes already, but I don’t think it is the reason. As I mentioned previously, TSS 5.8/6.0 works well in other machines except for my PC. ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [February 28, 2013, 4:42am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/9 "2013-02-28T04:42:42Z")
Hi vane, Let’s try to see this from another side - what is Server name in Connection Properties dialog for the problem server? Just so you know - it may be defined in different ways: IP IP,port hostname hostname\instancename ---
**Author:** ![vane](https://avatars.discourse-cdn.com/v4/letter/v/f1d935/32.png) [@vane](https://forums.toadworld.com/u/vane)\ **Post date:** [March 1, 2013, 12:34am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/10 "2013-03-01T00:34:54Z")
The server name is WEBSERVER. By the way, I get error message ‘ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.’ when I run Automation. How to solve it? Exporting files in Access format works well except for using Automation. Thank you. ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [March 1, 2013, 2:52am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/11 "2013-03-01T02:52:45Z")
OK I see, Did you have a chance to specify connect string in other formats like I noted above? In our environment we also having some problems to connect from non-domain computer to domain server. IP ofter helps. But IP,Port works all the time. Please try. Regarding Error 42000 - can you please start separate topic so it can be easily tracked? ---
**Author:** ![vane](https://avatars.discourse-cdn.com/v4/letter/v/f1d935/32.png) [@vane](https://forums.toadworld.com/u/vane)\ **Post date:** [March 5, 2013, 12:33am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/12 "2013-03-05T00:33:52Z")
It doesn’t work even if I use IP to connect to the server 1. Connecting from my PC to server 1 using IP or Server Name works well Only in ToadSS 5.7. In later versions of ToadSS, all connection results of server 1 are failed. However, the result of using another machine which has the same OS with mine and every version of ToadSS is successful. ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [March 5, 2013, 9:43am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/13 "2013-03-05T09:43:39Z")
Seems something definetely wrong with your PC settings/environment. Actually I ran out of any other ideas… Don’t know why only TSS 5.7 works fine. Also, did you have a chance to increase Connection timeout settings? (Tools\Options\Database\SQL Server\Timeouts) ---
**Author:** ![vane](https://avatars.discourse-cdn.com/v4/letter/v/f1d935/32.png) [@vane](https://forums.toadworld.com/u/vane)\ **Post date:** [March 5, 2013, 8:57pm UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/14 "2013-03-05T20:57:24Z")
Yes, but it still doesn’t help. I also think the problem is on my PC. Nevertheless, I’m not planning to re-install OS at present. I’ll post the follow-up to this issue after re-installing OS in the future. ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [March 6, 2013, 3:25am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/15 "2013-03-06T03:25:47Z")
Ok I see. Good luck! ---
**Author:** ![fernando.olmos2013](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/fernando.olmos2013/32/188_2.png) [@fernando.olmos2013](https://forums.toadworld.com/u/fernando.olmos2013)\ **Post date:** [March 17, 2013, 10:21pm UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/16 "2013-03-17T22:21:54Z")
Risking being flamed here, but have you checked the obvious? The actual timeout settings in TOAD, under TOOLS-\>Options-\>Database-\>Timeouts ---
**Author:** ![vane](https://avatars.discourse-cdn.com/v4/letter/v/f1d935/32.png) [@vane](https://forums.toadworld.com/u/vane)\ **Post date:** [March 18, 2013, 8:24pm UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/17 "2013-03-18T20:24:41Z")
As stated previously, I have checked the settings of Database - Timeouts, but it doesn’t work. ---
**Author:** ![fernando.olmos2013](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/fernando.olmos2013/32/188_2.png) [@fernando.olmos2013](https://forums.toadworld.com/u/fernando.olmos2013)\ **Post date:** [March 18, 2013, 9:33pm UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/18 "2013-03-18T21:33:50Z")
Have you extended the timeouts to hours instead of minutes and see if that makes it? Check the timeouts in SQL Server directly: [http://technet.microsoft.com/en-us/library/ms189631.aspx](http://technet.microsoft.com/en-us/library/ms189631.aspx) ---
**Author:** ![vane](https://avatars.discourse-cdn.com/v4/letter/v/f1d935/32.png) [@vane](https://forums.toadworld.com/u/vane)\ **Post date:** [March 19, 2013, 12:54am UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/19 "2013-03-19T00:54:31Z")
I have also changed the timeouts settings of SQL Server and the result is the same. There must be something wrong with my PC. Luckily ToadSS 5.7 works fine. ---
**Author:** ![vane](https://avatars.discourse-cdn.com/v4/letter/v/f1d935/32.png) [@vane](https://forums.toadworld.com/u/vane)\ **Post date:** [February 26, 2014, 7:30pm UTC](https://forums.toadworld.com/t/connection-timeout-expired-issue/17108/20 "2014-02-26T19:30:03Z")
I think I have found the reason. The differences among versions of Microsoft .NET Framework caused the problem. Toad works fine when Microsoft .NET Framework 4.0 is installed; however, if Microsoft .NET Framework is upgraded, connection issue occurs. ☹