Installting SQL Server 2k5

I have SQL Server 2000 on Windows XP professional OS.
I want to install SQLServer 2K5?
Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
What steps should be taken before and after SQL Server 2K5 installation?
Thanks,Hi,
You should be able to install SQL Server 2005 and SQL Server 2000 side
by side.
I think you may need SP2 of XP Pro.
One important thing to watch out for is any old components left behind
by past builds of SQL Server 2005 or Visual Studio 2005. If they are
present you need to uninstall CAREFULLY and in the right order or you
can expect to hit problems.
Andrew Watt
MVP - InfoPath
On Wed, 12 Oct 2005 12:01:02 -0700, "UA" <usha.anumolu@.eds.com> wrote:

>I have SQL Server 2000 on Windows XP professional OS.
>I want to install SQLServer 2K5?
>Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
>What steps should be taken before and after SQL Server 2K5 installation?
>
>Thanks,

Installting SQL Server 2k5

I have SQL Server 2000 on Windows XP professional OS.
I want to install SQLServer 2K5?
Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
What steps should be taken before and after SQL Server 2K5 installation?
Thanks,
Hi,
You should be able to install SQL Server 2005 and SQL Server 2000 side
by side.
I think you may need SP2 of XP Pro.
One important thing to watch out for is any old components left behind
by past builds of SQL Server 2005 or Visual Studio 2005. If they are
present you need to uninstall CAREFULLY and in the right order or you
can expect to hit problems.
Andrew Watt
MVP - InfoPath
On Wed, 12 Oct 2005 12:01:02 -0700, "UA" <usha.anumolu@.eds.com> wrote:

>I have SQL Server 2000 on Windows XP professional OS.
>I want to install SQLServer 2K5?
>Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
>What steps should be taken before and after SQL Server 2K5 installation?
>
>Thanks,

Installting SQL Server 2k5

I have SQL Server 2000 on Windows XP professional OS.
I want to install SQLServer 2K5?
Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
What steps should be taken before and after SQL Server 2K5 installation?
Thanks,Hi,
You should be able to install SQL Server 2005 and SQL Server 2000 side
by side.
I think you may need SP2 of XP Pro.
One important thing to watch out for is any old components left behind
by past builds of SQL Server 2005 or Visual Studio 2005. If they are
present you need to uninstall CAREFULLY and in the right order or you
can expect to hit problems.
Andrew Watt
MVP - InfoPath
On Wed, 12 Oct 2005 12:01:02 -0700, "UA" <usha.anumolu@.eds.com> wrote:
>I have SQL Server 2000 on Windows XP professional OS.
>I want to install SQLServer 2K5?
>Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
>What steps should be taken before and after SQL Server 2K5 installation?
>
>Thanks,

Installing SSRS 2005 on Windows XP Pro

Hi All,

I want to run SSRS 2K5 on a windows XP pro workstation. Is this possible as I have tried several times but no luck. Cannot connect to the website http://servername/reports from internet explorer 7.

Has anyone ever successfully done this?

Gappo

