SQL COnnection lost afther 1 minute

Hi,

Before I used the freeware version of toad sql server, I used the trail version. With the trail version I never had any problems with the connection to the DB. But Know I am using the Freeware version, and toad cannot hold the connection very long (about a minute before disconnecting from the SQL server).

I am using a windows sbs 2003 with sql server 2005 and 2008. On the server is Toad installed ( connection or latency should not be a problem?).

I tried to reconfigure toad (time-outs etc), I reinstalled Toad several times and there are no errors in the logging that I can find and deinstalled the trail versions.

Can someone help me please?

Regards

Hi
It’s tough question… Could you please attach support bundle zip here for further investigation?

regards,
Alexander

Hi,

Maybe a stupid question but where can i find the support bundle or how can I cretae one?

Regards

Martijn

image004.png

image001.gif

image002.jpeg

image003.png

Unfortunatelly text portion from Hank’s message was lost during sync from yahoo group…
Here is his original message to you:

RE: [toadss] Re: SQL COnnection lost afther 1 minute

· The support bundle can be generated under the Help menu.

o In the Help about click on the Application Data Directory for that is where the support bundle and other important files live.

o Mine is in C:\Users*Hank_Freeman*\AppData\Roaming\Quest Software\Toad for SQL Server 5.0, where Hank_Freeman is my Userid.

See Graphics below.

http://tech.groups.yahoo.com/group/toadss/message/4581

Thanks for the repley

Oke when I generated the support bundle I got the following error: see attachment

And here is the support bundle:
some Variables I had to replace with #####


Support Bundle for Toad for SQL Server Freeware 5.0
14-10-2010 9:19:03



System Information


Operating System
Microsoft® Windows® Server 2003 for Small Business Server 5.2.3790 x86
Manufacturer: Microsoft Corporation
Computer Name: ONTWIKKELSERVER
Windows Directory: C:\WINDOWS

Computer System
Computer Manufacturer Name: Dell Inc.
Computer Model: OptiPlex 745
System Type: X86-based PC
Total Physical Memory: 2,086,404 KB
Domain: ########.local
User Name:

System Processor
Manufacturer: GenuineIntel
Computer Processor: x86 Family 6 Model 15 Stepping 2
CPU Speed: 1,794 GHz
L2 Cache Size: 2 KB
Manufacturer: GenuineIntel
Computer Processor: x86 Family 6 Model 15 Stepping 2
CPU Speed: 1,794 GHz
L2 Cache Size: 2 KB

System Bios
BIOS: Phoenix ROM BIOS PLUS Version 1.10 2.3.1
BIOS Version: DELL - 14

