Instance naming problems

When I try to Add New Item - Database in VS C# Express, I get "An error has occurred while establishing a conncection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)"

When I open the management studio, I can connect to a database named Dev, and when I try to "Browse for more" from the server selector combobox, it is the only one found. I believe "Dev" was my old MSDE name, although this is also what my "Computer Name" is set to. Unfortunetly the setup of SQL Express didn't ask me what to name my instance.

I thought maybe the SQL Server 2005 Express Toolkit installation didn't actually contain the server software, and only installed the tools, as during the installation the section where I select components only listed things like client tools and what not, with not mention of the server software.

So I thought maybe it didn't install the server, so I downloaded the server installation that is by itself, and installed it, this time I saw the check for hide advanced options, so I went through the advanced options this time. I've have been through this same setup before at work, and both times it has confused me. It seems very different from installing previous versions of SQL server.

Where I choose to create a new instance or upgrade, I choose to upgade, and it is not clear what I'm upgrading, the selector does not display instance names.

At another point it asks me about configuring it to use the Local service, local system, or network account. The documentation of how these differ is vauge. For example, the network account is described basically as "don't use this" without saying what it is.

I was accustomed to just a local account, and network account settings from previous versions, and network was always the logical choice for me to use intergrated security. I don't understand what the new catagories represent and what will be functionally different in the way I connect.

So I'm really confused, and getting back to the instance names. In the surface area configuration as well as the VS Express, it only sees the name as MSSQLSERVER

For example if I "add new connection" from database explorer and click advanced, the datasource drop down lists only ".\MSSQLSERVER"

So I'm thoroughly confused at this point and not sure what to do.

Let's see if I can help you some:

* By default, if you install the SQL Server Express engine and you do not specify the instance name the instance name would be SQLEXPRESS.

* Connect to a named instance by specifying "<Computer Name>\<Instance Name>" (without the quotes). ".\<Instance Name> will also work when connect to a local instance.

* For the service account, using Network Service or domain account without administrator rights on the local server is recommended. Network Service work best if SQL Server does not need to perform functions on the network which requires more permission than Network Service has. If this is the case, use a low-privilege domain account.

* Use SQL Server Configuration Manager to view all SQL services (instances) installed. (I am not sure if SQL 2000 instance include MSDE are shown -- if not use SQL Manager or Control Panel | Services to see if MSDE is installed)

Hope this helps,

Peter Saddow

Instance name specified is invalid

I am trying to apply the sql2kdesksp3a to a new
installation of SQL desktop. When I try and apple the SP
I recieve the error The instance name is invalid. I have
tried searching for the instance in the registry that is
reffered to on KB 311762 but I can not find any
references to the MSI file used for install. I am using a
select CD from Microsoft to install SQL Desktop. I dont
understand why this should be so hard I have not loaded
any 3rd part apps just XP and the SQL desktop and
Analysis services
no
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

instance is invalid

Error message during install:
Instance is invalid.
Just installed SP3a sql2kdesksp3.exe
Hi,
I think there is a instance conflicts. THis occurs if an instance of SQL
Server is already
installed on the target machine. To overcome this issue, you have to specify
the Instance name while running the setup.
Setup.exe INSTANCENAME=<name> SAPWD=<sapassword > /l*v c:\log.txt
Create a verbose log usinfg /l*v so that you can determine if installation
was successful or not.
Thanks
Hari
MCDBA
"hangman" <hangman@.discussions.microsoft.com> wrote in message
news:C0E83B1E-95A6-4016-8D04-D5DA1A0B3765@.microsoft.com...
> Error message during install:
> Instance is invalid.
> Just installed SP3a sql2kdesksp3.exe

Installtion

I was trying to install SQLSERVER 2000 on WINOWS 2000 Advanced server,i am
getting an error "A previous program installation created pending file
operations on the installation machine.you must restart the computer before
running setup".I did restart the computer again i am getting same error.
I am wondering how to resolve this issue.Pls help me ..
Advance Thanks,
Sriram.
See if this helps:
http://support.microsoft.com/default...95&Product=sql
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Ram" <Ram@.discussions.microsoft.com> wrote in message
news:3DF5F779-AAB6-484B-9F22-AA44CBD23F70@.microsoft.com...
> I was trying to install SQLSERVER 2000 on WINOWS 2000 Advanced server,i am
> getting an error "A previous program installation created pending file
> operations on the installation machine.you must restart the computer
before
> running setup".I did restart the computer again i am getting same error.
> I am wondering how to resolve this issue.Pls help me ..
> Advance Thanks,
> Sriram.

