I had: · A default instance of SQL Server 2000 Dev Edition · A named instance of SQL 2005 Dev Edition · The OS is Windows 2000 sp4 All worked fine for several months. Some days ago I installed the recommended patches from windows update. Shortly afterwards I was unable to access Management studio The error message was: Cannot connect to <SQL Server Instance> The type initializer for 'system.data.sqlclient.sqlconnection' threw an exception The type initializer for 'system.data.sqlclient.sqlconnectionFactory' threw an exception The type initializer for 'system.data.sqlclient.sqlPerformanceCounters' threw an exception Configuration system failed to initialize (system.configuration) Unrecognized configuration section runtime C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE|SqlWb.exe.config line 2 (system.Configuration) I uninstalled SQL Server 2005 from Add/Remove Programs. Afterwards : · I was unable to reinstall SQL Server 2005 · I was unable to launch SQL 2000 Enterprise Manager (but was able to connect via Query Analyzer) to connect to the default instance After following the instructions in the following Microsoft KB articles · KBA914157 - http://support.microsoft.com/kb/914157 (Error message when you open SQL Server Enterprise Manager after you uninstall the SQL Server 2005 Backward Compatibility Components: "Snap-in failed to initialize") · How to: Manually Uninstall an Existing Instance of SQL Server 2005 http://msdn.microsoft.com/en-us/library/aa337087.aspx I was able to · Connect to SQL Server 2000 default instance using Enterprise Manager · Manually remove and reinstall SQL Server 2005 named instance However, having successfully reinstalled SQL Server 2005 as a named instance I still CANNOT connect to SQL Server 2005. I get the same error as before when I try to connect to SQL Server via management Studio Any assistance appreciated -- fhillipo
Did you uninstalled and reinstalled Workstation Components (which contains Management Tools [SSMS]) when you uninstalled your SQL Server 2005 Developer Edition instance? Also, did you try uninstalling and reinstalling .Net Framework (especially 2.0)? -- Ekrem Ãnsoy "fhillipo" wrote in message news:2C9A30E3-BD7E-4C3C-AFAC-1C580F886411@microsoft.com... >I had: > · A default instance of SQL Server 2000 Dev Edition > · A named instance of SQL 2005 Dev Edition > · The OS is Windows 2000 sp4 > > All worked fine for several months. Some days ago I installed the > recommended patches from windows update. Shortly afterwards I was unable > to > access Management studio > > The error message was: > > Cannot connect to <SQL Server Instance> > The type initializer for 'system.data.sqlclient.sqlconnection' threw an > exception > The type initializer for 'system.data.sqlclient.sqlconnectionFactory' > threw > an exception > The type initializer for 'system.data.sqlclient.sqlPerformanceCounters' > threw an exception > Configuration system failed to initialize (system.configuration) > Unrecognized configuration section runtime C:\Program Files\Microsoft SQL > Server\90\Tools\Binn\VSShell\Common7\IDE|SqlWb.exe.config line 2 > (system.Configuration) > > I uninstalled SQL Server 2005 from Add/Remove Programs. Afterwards : > · I was unable to reinstall SQL Server 2005 > · I was unable to launch SQL 2000 Enterprise Manager (but was able to > connect via Query Analyzer) to connect to the default instance > > After following the instructions in the following Microsoft KB articles > > · KBA914157 - http://support.microsoft.com/kb/914157 (Error message when > you > open SQL Server Enterprise Manager after you uninstall the SQL Server 2005 > Backward Compatibility Components: "Snap-in failed to initialize") > > · How to: Manually Uninstall an Existing Instance of SQL Server 2005 > http://msdn.microsoft.com/en-us/library/aa337087.aspx > > I was able to > · Connect to SQL Server 2000 default instance using Enterprise Manager > · Manually remove and reinstall SQL Server 2005 named instance > > However, having successfully reinstalled SQL Server 2005 as a named > instance > I still CANNOT connect to SQL Server 2005. I get the same error as before > when I try to connect to SQL Server via management Studio > > Any assistance appreciated > > -- > fhillipo
I successfully uninstalled all components. However, I did not uninstall .Net Framework (2.0 & 1.1) before reinstalling SQL Server 2005 -- fhillipo "Ekrem Ãnsoy" wrote: > Did you uninstalled and reinstalled Workstation Components (which contains > Management Tools [SSMS]) when you uninstalled your SQL Server 2005 Developer > Edition instance? > > Also, did you try uninstalling and reinstalling .Net Framework (especially > 2.0)? > > -- > Ekrem Ãnsoy > > > > "fhillipo" wrote in message > news:2C9A30E3-BD7E-4C3C-AFAC-1C580F886411@microsoft.com... > >I had: > > · A default instance of SQL Server 2000 Dev Edition > > · A named instance of SQL 2005 Dev Edition > > · The OS is Windows 2000 sp4 > > > > All worked fine for several months. Some days ago I installed the > > recommended patches from windows update. Shortly afterwards I was unable > > to > > access Management studio > > > > The error message was: > > > > Cannot connect to <SQL Server Instance> > > The type initializer for 'system.data.sqlclient.sqlconnection' threw an > > exception > > The type initializer for 'system.data.sqlclient.sqlconnectionFactory' > > threw > > an exception > > The type initializer for 'system.data.sqlclient.sqlPerformanceCounters' > > threw an exception > > Configuration system failed to initialize (system.configuration) > > Unrecognized configuration section runtime C:\Program Files\Microsoft SQL > > Server\90\Tools\Binn\VSShell\Common7\IDE|SqlWb.exe.config line 2 > > (system.Configuration) > > > > I uninstalled SQL Server 2005 from Add/Remove Programs. Afterwards : > > · I was unable to reinstall SQL Server 2005 > > · I was unable to launch SQL 2000 Enterprise Manager (but was able to > > connect via Query Analyzer) to connect to the default instance > > > > After following the instructions in the following Microsoft KB articles > > > > · KBA914157 - http://support.microsoft.com/kb/914157 (Error message when > > you > > open SQL Server Enterprise Manager after you uninstall the SQL Server 2005 > > Backward Compatibility Components: "Snap-in failed to initialize") > > > > · How to: Manually Uninstall an Existing Instance of SQL Server 2005 > > http://msdn.microsoft.com/en-us/library/aa337087.aspx > > > > I was able to > > · Connect to SQL Server 2000 default instance using Enterprise Manager > > · Manually remove and reinstall SQL Server 2005 named instance > > > > However, having successfully reinstalled SQL Server 2005 as a named > > instance > > I still CANNOT connect to SQL Server 2005. I get the same error as before > > when I try to connect to SQL Server via management Studio > > > > Any assistance appreciated > > > > -- > > fhillipo > >
