Installting sqlserver 2005 on the client machine for windows application

Hi
I developed a windows application in Visual studio 2005 and the database is sqlexpress.
I wanted my application to run on another system.For that i have installed sqlexpress 2005 on that machine.But that machine doesn't show me any enterprise manager or query manager for sqlserver.
Is there any solution for this.

Thanks

hi,

yes... you have to separately download and install SQL Server Management Studio Express... http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

regards

|||SQL Server Express does not come with EM or Query Analyzer. These two components have been merged into the SQL Server Managment Studio. The SQL Server Management Studio Express (which actually is a stripped of SQL Server Managment Studio (aka SSMS)) can be downloaded separately from Microsoft or is already included in the Express Advanced Edition (which actually includes some other cool features like Reporting Services for SQL Server Express).

http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.desql

installing the sample databases and documentation

There are two instances: SQL2005 and SQL2005Express on two different units. While there is Visual Studio 2005 Team Edition also installed on the units have not attempted these component installs through either yet. Have spent the better part of two days, following all the directions having searched help locally, online, technet,and applied their advice respectively. While I've taken out the old instances, downloaded updated ones in both my SQL Server instances they do not show as installed under Programs->SQL Server (whichever instance)->Tutorials ...However they do show installed in Control Panel and they can be found via Explorer (AdWorks DBCI+AdWorks BICI and Express instance on the other unit. Have also download SP2 and installed it, but this has proved of no help. @. My wits' end, any help will be appreciated.

Documentation and sample databases are an option during installation.

Books Online appears as an installed program in Add/Remove Programs but the sample databases do not.

If AdventureWorks was installed with 2005 but did not appear in Object Explorer you can attach it. Attach is on the right-click menu of Databases in Object Explorer.

|||

You can also find the SQL Server 2005 documentation available online at:

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

It has many great tutorials to get started.

Thanks,
Sam Lester (MSFT)

|||Thank you for your suggestion Lester, however before my initial post had already consulted books online, and downloaded the latest version to stay in sync with the software. Part of my frustration comes from following their directions but failing to achieve similar outcomes. Adventure Works databases are definitely resident on my computer, though not in the same directories in the Explorer file hierarchy indicated by the manuals/instructions. The directions have been exhaustively followed a number of times, replete with uninstalls then reinstalls - all to no avail. This is the case in both units, each with a different operating system and different version of SQL. Am still stymied.

Installing SSRS report designer with Visual Studio 2005

I have VS 2005 installed on my workstation. I have Sql Server 2005 on a
database server, and
just installed Reporting Services on a web server.
How do I install the Report Services report designer on my workstation in VS
2005?
thanks,
Bob M..Just place the dick into drive of your computer and start installation.
During the installation, you can choose to install client tool only.
"Bob Murdoch" <ram_re_move_5@.erols.com> wrote in message
news:uwjclTfBIHA.4752@.TK2MSFTNGP04.phx.gbl...
>I have VS 2005 installed on my workstation. I have Sql Server 2005 on a
>database server, and
> just installed Reporting Services on a web server.
> How do I install the Report Services report designer on my workstation in
> VS 2005?
> thanks,
> Bob M..
>|||"Norman Yuan" <NoAddress@.NoEmail.fake> wrote in message
> Just place the dick into drive of your computer and start installation.
> During the installation, you can choose to install client tool only.
>
Besides the slip of the keyboard, which disk are you referring to? When I
try to use the Sql Server 2005 disk, the Reporting Services option is grayed
out (presumably because I don't have IIS installed on my workstation?).
thanks,
Bob M..|||I do not not what kind of disk your SQL Server2005 is on. I have heard it
may be on 2 CDs or 1 DVD. Mine is from MSDN subscription, which has two
setup.exe - one for the server part and one for client tools part.
Whatever you have, you should install client components only, including
Connectivity components, Management tools, Business Intelligence Development
Studio (this is what you need!), SDK, documentation... You do not need to
install RS for report designing, unless you want to.
"Bob Murdoch" <ram_re_move_5@.erols.com> wrote in message
news:OSnjevfBIHA.2004@.TK2MSFTNGP06.phx.gbl...
> "Norman Yuan" <NoAddress@.NoEmail.fake> wrote in message
>> Just place the dick into drive of your computer and start installation.
>> During the installation, you can choose to install client tool only.
> Besides the slip of the keyboard, which disk are you referring to? When I
> try to use the Sql Server 2005 disk, the Reporting Services option is
> grayed out (presumably because I don't have IIS installed on my
> workstation?).
> thanks,
> Bob M..
>

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>
> > > > > > >