InstallSQLAgentSecurity failed

I (actually one of our clients) is receiving an InstallSQLAgentSecurity
failed error in the msde install log.
*************************************
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (LORIH,LocalSystem,87).
Action ended 14:11:24: InstallFinalize. Return value 3.
*************************************
I've seen the following article
http://support.microsoft.com/default...en-us%3B829386
However, the Server service is running and it still won't start up. The
user is logged in as the Administrator, so is there anything else this can
be. We have this come up every now and then and we really don't have many
options to solve this.
Lance Johnson
Your solution is here:
http://seer.support.veritas.com/docs/265613.htm
I had the same problem and solution #2 fixed it. Tell me how it goes.
"Lance Johnson" <ljohnson@.docs.com> wrote in message news:<OM2SSmgXEHA.3292@.TK2MSFTNGP09.phx.gbl>...
> I (actually one of our clients) is receiving an InstallSQLAgentSecurity
> failed error in the msde install log.
> *************************************
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity failed (LORIH,LocalSystem,87).
> Action ended 14:11:24: InstallFinalize. Return value 3.
> *************************************
> I've seen the following article
> http://support.microsoft.com/default...en-us%3B829386
> However, the Server service is running and it still won't start up. The
> user is logged in as the Administrator, so is there anything else this can
> be. We have this come up every now and then and we really don't have many
> options to solve this.
> Lance Johnson
|||"Lance Johnson" <ljohnson@.docs.com> wrote in message
http://seer.support.veritas.com/docs/265613.htm
Is where the solution is.
news:<OM2SSmgXEHA.3292@.TK2MSFTNGP09.phx.gbl>...
> I (actually one of our clients) is receiving an InstallSQLAgentSecurity
> failed error in the msde install log.
> *************************************
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity failed (LORIH,LocalSystem,87).
> Action ended 14:11:24: InstallFinalize. Return value 3.
> *************************************
> I've seen the following article
> http://support.microsoft.com/default...en-us%3B829386
> However, the Server service is running and it still won't start up. The
> user is logged in as the Administrator, so is there anything else this can
> be. We have this come up every now and then and we really don't have many
> options to solve this.
> Lance Johnson
|||Check solution #2 @. the veritas page. I changed the roles and all
worked fine. Changed them back after and all continued to work.
[vbcol=seagreen]
> "Lance Johnson" <ljohnson@.docs.com> wrote in message
> http://seer.support.veritas.com/docs/265613.htm
> Is where the solution is.
> news:<OM2SSmgXEHA.3292@.TK2MSFTNGP09.phx.gbl>...
sql

InstallingSQL Server September 2005 Community Technology Preview ...errors

Hi,

I am trying to install Microsoft SQL Server September 2005 Community Technology Preview.

I get the generic error saying "SQL Server 2005 setup has detected incompatibe components..."

So I checked the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SQLSetup0020_Core.log file

which says

C:\SQLENT2005\Servers\setup.exe Version: 2005.90.1314.0
Running: LoadResourcesAction at: 2005/9/11 13:3:29
Complete: LoadResourcesAction at: 2005/9/11 13:3:29, returned true
Running: ParseBootstrapOptionsAction at: 2005/9/11 13:3:29
Loaded DLL:C:\SQLENT2005\Servers\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2005/9/11 13:3:30, returned true
Running: ValidateWinNTAction at: 2005/9/11 13:3:30
Complete: ValidateWinNTAction at: 2005/9/11 13:3:30, returned true
Running: ValidateMinOSAction at: 2005/9/11 13:3:30
Complete: ValidateMinOSAction at: 2005/9/11 13:3:30, returned true
Running: PerformSCCAction at: 2005/9/11 13:3:30
Complete: PerformSCCAction at: 2005/9/11 13:3:31, returned true
Running: ActivateLoggingAction at: 2005/9/11 13:3:31
Complete: ActivateLoggingAction at: 2005/9/11 13:3:31, returned true
Running: DetectPatchedBootstrapAction at: 2005/9/11 13:3:31
Complete: DetectPatchedBootstrapAction at: 2005/9/11 13:3:31, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__1952" returned false.
Running: PerformSCCAction2 at: 2005/9/11 13:3:31
Loaded DLL:C:\WINNT\system32\msi.dll Version:3.1.4000.2435
Product "{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}" versioned 9.00.1187.07 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1314
The Product Name is "Microsoft SQL Server Setup Support Files (English)"
Loaded DLL:C:\WINNT\system32\msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