Make sure you have IIS and Sql Server Agent running and actually insert your server name into the address (eg http://localhost/reports).

Good luck...

Installing SSIS on 2k5 SP2 Instance?

I'm working on an SQL 2k5 / SP2 server and need to install SSIS.

Can this be done without uninstalling SQL?

Thanks.

I don't understand the question. SSIS is bundled with SQL Server 2005. So, yes, you can install it. Just select it from the installation media.

Installing SS2K5 error with Visual Studio 2K5

Hello,
I installed SS2K5 Developer edition and everything worked fine. Then I
installed Visual Studio 2K5. When I open SS2K5, I get the following error:
Unhandled exception has occurred in a component in your application. If you
click Continue, the application will ignore this error and attempt to
continue.
Input string was not in a correct format.
After I click Continue, the database opens...
--
Thanks in advance,
sck10
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options,
NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style,
NumberFormatInfo info)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs
e)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs
e)
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase:
file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
---
AppIDPackage
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
---
Microsoft.SqlServer.SqlTools.VSIntegration
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
---
Microsoft.VisualStudio.Shell.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase:
file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
---
Microsoft.VisualStudio.OLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase:
file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
---
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
---
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
---
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
---
Microsoft.SqlServer.SqlTDiagM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
---
Microsoft.DataWarehouse.SQM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
---
Microsoft.SqlServer.Instapi
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
---
ObjectExplorer
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
---
ConnectionDlg
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
---
Microsoft.SqlServer.RegSvrEnum
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
---
Microsoft.SqlServer.CustomControls
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
---
SqlWorkbench.Interfaces
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
---
Microsoft.VisualStudio.TextManager.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase:
file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
---
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
---
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase:
file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
---
EnvDTE
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase:
file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
---
Microsoft.NetEnterpriseServers.ExceptionMessageBox
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
---
SqlMgmt
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
---
Microsoft.SqlServer.ConnectionInfo
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase:
file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
---
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.Hi
This error message most often occurs because of a date format issue. You may
want to check the regional settings.
I assume that when you means open SQL Server 2005 you are talking about SQL
Server Management Studio? Do other tools also display this message, can you
use SQL Profiler to see if it is within a SQL Command or if it is part of the
application. You may want to try loading Service Pack1 to re-install client
tools.
John
"sck10" wrote:
> Hello,
> I installed SS2K5 Developer edition and everything worked fine. Then I
> installed Visual Studio 2K5. When I open SS2K5, I get the following error:
> Unhandled exception has occurred in a component in your application. If you
> click Continue, the application will ignore this error and attempt to
> continue.
> Input string was not in a correct format.
> After I click Continue, the database opens...
> --
> Thanks in advance,
> sck10
>
>
> See the end of this message for details on invoking
> just-in-time (JIT) debugging instead of this dialog box.
> ************** Exception Text **************
> System.FormatException: Input string was not in a correct format.
> at System.Number.StringToNumber(String str, NumberStyles options,
> NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
> at System.Number.ParseInt32(String s, NumberStyles style,
> NumberFormatInfo info)
> at
> Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()
> at
> Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()
> at
> Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs
> e)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs
> e)
> at System.Windows.Forms.Control.WmShowWindow(Message& m)
> at System.Windows.Forms.Control.WndProc(Message& m)
> at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
> at System.Windows.Forms.ContainerControl.WndProc(Message& m)
> at System.Windows.Forms.Form.WmShowWindow(Message& m)
> at System.Windows.Forms.Form.WndProc(Message& m)
> at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
>
> ************** Loaded Assemblies **************
> mscorlib
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> CodeBase:
> file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> ---
> AppIDPackage
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
> ---
> Microsoft.SqlServer.SqlTools.VSIntegration
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
> ---
> Microsoft.VisualStudio.Shell.Interop
> Assembly Version: 7.1.40304.0
> Win32 Version: 7.0.4054
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
> ---
> Microsoft.VisualStudio.OLE.Interop
> Assembly Version: 7.1.40304.0
> Win32 Version: 7.0.4054
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
> ---
> System
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
> ---
> System.Windows.Forms
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> ---
> System.Drawing
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> ---
> Microsoft.SqlServer.SqlTDiagM
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
> ---
> Microsoft.DataWarehouse.SQM
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
> ---
> Microsoft.SqlServer.Instapi
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
> ---
> ObjectExplorer
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
> ---
> ConnectionDlg
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
> ---
> Microsoft.SqlServer.RegSvrEnum
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
> ---
> Microsoft.SqlServer.CustomControls
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
> ---
> SqlWorkbench.Interfaces
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
> ---
> Microsoft.VisualStudio.TextManager.Interop
> Assembly Version: 7.1.40304.0
> Win32 Version: 7.0.4054
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
> ---
> Accessibility
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
> ---
> System.Data
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
> ---
> EnvDTE
> Assembly Version: 8.0.0.0
> Win32 Version: 8.0.50727.42 (RTM.050727-4200)
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
> ---
> Microsoft.NetEnterpriseServers.ExceptionMessageBox
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
> ---
> SqlMgmt
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
> ---
> Microsoft.SqlServer.ConnectionInfo
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.1399.00
> CodeBase:
> file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
> ---
> ************** JIT Debugging **************
> To enable just-in-time (JIT) debugging, the .config file for this
> application or computer (machine.config) must have the
> jitDebugging value set in the system.windows.forms section.
> The application must also be compiled with debugging
> enabled.
> For example:
> <configuration>
> <system.windows.forms jitDebugging="true" />
> </configuration>
> When JIT debugging is enabled, any unhandled exception
> will be sent to the JIT debugger registered on the computer
> rather than be handled by this dialog box.
>
>|||John,
Would you please elaborate on the Date Format issue. That is the only thing
left for me to try before I start over. I have tried to reinstall SP1,
Removed Framework version 2.0, remove most of the excess service from SQL
2005 to no avail.
I have a Windows XP SP2 with multiple MUI installed. Office 2003, Visual
Studio 2005, SQL 20005. I upgraded from SQL 2000 SP3a. Any other ideas that
will get rid of this enoying pop-up? You know how it gets, it is like a
mosquito in my left ear that will not let me fall asleep.
Thanks,
JS
"John Bell" wrote:
> Hi
> This error message most often occurs because of a date format issue. You may
> want to check the regional settings.
> I assume that when you means open SQL Server 2005 you are talking about SQL
> Server Management Studio? Do other tools also display this message, can you
> use SQL Profiler to see if it is within a SQL Command or if it is part of the
> application. You may want to try loading Service Pack1 to re-install client
> tools.
> John
> "sck10" wrote:
> > Hello,
> >
> > I installed SS2K5 Developer edition and everything worked fine. Then I
> > installed Visual Studio 2K5. When I open SS2K5, I get the following error:
> >
> > Unhandled exception has occurred in a component in your application. If you
> > click Continue, the application will ignore this error and attempt to
> > continue.
> >
> > Input string was not in a correct format.
> >
> > After I click Continue, the database opens...
> > --
> > Thanks in advance,
> >
> > sck10
> >
> >
> >
> >
> > See the end of this message for details on invoking
> > just-in-time (JIT) debugging instead of this dialog box.
> >
> > ************** Exception Text **************
> > System.FormatException: Input string was not in a correct format.
> > at System.Number.StringToNumber(String str, NumberStyles options,
> > NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
> > at System.Number.ParseInt32(String s, NumberStyles style,
> > NumberFormatInfo info)
> > at
> > Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()
> > at
> > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()
> > at
> > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs
> > e)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs
> > e)
> > at System.Windows.Forms.Control.WmShowWindow(Message& m)
> > at System.Windows.Forms.Control.WndProc(Message& m)
> > at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
> > at System.Windows.Forms.ContainerControl.WndProc(Message& m)
> > at System.Windows.Forms.Form.WmShowWindow(Message& m)
> > at System.Windows.Forms.Form.WndProc(Message& m)
> > at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
> > at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> > at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> > IntPtr wparam, IntPtr lparam)
> >
> >
> > ************** Loaded Assemblies **************
> > mscorlib
> > Assembly Version: 2.0.0.0
> > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > CodeBase:
> > file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> > ---
> > AppIDPackage
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
> > ---
> > Microsoft.SqlServer.SqlTools.VSIntegration
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
> > ---
> > Microsoft.VisualStudio.Shell.Interop
> > Assembly Version: 7.1.40304.0
> > Win32 Version: 7.0.4054
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
> > ---
> > Microsoft.VisualStudio.OLE.Interop
> > Assembly Version: 7.1.40304.0
> > Win32 Version: 7.0.4054
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
> > ---
> > System
> > Assembly Version: 2.0.0.0
> > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
> > ---
> > System.Windows.Forms
> > Assembly Version: 2.0.0.0
> > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> > ---
> > System.Drawing
> > Assembly Version: 2.0.0.0
> > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> > ---
> > Microsoft.SqlServer.SqlTDiagM
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
> > ---
> > Microsoft.DataWarehouse.SQM
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
> > ---
> > Microsoft.SqlServer.Instapi
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
> > ---
> > ObjectExplorer
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
> > ---
> > ConnectionDlg
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
> > ---
> > Microsoft.SqlServer.RegSvrEnum
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
> > ---
> > Microsoft.SqlServer.CustomControls
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
> > ---
> > SqlWorkbench.Interfaces
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
> > ---
> > Microsoft.VisualStudio.TextManager.Interop
> > Assembly Version: 7.1.40304.0
> > Win32 Version: 7.0.4054
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
> > ---
> > Accessibility
> > Assembly Version: 2.0.0.0
> > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
> > ---
> > System.Data
> > Assembly Version: 2.0.0.0
> > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
> > ---
> > EnvDTE
> > Assembly Version: 8.0.0.0
> > Win32 Version: 8.0.50727.42 (RTM.050727-4200)
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
> > ---
> > Microsoft.NetEnterpriseServers.ExceptionMessageBox
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
> > ---
> > SqlMgmt
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
> > ---
> > Microsoft.SqlServer.ConnectionInfo
> > Assembly Version: 9.0.242.0
> > Win32 Version: 9.00.1399.00
> > CodeBase:
> > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
> > ---
> >
> > ************** JIT Debugging **************
> > To enable just-in-time (JIT) debugging, the .config file for this
> > application or computer (machine.config) must have the
> > jitDebugging value set in the system.windows.forms section.
> > The application must also be compiled with debugging
> > enabled.
> >
> > For example:
> >
> > <configuration>
> > <system.windows.forms jitDebugging="true" />
> > </configuration>
> >
> > When JIT debugging is enabled, any unhandled exception
> > will be sent to the JIT debugger registered on the computer
> > rather than be handled by this dialog box.
> >
> >
> >|||Hi Johnny
The error message is most often (but not always) associated with problems
when the a date is not in the correct format, although re-looking at the
debug this may actually be a numeric conversion.
The suggestion to use SQL Profiler may have turned up something that would
have helped.
Have you tried rebuilding the registry?
John
"Johnny Sandaire" wrote:
> John,
> Would you please elaborate on the Date Format issue. That is the only thing
> left for me to try before I start over. I have tried to reinstall SP1,
> Removed Framework version 2.0, remove most of the excess service from SQL
> 2005 to no avail.
> I have a Windows XP SP2 with multiple MUI installed. Office 2003, Visual
> Studio 2005, SQL 20005. I upgraded from SQL 2000 SP3a. Any other ideas that
> will get rid of this enoying pop-up? You know how it gets, it is like a
> mosquito in my left ear that will not let me fall asleep.
> Thanks,
> JS
> "John Bell" wrote:
> > Hi
> >
> > This error message most often occurs because of a date format issue. You may
> > want to check the regional settings.
> >
> > I assume that when you means open SQL Server 2005 you are talking about SQL
> > Server Management Studio? Do other tools also display this message, can you
> > use SQL Profiler to see if it is within a SQL Command or if it is part of the
> > application. You may want to try loading Service Pack1 to re-install client
> > tools.
> >
> > John
> >
> > "sck10" wrote:
> >
> > > Hello,
> > >
> > > I installed SS2K5 Developer edition and everything worked fine. Then I
> > > installed Visual Studio 2K5. When I open SS2K5, I get the following error:
> > >
> > > Unhandled exception has occurred in a component in your application. If you
> > > click Continue, the application will ignore this error and attempt to
> > > continue.
> > >
> > > Input string was not in a correct format.
> > >
> > > After I click Continue, the database opens...
> > > --
> > > Thanks in advance,
> > >
> > > sck10
> > >
> > >
> > >
> > >
> > > See the end of this message for details on invoking
> > > just-in-time (JIT) debugging instead of this dialog box.
> > >
> > > ************** Exception Text **************
> > > System.FormatException: Input string was not in a correct format.
> > > at System.Number.StringToNumber(String str, NumberStyles options,
> > > NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
> > > at System.Number.ParseInt32(String s, NumberStyles style,
> > > NumberFormatInfo info)
> > > at
> > > Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()
> > > at
> > > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()
> > > at
> > > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs
> > > e)
> > > at
> > > Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs
> > > e)
> > > at System.Windows.Forms.Control.WmShowWindow(Message& m)
> > > at System.Windows.Forms.Control.WndProc(Message& m)
> > > at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
> > > at System.Windows.Forms.ContainerControl.WndProc(Message& m)
> > > at System.Windows.Forms.Form.WmShowWindow(Message& m)
> > > at System.Windows.Forms.Form.WndProc(Message& m)
> > > at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
> > > at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> > > at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> > > IntPtr wparam, IntPtr lparam)
> > >
> > >
> > > ************** Loaded Assemblies **************
> > > mscorlib
> > > Assembly Version: 2.0.0.0
> > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > CodeBase:
> > > file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> > > ---
> > > AppIDPackage
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
> > > ---
> > > Microsoft.SqlServer.SqlTools.VSIntegration
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
> > > ---
> > > Microsoft.VisualStudio.Shell.Interop
> > > Assembly Version: 7.1.40304.0
> > > Win32 Version: 7.0.4054
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
> > > ---
> > > Microsoft.VisualStudio.OLE.Interop
> > > Assembly Version: 7.1.40304.0
> > > Win32 Version: 7.0.4054
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
> > > ---
> > > System
> > > Assembly Version: 2.0.0.0
> > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
> > > ---
> > > System.Windows.Forms
> > > Assembly Version: 2.0.0.0
> > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> > > ---
> > > System.Drawing
> > > Assembly Version: 2.0.0.0
> > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> > > ---
> > > Microsoft.SqlServer.SqlTDiagM
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
> > > ---
> > > Microsoft.DataWarehouse.SQM
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
> > > ---
> > > Microsoft.SqlServer.Instapi
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
> > > ---
> > > ObjectExplorer
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
> > > ---
> > > ConnectionDlg
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
> > > ---
> > > Microsoft.SqlServer.RegSvrEnum
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
> > > ---
> > > Microsoft.SqlServer.CustomControls
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
> > > ---
> > > SqlWorkbench.Interfaces
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
> > > ---
> > > Microsoft.VisualStudio.TextManager.Interop
> > > Assembly Version: 7.1.40304.0
> > > Win32 Version: 7.0.4054
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
> > > ---
> > > Accessibility
> > > Assembly Version: 2.0.0.0
> > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
> > > ---
> > > System.Data
> > > Assembly Version: 2.0.0.0
> > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
> > > ---
> > > EnvDTE
> > > Assembly Version: 8.0.0.0
> > > Win32 Version: 8.0.50727.42 (RTM.050727-4200)
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
> > > ---
> > > Microsoft.NetEnterpriseServers.ExceptionMessageBox
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
> > > ---
> > > SqlMgmt
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
> > > ---
> > > Microsoft.SqlServer.ConnectionInfo
> > > Assembly Version: 9.0.242.0
> > > Win32 Version: 9.00.1399.00
> > > CodeBase:
> > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
> > > ---
> > >
> > > ************** JIT Debugging **************
> > > To enable just-in-time (JIT) debugging, the .config file for this
> > > application or computer (machine.config) must have the
> > > jitDebugging value set in the system.windows.forms section.
> > > The application must also be compiled with debugging
> > > enabled.
> > >
> > > For example:
> > >
> > > <configuration>
> > > <system.windows.forms jitDebugging="true" />
> > > </configuration>
> > >
> > > When JIT debugging is enabled, any unhandled exception
> > > will be sent to the JIT debugger registered on the computer
> > > rather than be handled by this dialog box.
> > >
> > >
> > >|||John,
I am willing to try to run SQL Profiler and rebuilding the Registry if that
will get me out of that error. This is what I have tried so far that have
failed:
1. Re-install SP1 for SQL 2001.
2. Un-install Framework 2.0.
3. Uninstall extra Service that were not needed that was installed as part
of the SQL 2005 installation.
It looks like a SQL error, however, it happens when the Management Studio is
starting. If we knew what was being read (System Stored Procedures, etc...)
that may be also a good place to start looking.
Can you elaborate on how to rebuild the registry?
Can you also tell me what to start in SQL Profiler? I launched it and
select to start a new trace and the same error generated.
Tks,
JS
"John Bell" wrote:
> Hi Johnny
> The error message is most often (but not always) associated with problems
> when the a date is not in the correct format, although re-looking at the
> debug this may actually be a numeric conversion.
> The suggestion to use SQL Profiler may have turned up something that would
> have helped.
> Have you tried rebuilding the registry?
> John
> "Johnny Sandaire" wrote:
> > John,
> >
> > Would you please elaborate on the Date Format issue. That is the only thing
> > left for me to try before I start over. I have tried to reinstall SP1,
> > Removed Framework version 2.0, remove most of the excess service from SQL
> > 2005 to no avail.
> >
> > I have a Windows XP SP2 with multiple MUI installed. Office 2003, Visual
> > Studio 2005, SQL 20005. I upgraded from SQL 2000 SP3a. Any other ideas that
> > will get rid of this enoying pop-up? You know how it gets, it is like a
> > mosquito in my left ear that will not let me fall asleep.
> >
> > Thanks,
> >
> > JS
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > This error message most often occurs because of a date format issue. You may
> > > want to check the regional settings.
> > >
> > > I assume that when you means open SQL Server 2005 you are talking about SQL
> > > Server Management Studio? Do other tools also display this message, can you
> > > use SQL Profiler to see if it is within a SQL Command or if it is part of the
> > > application. You may want to try loading Service Pack1 to re-install client
> > > tools.
> > >
> > > John
> > >
> > > "sck10" wrote:
> > >
> > > > Hello,
> > > >
> > > > I installed SS2K5 Developer edition and everything worked fine. Then I
> > > > installed Visual Studio 2K5. When I open SS2K5, I get the following error:
> > > >
> > > > Unhandled exception has occurred in a component in your application. If you
> > > > click Continue, the application will ignore this error and attempt to
> > > > continue.
> > > >
> > > > Input string was not in a correct format.
> > > >
> > > > After I click Continue, the database opens...
> > > > --
> > > > Thanks in advance,
> > > >
> > > > sck10
> > > >
> > > >
> > > >
> > > >
> > > > See the end of this message for details on invoking
> > > > just-in-time (JIT) debugging instead of this dialog box.
> > > >
> > > > ************** Exception Text **************
> > > > System.FormatException: Input string was not in a correct format.
> > > > at System.Number.StringToNumber(String str, NumberStyles options,
> > > > NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
> > > > at System.Number.ParseInt32(String s, NumberStyles style,
> > > > NumberFormatInfo info)
> > > > at
> > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()
> > > > at
> > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()
> > > > at
> > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs
> > > > e)
> > > > at
> > > > Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs
> > > > e)
> > > > at System.Windows.Forms.Control.WmShowWindow(Message& m)
> > > > at System.Windows.Forms.Control.WndProc(Message& m)
> > > > at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
> > > > at System.Windows.Forms.ContainerControl.WndProc(Message& m)
> > > > at System.Windows.Forms.Form.WmShowWindow(Message& m)
> > > > at System.Windows.Forms.Form.WndProc(Message& m)
> > > > at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
> > > > at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> > > > at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> > > > IntPtr wparam, IntPtr lparam)
> > > >
> > > >
> > > > ************** Loaded Assemblies **************
> > > > mscorlib
> > > > Assembly Version: 2.0.0.0
> > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > CodeBase:
> > > > file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> > > > ---
> > > > AppIDPackage
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
> > > > ---
> > > > Microsoft.SqlServer.SqlTools.VSIntegration
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
> > > > ---
> > > > Microsoft.VisualStudio.Shell.Interop
> > > > Assembly Version: 7.1.40304.0
> > > > Win32 Version: 7.0.4054
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
> > > > ---
> > > > Microsoft.VisualStudio.OLE.Interop
> > > > Assembly Version: 7.1.40304.0
> > > > Win32 Version: 7.0.4054
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
> > > > ---
> > > > System
> > > > Assembly Version: 2.0.0.0
> > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
> > > > ---
> > > > System.Windows.Forms
> > > > Assembly Version: 2.0.0.0
> > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> > > > ---
> > > > System.Drawing
> > > > Assembly Version: 2.0.0.0
> > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> > > > ---
> > > > Microsoft.SqlServer.SqlTDiagM
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
> > > > ---
> > > > Microsoft.DataWarehouse.SQM
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
> > > > ---
> > > > Microsoft.SqlServer.Instapi
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
> > > > ---
> > > > ObjectExplorer
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
> > > > ---
> > > > ConnectionDlg
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
> > > > ---
> > > > Microsoft.SqlServer.RegSvrEnum
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
> > > > ---
> > > > Microsoft.SqlServer.CustomControls
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
> > > > ---
> > > > SqlWorkbench.Interfaces
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
> > > > ---
> > > > Microsoft.VisualStudio.TextManager.Interop
> > > > Assembly Version: 7.1.40304.0
> > > > Win32 Version: 7.0.4054
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
> > > > ---
> > > > Accessibility
> > > > Assembly Version: 2.0.0.0
> > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
> > > > ---
> > > > System.Data
> > > > Assembly Version: 2.0.0.0
> > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
> > > > ---
> > > > EnvDTE
> > > > Assembly Version: 8.0.0.0
> > > > Win32 Version: 8.0.50727.42 (RTM.050727-4200)
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
> > > > ---
> > > > Microsoft.NetEnterpriseServers.ExceptionMessageBox
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
> > > > ---
> > > > SqlMgmt
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
> > > > ---
> > > > Microsoft.SqlServer.ConnectionInfo
> > > > Assembly Version: 9.0.242.0
> > > > Win32 Version: 9.00.1399.00
> > > > CodeBase:
> > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
> > > > ---
> > > >
> > > > ************** JIT Debugging **************
> > > > To enable just-in-time (JIT) debugging, the .config file for this
> > > > application or computer (machine.config) must have the
> > > > jitDebugging value set in the system.windows.forms section.
> > > > The application must also be compiled with debugging
> > > > enabled.
> > > >
> > > > For example:
> > > >
> > > > <configuration>
> > > > <system.windows.forms jitDebugging="true" />
> > > > </configuration>
> > > >
> > > > When JIT debugging is enabled, any unhandled exception
> > > > will be sent to the JIT debugger registered on the computer
> > > > rather than be handled by this dialog box.
> > > >
> > > >
> > > >|||Hi Johnny
To rebuild the registry follow the instructions at:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://msdn2.microsoft.com/en-us/library/ms143727.aspx
John
"Johnny Sandaire" wrote:
> John,
> I am willing to try to run SQL Profiler and rebuilding the Registry if that
> will get me out of that error. This is what I have tried so far that have
> failed:
> 1. Re-install SP1 for SQL 2001.
> 2. Un-install Framework 2.0.
> 3. Uninstall extra Service that were not needed that was installed as part
> of the SQL 2005 installation.
> It looks like a SQL error, however, it happens when the Management Studio is
> starting. If we knew what was being read (System Stored Procedures, etc...)
> that may be also a good place to start looking.
> Can you elaborate on how to rebuild the registry?
> Can you also tell me what to start in SQL Profiler? I launched it and
> select to start a new trace and the same error generated.
> Tks,
> JS
>
> "John Bell" wrote:
> > Hi Johnny
> >
> > The error message is most often (but not always) associated with problems
> > when the a date is not in the correct format, although re-looking at the
> > debug this may actually be a numeric conversion.
> >
> > The suggestion to use SQL Profiler may have turned up something that would
> > have helped.
> >
> > Have you tried rebuilding the registry?
> >
> > John
> >
> > "Johnny Sandaire" wrote:
> >
> > > John,
> > >
> > > Would you please elaborate on the Date Format issue. That is the only thing
> > > left for me to try before I start over. I have tried to reinstall SP1,
> > > Removed Framework version 2.0, remove most of the excess service from SQL
> > > 2005 to no avail.
> > >
> > > I have a Windows XP SP2 with multiple MUI installed. Office 2003, Visual
> > > Studio 2005, SQL 20005. I upgraded from SQL 2000 SP3a. Any other ideas that
> > > will get rid of this enoying pop-up? You know how it gets, it is like a
> > > mosquito in my left ear that will not let me fall asleep.
> > >
> > > Thanks,
> > >
> > > JS
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > This error message most often occurs because of a date format issue. You may
> > > > want to check the regional settings.
> > > >
> > > > I assume that when you means open SQL Server 2005 you are talking about SQL
> > > > Server Management Studio? Do other tools also display this message, can you
> > > > use SQL Profiler to see if it is within a SQL Command or if it is part of the
> > > > application. You may want to try loading Service Pack1 to re-install client
> > > > tools.
> > > >
> > > > John
> > > >
> > > > "sck10" wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > I installed SS2K5 Developer edition and everything worked fine. Then I
> > > > > installed Visual Studio 2K5. When I open SS2K5, I get the following error:
> > > > >
> > > > > Unhandled exception has occurred in a component in your application. If you
> > > > > click Continue, the application will ignore this error and attempt to
> > > > > continue.
> > > > >
> > > > > Input string was not in a correct format.
> > > > >
> > > > > After I click Continue, the database opens...
> > > > > --
> > > > > Thanks in advance,
> > > > >
> > > > > sck10
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > See the end of this message for details on invoking
> > > > > just-in-time (JIT) debugging instead of this dialog box.
> > > > >
> > > > > ************** Exception Text **************
> > > > > System.FormatException: Input string was not in a correct format.
> > > > > at System.Number.StringToNumber(String str, NumberStyles options,
> > > > > NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
> > > > > at System.Number.ParseInt32(String s, NumberStyles style,
> > > > > NumberFormatInfo info)
> > > > > at
> > > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()
> > > > > at
> > > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()
> > > > > at
> > > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs
> > > > > e)
> > > > > at
> > > > > Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs
> > > > > e)
> > > > > at System.Windows.Forms.Control.WmShowWindow(Message& m)
> > > > > at System.Windows.Forms.Control.WndProc(Message& m)
> > > > > at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
> > > > > at System.Windows.Forms.ContainerControl.WndProc(Message& m)
> > > > > at System.Windows.Forms.Form.WmShowWindow(Message& m)
> > > > > at System.Windows.Forms.Form.WndProc(Message& m)
> > > > > at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
> > > > > at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> > > > > at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> > > > > IntPtr wparam, IntPtr lparam)
> > > > >
> > > > >
> > > > > ************** Loaded Assemblies **************
> > > > > mscorlib
> > > > > Assembly Version: 2.0.0.0
> > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> > > > > ---
> > > > > AppIDPackage
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
> > > > > ---
> > > > > Microsoft.SqlServer.SqlTools.VSIntegration
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
> > > > > ---
> > > > > Microsoft.VisualStudio.Shell.Interop
> > > > > Assembly Version: 7.1.40304.0
> > > > > Win32 Version: 7.0.4054
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
> > > > > ---
> > > > > Microsoft.VisualStudio.OLE.Interop
> > > > > Assembly Version: 7.1.40304.0
> > > > > Win32 Version: 7.0.4054
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
> > > > > ---
> > > > > System
> > > > > Assembly Version: 2.0.0.0
> > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
> > > > > ---
> > > > > System.Windows.Forms
> > > > > Assembly Version: 2.0.0.0
> > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> > > > > ---
> > > > > System.Drawing
> > > > > Assembly Version: 2.0.0.0
> > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> > > > > ---
> > > > > Microsoft.SqlServer.SqlTDiagM
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
> > > > > ---
> > > > > Microsoft.DataWarehouse.SQM
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
> > > > > ---
> > > > > Microsoft.SqlServer.Instapi
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
> > > > > ---
> > > > > ObjectExplorer
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
> > > > > ---
> > > > > ConnectionDlg
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
> > > > > ---
> > > > > Microsoft.SqlServer.RegSvrEnum
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
> > > > > ---
> > > > > Microsoft.SqlServer.CustomControls
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
> > > > > ---
> > > > > SqlWorkbench.Interfaces
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
> > > > > ---
> > > > > Microsoft.VisualStudio.TextManager.Interop
> > > > > Assembly Version: 7.1.40304.0
> > > > > Win32 Version: 7.0.4054
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
> > > > > ---
> > > > > Accessibility
> > > > > Assembly Version: 2.0.0.0
> > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
> > > > > ---
> > > > > System.Data
> > > > > Assembly Version: 2.0.0.0
> > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
> > > > > ---
> > > > > EnvDTE
> > > > > Assembly Version: 8.0.0.0
> > > > > Win32 Version: 8.0.50727.42 (RTM.050727-4200)
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
> > > > > ---
> > > > > Microsoft.NetEnterpriseServers.ExceptionMessageBox
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
> > > > > ---
> > > > > SqlMgmt
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
> > > > > ---
> > > > > Microsoft.SqlServer.ConnectionInfo
> > > > > Assembly Version: 9.0.242.0
> > > > > Win32 Version: 9.00.1399.00
> > > > > CodeBase:
> > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
> > > > > ---
> > > > >
> > > > > ************** JIT Debugging **************
> > > > > To enable just-in-time (JIT) debugging, the .config file for this
> > > > > application or computer (machine.config) must have the
> > > > > jitDebugging value set in the system.windows.forms section.
> > > > > The application must also be compiled with debugging
> > > > > enabled.
> > > > >
> > > > > For example:
> > > > >
> > > > > <configuration>
> > > > > <system.windows.forms jitDebugging="true" />
> > > > > </configuration>
> > > > >
> > > > > When JIT debugging is enabled, any unhandled exception
> > > > > will be sent to the JIT debugger registered on the computer
> > > > > rather than be handled by this dialog box.
> > > > >
> > > > >
> > > > >|||Hi John,
I tried the instructions within these two links to no avail. I also tried
to completely remove SQL 2005 deleted all directories in Program Files and
registry keys and continue to get the error when I reinstalled SQL 2005
Developer Edition on Windows XP SP2. Is there any configuration files aor
any other areas that Management Studio is using to start that may be
generating this error? I am al a lost and have run-out of ideas...
JS
"John Bell" wrote:
> Hi Johnny
> To rebuild the registry follow the instructions at:
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
> http://msdn2.microsoft.com/en-us/library/ms143727.aspx
> John
> "Johnny Sandaire" wrote:
> > John,
> >
> > I am willing to try to run SQL Profiler and rebuilding the Registry if that
> > will get me out of that error. This is what I have tried so far that have
> > failed:
> > 1. Re-install SP1 for SQL 2001.
> > 2. Un-install Framework 2.0.
> > 3. Uninstall extra Service that were not needed that was installed as part
> > of the SQL 2005 installation.
> >
> > It looks like a SQL error, however, it happens when the Management Studio is
> > starting. If we knew what was being read (System Stored Procedures, etc...)
> > that may be also a good place to start looking.
> >
> > Can you elaborate on how to rebuild the registry?
> > Can you also tell me what to start in SQL Profiler? I launched it and
> > select to start a new trace and the same error generated.
> >
> > Tks,
> >
> > JS
> >
> >
> > "John Bell" wrote:
> >
> > > Hi Johnny
> > >
> > > The error message is most often (but not always) associated with problems
> > > when the a date is not in the correct format, although re-looking at the
> > > debug this may actually be a numeric conversion.
> > >
> > > The suggestion to use SQL Profiler may have turned up something that would
> > > have helped.
> > >
> > > Have you tried rebuilding the registry?
> > >
> > > John
> > >
> > > "Johnny Sandaire" wrote:
> > >
> > > > John,
> > > >
> > > > Would you please elaborate on the Date Format issue. That is the only thing
> > > > left for me to try before I start over. I have tried to reinstall SP1,
> > > > Removed Framework version 2.0, remove most of the excess service from SQL
> > > > 2005 to no avail.
> > > >
> > > > I have a Windows XP SP2 with multiple MUI installed. Office 2003, Visual
> > > > Studio 2005, SQL 20005. I upgraded from SQL 2000 SP3a. Any other ideas that
> > > > will get rid of this enoying pop-up? You know how it gets, it is like a
> > > > mosquito in my left ear that will not let me fall asleep.
> > > >
> > > > Thanks,
> > > >
> > > > JS
> > > >
> > > > "John Bell" wrote:
> > > >
> > > > > Hi
> > > > >
> > > > > This error message most often occurs because of a date format issue. You may
> > > > > want to check the regional settings.
> > > > >
> > > > > I assume that when you means open SQL Server 2005 you are talking about SQL
> > > > > Server Management Studio? Do other tools also display this message, can you
> > > > > use SQL Profiler to see if it is within a SQL Command or if it is part of the
> > > > > application. You may want to try loading Service Pack1 to re-install client
> > > > > tools.
> > > > >
> > > > > John
> > > > >
> > > > > "sck10" wrote:
> > > > >
> > > > > > Hello,
> > > > > >
> > > > > > I installed SS2K5 Developer edition and everything worked fine. Then I
> > > > > > installed Visual Studio 2K5. When I open SS2K5, I get the following error:
> > > > > >
> > > > > > Unhandled exception has occurred in a component in your application. If you
> > > > > > click Continue, the application will ignore this error and attempt to
> > > > > > continue.
> > > > > >
> > > > > > Input string was not in a correct format.
> > > > > >
> > > > > > After I click Continue, the database opens...
> > > > > > --
> > > > > > Thanks in advance,
> > > > > >
> > > > > > sck10
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > See the end of this message for details on invoking
> > > > > > just-in-time (JIT) debugging instead of this dialog box.
> > > > > >
> > > > > > ************** Exception Text **************
> > > > > > System.FormatException: Input string was not in a correct format.
> > > > > > at System.Number.StringToNumber(String str, NumberStyles options,
> > > > > > NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
> > > > > > at System.Number.ParseInt32(String s, NumberStyles style,
> > > > > > NumberFormatInfo info)
> > > > > > at
> > > > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()
> > > > > > at
> > > > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()
> > > > > > at
> > > > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs
> > > > > > e)
> > > > > > at
> > > > > > Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs
> > > > > > e)
> > > > > > at System.Windows.Forms.Control.WmShowWindow(Message& m)
> > > > > > at System.Windows.Forms.Control.WndProc(Message& m)
> > > > > > at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
> > > > > > at System.Windows.Forms.ContainerControl.WndProc(Message& m)
> > > > > > at System.Windows.Forms.Form.WmShowWindow(Message& m)
> > > > > > at System.Windows.Forms.Form.WndProc(Message& m)
> > > > > > at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
> > > > > > at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> > > > > > at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> > > > > > IntPtr wparam, IntPtr lparam)
> > > > > >
> > > > > >
> > > > > > ************** Loaded Assemblies **************
> > > > > > mscorlib
> > > > > > Assembly Version: 2.0.0.0
> > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> > > > > > ---
> > > > > > AppIDPackage
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
> > > > > > ---
> > > > > > Microsoft.SqlServer.SqlTools.VSIntegration
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
> > > > > > ---
> > > > > > Microsoft.VisualStudio.Shell.Interop
> > > > > > Assembly Version: 7.1.40304.0
> > > > > > Win32 Version: 7.0.4054
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
> > > > > > ---
> > > > > > Microsoft.VisualStudio.OLE.Interop
> > > > > > Assembly Version: 7.1.40304.0
> > > > > > Win32 Version: 7.0.4054
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
> > > > > > ---
> > > > > > System
> > > > > > Assembly Version: 2.0.0.0
> > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
> > > > > > ---
> > > > > > System.Windows.Forms
> > > > > > Assembly Version: 2.0.0.0
> > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> > > > > > ---
> > > > > > System.Drawing
> > > > > > Assembly Version: 2.0.0.0
> > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> > > > > > ---
> > > > > > Microsoft.SqlServer.SqlTDiagM
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
> > > > > > ---
> > > > > > Microsoft.DataWarehouse.SQM
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
> > > > > > ---
> > > > > > Microsoft.SqlServer.Instapi
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
> > > > > > ---
> > > > > > ObjectExplorer
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
> > > > > > ---
> > > > > > ConnectionDlg
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
> > > > > > ---
> > > > > > Microsoft.SqlServer.RegSvrEnum
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
> > > > > > ---
> > > > > > Microsoft.SqlServer.CustomControls
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
> > > > > > ---
> > > > > > SqlWorkbench.Interfaces
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
> > > > > > ---
> > > > > > Microsoft.VisualStudio.TextManager.Interop
> > > > > > Assembly Version: 7.1.40304.0
> > > > > > Win32 Version: 7.0.4054
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
> > > > > > ---
> > > > > > Accessibility
> > > > > > Assembly Version: 2.0.0.0
> > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
> > > > > > ---
> > > > > > System.Data
> > > > > > Assembly Version: 2.0.0.0
> > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
> > > > > > ---
> > > > > > EnvDTE
> > > > > > Assembly Version: 8.0.0.0
> > > > > > Win32 Version: 8.0.50727.42 (RTM.050727-4200)
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
> > > > > > ---
> > > > > > Microsoft.NetEnterpriseServers.ExceptionMessageBox
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
> > > > > > ---
> > > > > > SqlMgmt
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
> > > > > > ---
> > > > > > Microsoft.SqlServer.ConnectionInfo
> > > > > > Assembly Version: 9.0.242.0
> > > > > > Win32 Version: 9.00.1399.00
> > > > > > CodeBase:
> > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
> > > > > > ---
> > > > > >
> > > > > > ************** JIT Debugging **************
> > > > > > To enable just-in-time (JIT) debugging, the .config file for this
> > > > > > application or computer (machine.config) must have the
> > > > > > jitDebugging value set in the system.windows.forms section.
> > > > > > The application must also be compiled with debugging
> > > > > > enabled.
> > > > > >
> > > > > > For example:
> > > > > >
> > > > > > <configuration>
> > > > > > <system.windows.forms jitDebugging="true" />
> > > > > > </configuration>
> > > > > >
> > > > > > When JIT debugging is enabled, any unhandled exception
> > > > > > will be sent to the JIT debugger registered on the computer
> > > > > > rather than be handled by this dialog box.
> > > > > >
> > > > > >
> > > > > >|||Hi
Unfortunately all I can suggest is to a totally clean install or possibly
call PSS.
John
"Johnny Sandaire" wrote:
> Hi John,
> I tried the instructions within these two links to no avail. I also tried
> to completely remove SQL 2005 deleted all directories in Program Files and
> registry keys and continue to get the error when I reinstalled SQL 2005
> Developer Edition on Windows XP SP2. Is there any configuration files aor
> any other areas that Management Studio is using to start that may be
> generating this error? I am al a lost and have run-out of ideas...
> JS
> "John Bell" wrote:
> > Hi Johnny
> >
> > To rebuild the registry follow the instructions at:
> > http://msdn2.microsoft.com/en-us/library/ms144259.aspx
> > http://msdn2.microsoft.com/en-us/library/ms143727.aspx
> >
> > John
> >
> > "Johnny Sandaire" wrote:
> >
> > > John,
> > >
> > > I am willing to try to run SQL Profiler and rebuilding the Registry if that
> > > will get me out of that error. This is what I have tried so far that have
> > > failed:
> > > 1. Re-install SP1 for SQL 2001.
> > > 2. Un-install Framework 2.0.
> > > 3. Uninstall extra Service that were not needed that was installed as part
> > > of the SQL 2005 installation.
> > >
> > > It looks like a SQL error, however, it happens when the Management Studio is
> > > starting. If we knew what was being read (System Stored Procedures, etc...)
> > > that may be also a good place to start looking.
> > >
> > > Can you elaborate on how to rebuild the registry?
> > > Can you also tell me what to start in SQL Profiler? I launched it and
> > > select to start a new trace and the same error generated.
> > >
> > > Tks,
> > >
> > > JS
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi Johnny
> > > >
> > > > The error message is most often (but not always) associated with problems
> > > > when the a date is not in the correct format, although re-looking at the
> > > > debug this may actually be a numeric conversion.
> > > >
> > > > The suggestion to use SQL Profiler may have turned up something that would
> > > > have helped.
> > > >
> > > > Have you tried rebuilding the registry?
> > > >
> > > > John
> > > >
> > > > "Johnny Sandaire" wrote:
> > > >
> > > > > John,
> > > > >
> > > > > Would you please elaborate on the Date Format issue. That is the only thing
> > > > > left for me to try before I start over. I have tried to reinstall SP1,
> > > > > Removed Framework version 2.0, remove most of the excess service from SQL
> > > > > 2005 to no avail.
> > > > >
> > > > > I have a Windows XP SP2 with multiple MUI installed. Office 2003, Visual
> > > > > Studio 2005, SQL 20005. I upgraded from SQL 2000 SP3a. Any other ideas that
> > > > > will get rid of this enoying pop-up? You know how it gets, it is like a
> > > > > mosquito in my left ear that will not let me fall asleep.
> > > > >
> > > > > Thanks,
> > > > >
> > > > > JS
> > > > >
> > > > > "John Bell" wrote:
> > > > >
> > > > > > Hi
> > > > > >
> > > > > > This error message most often occurs because of a date format issue. You may
> > > > > > want to check the regional settings.
> > > > > >
> > > > > > I assume that when you means open SQL Server 2005 you are talking about SQL
> > > > > > Server Management Studio? Do other tools also display this message, can you
> > > > > > use SQL Profiler to see if it is within a SQL Command or if it is part of the
> > > > > > application. You may want to try loading Service Pack1 to re-install client
> > > > > > tools.
> > > > > >
> > > > > > John
> > > > > >
> > > > > > "sck10" wrote:
> > > > > >
> > > > > > > Hello,
> > > > > > >
> > > > > > > I installed SS2K5 Developer edition and everything worked fine. Then I
> > > > > > > installed Visual Studio 2K5. When I open SS2K5, I get the following error:
> > > > > > >
> > > > > > > Unhandled exception has occurred in a component in your application. If you
> > > > > > > click Continue, the application will ignore this error and attempt to
> > > > > > > continue.
> > > > > > >
> > > > > > > Input string was not in a correct format.
> > > > > > >
> > > > > > > After I click Continue, the database opens...
> > > > > > > --
> > > > > > > Thanks in advance,
> > > > > > >
> > > > > > > sck10
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > See the end of this message for details on invoking
> > > > > > > just-in-time (JIT) debugging instead of this dialog box.
> > > > > > >
> > > > > > > ************** Exception Text **************
> > > > > > > System.FormatException: Input string was not in a correct format.
> > > > > > > at System.Number.StringToNumber(String str, NumberStyles options,
> > > > > > > NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
> > > > > > > at System.Number.ParseInt32(String s, NumberStyles style,
> > > > > > > NumberFormatInfo info)
> > > > > > > at
> > > > > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()
> > > > > > > at
> > > > > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()
> > > > > > > at
> > > > > > > Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs
> > > > > > > e)
> > > > > > > at
> > > > > > > Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs
> > > > > > > e)
> > > > > > > at System.Windows.Forms.Control.WmShowWindow(Message& m)
> > > > > > > at System.Windows.Forms.Control.WndProc(Message& m)
> > > > > > > at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
> > > > > > > at System.Windows.Forms.ContainerControl.WndProc(Message& m)
> > > > > > > at System.Windows.Forms.Form.WmShowWindow(Message& m)
> > > > > > > at System.Windows.Forms.Form.WndProc(Message& m)
> > > > > > > at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
> > > > > > > at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> > > > > > > at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> > > > > > > IntPtr wparam, IntPtr lparam)
> > > > > > >
> > > > > > >
> > > > > > > ************** Loaded Assemblies **************
> > > > > > > mscorlib
> > > > > > > Assembly Version: 2.0.0.0
> > > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> > > > > > > ---
> > > > > > > AppIDPackage
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
> > > > > > > ---
> > > > > > > Microsoft.SqlServer.SqlTools.VSIntegration
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
> > > > > > > ---
> > > > > > > Microsoft.VisualStudio.Shell.Interop
> > > > > > > Assembly Version: 7.1.40304.0
> > > > > > > Win32 Version: 7.0.4054
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
> > > > > > > ---
> > > > > > > Microsoft.VisualStudio.OLE.Interop
> > > > > > > Assembly Version: 7.1.40304.0
> > > > > > > Win32 Version: 7.0.4054
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
> > > > > > > ---
> > > > > > > System
> > > > > > > Assembly Version: 2.0.0.0
> > > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
> > > > > > > ---
> > > > > > > System.Windows.Forms
> > > > > > > Assembly Version: 2.0.0.0
> > > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> > > > > > > ---
> > > > > > > System.Drawing
> > > > > > > Assembly Version: 2.0.0.0
> > > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> > > > > > > ---
> > > > > > > Microsoft.SqlServer.SqlTDiagM
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
> > > > > > > ---
> > > > > > > Microsoft.DataWarehouse.SQM
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
> > > > > > > ---
> > > > > > > Microsoft.SqlServer.Instapi
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
> > > > > > > ---
> > > > > > > ObjectExplorer
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
> > > > > > > ---
> > > > > > > ConnectionDlg
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
> > > > > > > ---
> > > > > > > Microsoft.SqlServer.RegSvrEnum
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
> > > > > > > ---
> > > > > > > Microsoft.SqlServer.CustomControls
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
> > > > > > > ---
> > > > > > > SqlWorkbench.Interfaces
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
> > > > > > > ---
> > > > > > > Microsoft.VisualStudio.TextManager.Interop
> > > > > > > Assembly Version: 7.1.40304.0
> > > > > > > Win32 Version: 7.0.4054
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
> > > > > > > ---
> > > > > > > Accessibility
> > > > > > > Assembly Version: 2.0.0.0
> > > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
> > > > > > > ---
> > > > > > > System.Data
> > > > > > > Assembly Version: 2.0.0.0
> > > > > > > Win32 Version: 2.0.50727.42 (RTM.050727-4200)
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
> > > > > > > ---
> > > > > > > EnvDTE
> > > > > > > Assembly Version: 8.0.0.0
> > > > > > > Win32 Version: 8.0.50727.42 (RTM.050727-4200)
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
> > > > > > > ---
> > > > > > > Microsoft.NetEnterpriseServers.ExceptionMessageBox
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
> > > > > > > ---
> > > > > > > SqlMgmt
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
> > > > > > > ---
> > > > > > > Microsoft.SqlServer.ConnectionInfo
> > > > > > > Assembly Version: 9.0.242.0
> > > > > > > Win32 Version: 9.00.1399.00
> > > > > > > CodeBase:
> > > > > > > file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
> > > > > > > ---
> > > > > > >
> > > > > > > ************** JIT Debugging **************
> > > > > > > To enable just-in-time (JIT) debugging, the .config file for this
> > > > > > > application or computer (machine.config) must have the
> > > > > > > jitDebugging value set in the system.windows.forms section.
> > > > > > > The application must also be compiled with debugging
> > > > > > > enabled.
> > > > > > >
> > > > > > > For example:
> > > > > > >
> > > > > > > <configuration>
> > > > > > > <system.windows.forms jitDebugging="true" />
> > > > > > > </configuration>
> > > > > > >