Instance specified not valid

Hi,

I'm trying to install MSDE SP3 which I downloaded from MS at http://www.asp.net/msde/.
Following the instructions as best I can I unzipped the file into a Folder now called MSDE located on C: I then went to a command prompt and typed in the command given to start the install:

setup SAPWD=testsite SecurityMode=SQL

Hit enter and the installer started up and ran for a few secs and then came back with

The Instance named specified is invalid

There was no mention of including an instance name or the format for it.

Suggestions please?

Also, if I want to completly uninstall MSDE if I need to how would I do it?

Thanks,
BobWell, I had this message come up if I tried to run setup for the instance that was already on the system.

I used this setup to install msde on my machine.

setup instancename="netsdk" sapwd="your password for sa" securitymode=sql

Reason for using instance name netsdk was that it seems that SDK kit needs this instance to install pubs and nwind database.

After executing this i did not get any error messages but when I started service manager I could not see any servers listed. It took me solid two hours to come up with idea to look into error log and there it was.

2004-03-09 11:57:44.50 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2004-03-09 11:57:44.50 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-03-09 11:57:44.50 server All rights reserved.
2004-03-09 11:57:44.50 server Server Process ID is 3456.
2004-03-09 11:57:44.50 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$NETSDK\LOG\ERRORLOG'.
2004-03-09 11:57:44.52 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2004-03-09 11:57:44.63 server SQL Server configured for thread mode processing.
2004-03-09 11:57:44.63 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-03-09 11:57:44.63 spid2 Warning ******************
2004-03-09 11:57:44.63 spid2 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-03-09 11:57:44.63 spid2 Starting up database 'master'.
2004-03-09 11:57:44.98 spid5 Starting up database 'model'.
2004-03-09 11:57:44.98 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-03-09 11:57:45.03 spid2 Server name is 'PC0491-EPITKA\NETSDK'.
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 5
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 6
2004-03-09 11:57:45.03 spid2 Starting up database 'msdb'.
2004-03-09 11:57:45.17 server SQL server listening on Shared Memory.
2004-03-09 11:57:45.17 server SQL Server is ready for client connections
2004-03-09 11:57:45.38 spid5 Clearing tempdb database.
2004-03-09 11:57:46.12 spid5 Starting up database 'tempdb'.
2004-03-09 11:57:46.20 spid2 Recovery complete.
2004-03-09 11:57:46.20 spid2 SQL global counter collection task is created.
2004-03-09 11:57:46.22 spid2 Warning: override, autoexec procedures skipped.
2004-03-09 11:57:56.94 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:56.94 spid51 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.08 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:57.08 spid51 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.34 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.

There is a line that says servername, I typed it in and I was able to start service. Log should be under c:\program files\microsoft sql server\mssql${your instance name}\log.

I am very new to windows world since I worked on Unix platform for past six years, so for you gurus out there this migth be something that does not need to be explained. Anyway I hope this helps.sql

Instance Failure: SqlDataSource

I'm trying to populate a DropDownList with data from an SQL table (called StrataPlans). I'm getting an instance failure from the following code:

<

asp:SqlDataSourceID="dataSource"runat="server"ConnectionString="Server=BEN-TOSH\\SQLEXPRESS; TRUSTED_CONNECTION=YES; database=OSMSQL"SelectCommand="SELECT * FROM StrataPlans"ProviderName="System.Data.SqlClient"SelectCommandType="Text"/>

<asp:DropDownListID="spList"DataSourceID="dataSource"runat="server"/>

I've tested the connectionstring/select query in another of my applications and it works ok...can anyone point me in the right direction as to how to resolve this?

Thanks

Hmm,

That seems odd; an instance failure would be with creating the obect I would think. Could you provide the details of the error message?

Installing the KB815495 hotfix over sp3a

I need to automatically install the hotfix following the installation of
MSDE sp3a. I use InstallShield to handle the installation which also
installs our app. It appears that the hotfix installation requires user
intervention to select the instance to apply the hotfix to. Is there a way
to bypass the UI and perform a silent installation for a specified instance?
Regards
Russell
Have you looked at the KB article for that hotfix yet,
http://support.microsoft.com/default.aspx?scid=KB;[LN];821277? I think it
contains the information you're looking for.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Russell Wyatt" <russellw_REMOVE_THIS_TO_REPLY_@.ihs.com.au> wrote in message
news:u4ugpg2UEHA.808@.tk2msftngp13.phx.gbl...
> I need to automatically install the hotfix following the installation of
> MSDE sp3a. I use InstallShield to handle the installation which also
> installs our app. It appears that the hotfix installation requires user
> intervention to select the instance to apply the hotfix to. Is there a way
> to bypass the UI and perform a silent installation for a specified
instance?
> Regards
> Russell
>
|||Ah, the old "Read the documentation" trick. I started, got bored and didn't
make it to the end.
Thanks for the direction
Russell
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23eKp3A9UEHA.1164@.tk2msftngp13.phx.gbl...
> Have you looked at the KB article for that hotfix yet,
> http://support.microsoft.com/default.aspx?scid=KB;[LN];821277? I think it
> contains the information you're looking for.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Russell Wyatt" <russellw_REMOVE_THIS_TO_REPLY_@.ihs.com.au> wrote in
message[vbcol=seagreen]
> news:u4ugpg2UEHA.808@.tk2msftngp13.phx.gbl...
way
> instance?
>
|||It happens to us all... :-)
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Russell Wyatt" <russellw_REMOVE_THIS_TO_REPLY_@.ihs.com.au> wrote in message
news:u4KOZb$UEHA.3280@.TK2MSFTNGP10.phx.gbl...
> Ah, the old "Read the documentation" trick. I started, got bored and
didn't[vbcol=seagreen]
> make it to the end.
> Thanks for the direction
> Russell
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23eKp3A9UEHA.1164@.tk2msftngp13.phx.gbl...
it[vbcol=seagreen]
> rights.
> message
of[vbcol=seagreen]
user
> way
>