I understand that I need to uninstall "Microsoft SQL Server Setup Support Files (English)"

But when I try to do that I get
"A network error occured while attempting to read from C:\Winnt\Installer\SQLSupport.msi"

how do i fix this...how come nobody has a clue....|||Which previous version of Yukon / Whidbey did you have installed. Yukon comes with an uninstaller in the \Servers\Setup Tools folder. Use that to uninstall previous versions.|||When I ran the uninstall program its says

"There are no SQL Server 2005 or .Net Framework components to unistall"|||How did you uninstall the previous version ?|||I didnt have any version of SQL Server 2005.
What I had is the .net Framework 2.0 Beta version which I unistalled as per the reqm of SQL Server 2005.|||moreover the Change/Remove button for SQL Server Setup Support Files is greyed out...so I can uninstall it either..and SQL Server 2005 setup wont run unless I unless
I get rid of it...
what the heck is goin on..

Installing with MSDE on XP

I would like to install MSDE in Windows XP Professional. When I tried
to install it gave me an error A strong SA password is required for
security reasons. Please use SAPWD switch
I do not know how it handle this error if you can please let me how to
install in XP.
Step by Step process.
Thanking You
Your's Truly
Raj
hi Raj,
Raj wrote:
> I would like to install MSDE in Windows XP Professional. When I tried
> to install it gave me an error A strong SA password is required for
> security reasons. Please use SAPWD switch
> I do not know how it handle this error if you can please let me how to
> install in XP.
> Step by Step process.
Setup.exe is a boostrap intaller for MSDE and accepts parameters you can
provide at the command line as long as in a companion .Ini file..
at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
you can find the list of all supported parameters...
please open a DOS command window and navigate to the folder hosting the
setup.exe file...
there you can run setup.exe with all the parameters of your choice..
- usually you have to provide the SAPWD parameter to specify a strong
password for the "sa" builtin login in order to protect it from both
internal and external attacks..
specify then
SAPWD=your_strong_password
- additional parameters let you specify if you want a named instance or a
default instance... specify
INSTANCENAME=your_instance_name
if you want a named instance...
- another parameter let you specify if you want to allow remote connections
from other PCs in your lan to your MSDE instance.. specify
DISABLENETWORKPROTOCOLS=0
if you need this feature...
- by default, MSDE is installed allowing only WindowsNT authenticated
connections and preventing standard SQL Server authenticated ones.. more on
this at http://support.microsoft.com/default...b;en-us;325022
you can specify
SECURITYMODE=SQL
to allow mixed mode security, thus allowing both WInNT integrated security
and standard SQL Server authenticated connections..
- the final important parameter is
/L*v "c:\msdelog.txt"
where you will allow verbose logging of the installation process, resulting
in a text file of about 2mb for a successfull installation you can inspect,
in case of problems, for
RETURN VALUE 3
entries... about 10 lines before each entry some (sometime cryptic)
description of the problwm will be reported..
so, if you like to install a "named instace" named "Raj" with mixed security
and enabled network protocols for remote connections you can run setup.exe
boostrap installer providing all parameters as
c:\..\>setup.exe /qb INSTANCENAME=Raj SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0 SAPWD=your_strong_password /L*v "c:\msdelog.txt"
you can later manage your installed instance via the native character tool
oSql.exe as described at
http://support.microsoft.com/default...;EN-US;q325003 or use a
third party tool, both commercial or free, like the ones listed at
http://www.microsoft.com/sql/msde/partners/ or
http://www.aspfaq.com/show.asp?id=2442... google for further..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

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