System Time Zone
Time Zone: (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna

Logical Memory Configuration
Total Page File Space: 1,944,276 KB
Total Virtual Memory: 4,030,680 KB
Total Physical Memory: 2,086,404 KB

Video Controller
Name: Intel® Q965/Q963 Express Chipset Family
Processor: Intel® GMA 3000
Mode: 1024 x 768 x 4294967296 colors
Video Ram: 393,216 KB
PNP Device ID: PCI\VEN_8086&DEV_2992&SUBSYS_01DA1028&REV_02\3&172E68DD&0&10
Status: OK
Name: Intel® Q965/Q963 Express Chipset Family
Processor: Intel® GMA 3000
Mode:
Video Ram: 393,216 KB
PNP Device ID: PCI\VEN_8086&DEV_2993&SUBSYS_01DA1028&REV_02\3&172E68DD&0&11
Status: OK

Environment Variables
Path = C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn;C:\Program Files\Microsoft Windows Small Business Server\Networking;C:\Program Files\Microsoft SQL Server\90\Tools\binn;C:\Program Files\Microsoft SQL Server\90\DTS\Binn;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE;C:\Program Files\Microsoft SQL Server\100\Tools\Binn;C:\Program Files\Microsoft SQL Server\100\DTS\Binn
TEMP = C:\DOCUME~1########\LOCALS~1\Temp\1
SESSIONNAME = RDP-Tcp#1
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.PSC1
USERDOMAIN = ############
PROCESSOR_ARCHITECTURE = x86
SystemDrive = C:
VS100COMNTOOLS = C:\Program Files\Microsoft Visual Studio 10.0\Common7\Tools
APPDATA = C:\Documents and Settings##########\Application Data
windir = C:\WINDOWS
winsbprogramdir = C:\Program Files\Windows for Small Business Server
EXCHICONS = E:\Program Files\Exchsrvr\bin\maildsmx.dll
TMP = C:\DOCUME~1#########1\LOCALS~1\Temp\1
SBSProgramDir = C:\Program Files\Microsoft Windows Small Business Server
USERPROFILE = C:\Documents and Settings##########
ProgramFiles = C:\Program Files
FP_NO_HOST_CHECK = NO
HOMEPATH = \Documents and Settings###########
COMPUTERNAME = ONTWIKKELSERVER
USERNAME = mdiederen
NUMBER_OF_PROCESSORS = 2
PROCESSOR_IDENTIFIER = x86 Family 6 Model 15 Stepping 2, GenuineIntel
ClusterLog = C:\WINDOWS\Cluster\cluster.log
SystemRoot = C:\WINDOWS
ComSpec = C:\WINDOWS\system32\cmd.exe
LOGONSERVER = \ONTWIKKELSERVER
CommonProgramFiles = C:\Program Files\Common Files
PROCESSOR_LEVEL = 6
PROCESSOR_REVISION = 0f02
CLIENTNAME = ONTWIKKELSRV
lib = C:\Program Files\SQLXML 4.0\bin
ALLUSERSPROFILE = C:\Documents and Settings\All Users
VS90COMNTOOLS = C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools
OS = Windows_NT
USERDNSDOMAIN = ###########.LOCAL
HOMEDRIVE = C:


Connection Information


Current Connection:
ontwikkelserver (#################), ########
Category: Development
SQL Server database
Server version 9.0.4053.0
Connected since 14-10-2010 9:18:51
0 of 1 connection in pool active
SPID 51: unused


SQL Server Registry Information - 2005 Debugging Configuration


HKEY_CLASSES_ROOT\CLSID{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}
= PSFactoryBuffer
HKEY_CLASSES_ROOT\CLSID{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}\InprocServer32
= C:\Program Files\Common Files\Microsoft Shared\SQL Debugging\ssdebugps.dll
ThreadingModel= Both
( FileVersion:2007.0100.1600.022 ((SQL_PreRelease).080709-1414 ) InternalName:SSDEBUGPS CompanyName:Microsoft Corporation )

HKEY_CLASSES_ROOT\Interface{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}
= IHostDebugDebuggerInstance
HKEY_CLASSES_ROOT\Interface{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods
= 4
HKEY_CLASSES_ROOT\Interface{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32
= {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}

HKEY_CLASSES_ROOT\Interface{87BC18DC-C8B3-11D5-AE96-00B0D0E93CC1}
= IHostDebugServerInstance
HKEY_CLASSES_ROOT\Interface{87BC18DC-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods
= 5
HKEY_CLASSES_ROOT\Interface{87BC18DC-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32
= {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}

HKEY_CLASSES_ROOT\Interface{87BC18DD-C8B3-11D5-AE96-00B0D0E93CC1}
= IHostDebugEvent
HKEY_CLASSES_ROOT\Interface{87BC18DD-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods
= 18
HKEY_CLASSES_ROOT\Interface{87BC18DD-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32
= {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}

HKEY_CLASSES_ROOT\Interface{87BC18DE-C8B3-11D5-AE96-00B0D0E93CC1}
= IHostDebug
HKEY_CLASSES_ROOT\Interface{87BC18DE-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods
= 16
HKEY_CLASSES_ROOT\Interface{87BC18DE-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32
= {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}

HKEY_CLASSES_ROOT\Interface{87BC18DF-C8B3-11D5-AE96-00B0D0E93CC1}
= IHostDebugBinary
HKEY_CLASSES_ROOT\Interface{87BC18DF-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods
= 6
HKEY_CLASSES_ROOT\Interface{87BC18DF-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32
= {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}

HKEY_CLASSES_ROOT\Interface{87BC18E0-C8B3-11D5-AE96-00B0D0E93CC1}
= IEnumHostDebugSymbol
HKEY_CLASSES_ROOT\Interface{87BC18E0-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods
= 8
HKEY_CLASSES_ROOT\Interface{87BC18E0-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32
= {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}


@@Version


9.0.4053.0


Loaded Assemblies


Accessibility, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_MSIL\Accessibility\2.0.0.0__b03f5f7f11d50a3a\Accessibility.dll
ActiproSoftware.Shared.Net20, Version=1.0.103.0, Culture=neutral, PublicKeyToken=36ff2196ab5654b9 C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.Shared.Net20\1.0.103.0__36ff2196ab5654b9\ActiproSoftware.Shared.Net20.dll
ActiproSoftware.SyntaxEditor.Net20, Version=4.0.284.0, Culture=neutral, PublicKeyToken=21a821480e210563 C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.Net20\4.0.284.0__21a821480e210563\ActiproSoftware.SyntaxEditor.Net20.dll
ActiproSoftware.UIStudio.Dock.Net20, Version=2.0.109.0, Culture=neutral, PublicKeyToken=be939c973e8cb8a6 C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.UIStudio.Dock.Net20\2.0.109.0__be939c973e8cb8a6\ActiproSoftware.UIStudio.Dock.Net20.dll
ActiproSoftware.WinUICore.Net20, Version=1.0.103.0, Culture=neutral, PublicKeyToken=1eba893a2bc55de5 C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.WinUICore.Net20\1.0.103.0__1eba893a2bc55de5\ActiproSoftware.WinUICore.Net20.dll
DevExpress.BonusSkins.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\WINDOWS\assembly\GAC_MSIL\DevExpress.BonusSkins.v9.3\9.3.3.0__95fc6c5621878f0a\DevExpress.BonusSkins.v9.3.dll
DevExpress.Data.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\assembly\GAC_MSIL\DevExpress.Data.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.Data.v9.3.dll
DevExpress.OfficeSkins.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\WINDOWS\assembly\GAC_MSIL\DevExpress.OfficeSkins.v9.3\9.3.3.0__95fc6c5621878f0a\DevExpress.OfficeSkins.v9.3.dll
DevExpress.Utils.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\assembly\GAC_MSIL\DevExpress.Utils.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.Utils.v9.3.dll
DevExpress.XtraBars.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\assembly\GAC_MSIL\DevExpress.XtraBars.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraBars.v9.3.dll
DevExpress.XtraEditors.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\assembly\GAC_MSIL\DevExpress.XtraEditors.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraEditors.v9.3.dll
DevExpress.XtraGrid.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\assembly\GAC_MSIL\DevExpress.XtraGrid.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraGrid.v9.3.dll
DevExpress.XtraTreeList.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\assembly\GAC_MSIL\DevExpress.XtraTreeList.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraTreeList.v9.3.dll
DevExpress.XtraVerticalGrid.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\assembly\GAC_MSIL\DevExpress.XtraVerticalGrid.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraVerticalGrid.v9.3.dll
FastData, Version=3.0.0.444, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\FastData.dll
FlexCel, Version=5.1.0.0, Culture=neutral, PublicKeyToken=cb8f6080e6d5a4d6 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\FlexCel.dll
ICSharpCode.SharpZipLib, Version=0.85.5.452, Culture=neutral, PublicKeyToken=1b03e6acf1164f73 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\ICSharpCode.SharpZipLib.dll
ManagedQP5, Version=5.2.5.444, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\managedqp5.dll
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll
msvcm90, Version=9.0.30729.4974, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\WinSxS\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.4974_x-ww_D889290F\msvcm90.dll
Quest.Compare.General.Sys, Version=4.6.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\Plugins\SqlServer\Quest.Compare.General.Sys.dll
Quest.Compare.General.SysInterfaces, Version=4.6.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\Plugins\SqlServer\Quest.Compare.General.SysInterfaces.dll
Quest.PersistentCache, Version=3.0.0.444, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\Quest.PersistentCache.dll
Quest.Toad.Interop.AxSHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\Quest.Toad.Interop.AxSHDocVw.dll
Quest.VersionControl, Version=1.1.0.444, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\Quest.VersionControl.dll
QuestElevation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\QuestElevation.exe
SHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\SHDocVw.dll
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll
System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll
System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\assembly\GAC_MSIL\System.Core\3.5.0.0__b77a5c561934e089\System.Core.dll
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll
System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_MSIL\System.Design\2.0.0.0__b03f5f7f11d50a3a\System.Design.dll
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll
System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll
System.Management, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_MSIL\System.Management\2.0.0.0__b03f5f7f11d50a3a\System.Management.dll
System.Runtime.Serialization.Formatters.Soap, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll
System.ServiceProcess, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_MSIL\System.ServiceProcess\2.0.0.0__b03f5f7f11d50a3a\System.ServiceProcess.dll
System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e089\System.Windows.Forms.dll
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll
System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\assembly\GAC_MSIL\System.Xml.Linq\3.5.0.0__b77a5c561934e089\System.Xml.Linq.dll
Toad, Version=5.0.0.444, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\Toad.exe
ToadCore, Version=5.0.0.444, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\ToadCore.dll
ToadPlugin, Version=5.0.0.444, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\ToadPlugin.dll
ToadSqlServer, Version=5.0.0.444, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\Plugins\SqlServer\ToadSqlServer.dll
ToadSqlServerProvider, Version=5.0.0.444, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\Plugins\SqlServer\ToadSqlServerProvider.dll
QP5, Version=5.160.1006.24008, C:\Program Files\Quest Software\Toad for SQL Server Freeware 5.0\qp5.dll


Licensing


Freeware
Error.png

Hi,
I’m trying to reproduce your issue on my environment but without success. Just to be sure:

  1. Toad and SQL Server instance are on the same host?
  2. You don’t have such issues on TSS trial version on the same environment, right?

Hi Alexander,

Thanks for taking the time.

Yes the sql server (2005 and 2008) are installed on the same server where I use Toad.

The Trail version worked perfectly, without any problems.

Last few days I deinstalled toad again, removed all garbage folders (prefrences etc)(that where left behind), restarted the server en installed toad again. --> still not oke

I played with the accounts (acces with windows account and or sql accounts) --> still not oke.

When I use the MS server management studio on that same server I have no problems.

I installed Toad on a other server and I connected to the sql servers above and It worked without any problems.

The strange thing is that I still can not find a error why Toad is disconnecting.

Regards

Ok. I still can’t reproduce it in-house. I’ve installed 5.0 Freeware on XP sp3 32bit, W2k3 sp2 64bit and Toad works fine with local and remote SQL Instances. I have no idea what can cause the issue =(

Regarding finding exact error toad produces on this issue, you can try to see this file:
“C:\Documents and Settings[username]\Application Data\Quest Software\Toad for SQL Server Freeware 5.0\ExceptionTrace.log”