Installing SSRS 2005 in web server and cluster environment.

Hi,

I am installing SSRS 2005 with the following scenario:

- Report Server and Report Manager will be installed on web server

- The repository databases (ReportServer and ReportServerTempDB) will be hosted in SQL2005 cluster server.

Both servers are running Win2003 SP1, SQL/SSRS 2005 SP1

When I try to browse the ReportServer virtual directory from IIS on the web server, the system keep asking username and password. After 3 times trials and it failed eventhough the username and password is correct.

The error message is:

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)

I've been searching on the web and found couple of articles talking about this issue. I've tried some of them like: http://support.microsoft.com/kb/887993 or even this one: http://groups.google.ca/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/991c9178ceab8f58/8f1a447aa60ad837?lnk=st&q=reporting+services+the+server+is+not+responding&rnum=3&hl=en#8f1a447aa60ad837

But this doesn't work.

I've checked both event viewer both web server and SQL server, but I can't see any information that tell me what had happened.

I also look at BOL, but doesn't help much.

Is there anyone can help me or point me to the right direction? Is there any guide document that explains step-by-step how to install SSRS in my scenario or similiar?

Many Thanks,

Usman Tjiudri

I have the exact same issue in a identical envirnonment configuration. Did you get this resolved?

I`m looking at a few articles re Kerberos....

|||Hi,

Yes, finally I got this issue resolved.
After looking for answer almost everywhere, I finally turn to Microsoft Support and they gave me a very quick response (less than 24 hours).
Before I talk about the solution, I need to clarify something here - my environment is Win2003 Server R2 (not Win2003 SP1 as mentioned in previous email) - may be there's a SP1 for R2.
The issue is caused by IIS. Apparently R2 has different version of IIS with normal Win2003 Server.
You need to uninstall completely IIS on your server (may be you need to backup IIS metadata) and install IIS for R2. You can get the software from R2 disc.
If you still can't solve the issue, log it to Microsoft Support.

Let me know how it goes.

Hope This Help,
Usman Tjiudri

Installing SSRS 2005 in web server and cluster environment.

Hi,

I am installing SSRS 2005 with the following scenario:

- Report Server and Report Manager will be installed on web server

- The repository databases (ReportServer and ReportServerTempDB) will be hosted in SQL2005 cluster server.

Both servers are running Win2003 SP1, SQL/SSRS 2005 SP1

When I try to browse the ReportServer virtual directory from IIS on the web server, the system keep asking username and password. After 3 times trials and it failed eventhough the username and password is correct.

The error message is:

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)

I've been searching on the web and found couple of articles talking about this issue. I've tried some of them like: http://support.microsoft.com/kb/887993 or even this one: http://groups.google.ca/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/991c9178ceab8f58/8f1a447aa60ad837?lnk=st&q=reporting+services+the+server+is+not+responding&rnum=3&hl=en#8f1a447aa60ad837

But this doesn't work.

I've checked both event viewer both web server and SQL server, but I can't see any information that tell me what had happened.

I also look at BOL, but doesn't help much.

Is there anyone can help me or point me to the right direction? Is there any guide document that explains step-by-step how to install SSRS in my scenario or similiar?

Many Thanks,

Usman Tjiudri

I have the exact same issue in a identical envirnonment configuration. Did you get this resolved?

I`m looking at a few articles re Kerberos....

|||Hi,

Yes, finally I got this issue resolved.
After looking for answer almost everywhere, I finally turn to Microsoft Support and they gave me a very quick response (less than 24 hours).
Before I talk about the solution, I need to clarify something here - my environment is Win2003 Server R2 (not Win2003 SP1 as mentioned in previous email) - may be there's a SP1 for R2.
The issue is caused by IIS. Apparently R2 has different version of IIS with normal Win2003 Server.
You need to uninstall completely IIS on your server (may be you need to backup IIS metadata) and install IIS for R2. You can get the software from R2 disc.
If you still can't solve the issue, log it to Microsoft Support.

Let me know how it goes.

Hope This Help,
Usman Tjiudri

sql

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