Re: Get Error when I start SQL Server Management Studio for SQL Server 2008

From	"Tony Johansson" <johansson.andersson@telia.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Get Error when I start SQL Server Management Studio for SQL Server 2008
Date	2014-01-29 14:04 +0100
Organization	A noiseless patient Spider
Message-ID	<lcau98$v6n$2@dont-email.me> (permalink)
References	<lc870j$557$1@dont-email.me> <XnsA2C3D8C3B65C3Yazorman@127.0.0.1> <lc9b4n$7t5$1@dont-email.me> <XnsA2C4614B83F82Yazorman@127.0.0.1>

Show all headers | View raw

Now here is what I have done.
1. Run setup.exe from my SQL Server 2008 CD
2.Select Maintenance
3.Select and start Repair
4.When I recive the question "Specify the instance of SQL Server to repair"
I selected MSSQLSERVER
5.When the repair was finished with instance MSSQLSERVER  where all  was
passed I started the Repair all over again and selected the SQLEXPRESS.
6. I rebooted my PC and started SQL Server management Studio but to my 
surprise  I got the same
error that I hade before.

So inspite having repair the SQL Server 2008(both instances) I still have 
the same problem.
One thing that is strange is that why is the heading of the error that is 
displayed when I start SQL Server management Studio
have Microsoft .NET Framework when the problem really is to start the SQL 
Server management Studio without any error.

I tried to attach a printscreen image but the I got error. So I will show 
how the error will look like in this way instead.
I have also copied the whole error message below
----------------------------------------------------------------------
| Microsoft .NET Framework
|
| Unhandled exception has occured in a component in your application. If you 
click continue the application will ignore the error and
| attempt |to continue.

Unable to read the list of previously registered on this system Re-register 
your servers in the Register server window.

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerException: 
Unable to read the list of previously registered servers on this system. 
Re-register your servers in the 'Registered Servers' window. ---> 
Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializationException: 
Deserialization operation on 
/RegisteredServersStore/ServerGroup/AnalysisServicesServerGroup has 
failed. ---> System.InvalidOperationException: Unable to generate a 
temporary class (result=1).
error CS0016: Det gick inte att skriva till utdatafilen 
c:\Users\tony\AppData\Local\Temp\jf83onf8.dll: Could not execute CVTRES.EXE.

   at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, 
XmlSerializerCompilerParameters xmlParameters, Evidence evidence)
   at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[] 
xmlMappings, Type[] types, String defaultNamespace, Evidence evidence, 
XmlSerializerCompilerParameters parameters, Assembly assembly, Hashtable 
assemblies)
   at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings, 
Type[] types, String defaultNamespace, String location, Evidence evidence)
   at System.Xml.Serialization.XmlSerializer.GenerateTempAssembly(XmlMapping 
xmlMapping, Type type, String defaultNamespace)
   at System.Xml.Serialization.XmlSerializer..ctor(Type type, String 
defaultNamespace)
   at System.Xml.Serialization.XmlSerializer..ctor(Type type)
   at Microsoft.SqlServer.Management.Sdk.Sfc.SfcUtility.GetXmlValue(String 
xmlContent, Type valueType)
   at 
Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.GetPropertyValueFromXmlString(String 
xmlString, Type propType, IXmlSerializationAdapter serializationAdapter)
   at 
Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.CreateInstanceFromSerializedData(Type 
instanceType, String instanceUri, List`1 serializedData)
   at 
Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.Deserialize(XmlReader 
reader, String instanceUri, Object& instance, SfcObjectState state)
   at 
Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.Deserialize(XmlReader 
xmlReader, SfcObjectState state)
   --- End of inner exception stack trace ---
   at 
Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.Deserialize(XmlReader 
xmlReader, SfcObjectState state)
   at 
Microsoft.SqlServer.Management.RegisteredServers.RegisteredServersStore.InitChildObjects(String 
file)
   --- End of inner exception stack trace ---
   at 
Microsoft.SqlServer.Management.RegisteredServers.RegisteredServersStore.InitChildObjects(String 
file)
   at 
Microsoft.SqlServer.Management.RegisteredServers.RegisteredServersStore.InitializeLocalRegisteredServersStore()
   at 
Microsoft.SqlServer.Management.RegisteredServers.RegisteredServersStore.get_LocalFileStore()
   at 
Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnLoad(EventArgs 
e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   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.4241 (VistaSP2GDR.050727-4200)
    CodeBase: 
file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AppIDPackage
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
----------------------------------------
mscorlib.resources
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4241 (VistaSP2GDR.050727-4200)
    CodeBase: 
file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4235 (VistaSP2GDR.050727-4200)
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Microsoft.SqlServer.SqlTools.VSIntegration
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
----------------------------------------
Microsoft.VisualStudio.Shell.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.10.6071
    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.10.6070
    CodeBase: 
file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4236 (VistaSP2GDR.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.4235 (VistaSP2GDR.050727-4200)
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
SqlWorkbench.Interfaces
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
----------------------------------------
Microsoft.SqlServer.SqlTDiagM
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1447.4 ((KJ_RTM).100213-0103 )
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
----------------------------------------
Microsoft.SqlServer.Instapi
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
----------------------------------------
Microsoft.VisualStudio.Shell
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1826 (QFE.050727-1800)
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
----------------------------------------
Microsoft.VisualStudio.Shell.Interop.8.0
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.1826 (QFE.050727-1800)
    CodeBase: 
file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
----------------------------------------
Microsoft.SqlServer.Management.SDK.SqlStudio
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SDK.SqlStudio.DLL
----------------------------------------
SQLEditors
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL
----------------------------------------
Microsoft.VisualStudio.TextManager.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.10.6070
    CodeBase: 
file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
----------------------------------------
SqlMgmt
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
----------------------------------------
Microsoft.SqlServer.Management.UserSettings
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UserSettings.DLL
----------------------------------------
EnvDTE
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.1826 (QFE.050727-1800)
    CodeBase: 
file:///C:/Windows/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
----------------------------------------
Microsoft.SqlServer.Management.Sdk.Sfc
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1447.4 ((KJ_RTM).100213-0103 )
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Management.Sdk.Sfc/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.Sdk.Sfc.dll
----------------------------------------
Microsoft.SqlServer.Management.Reports
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Reports.DLL
----------------------------------------
ObjectExplorer
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
----------------------------------------
Microsoft.VisualStudio
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1826 built by: QFE
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
----------------------------------------
System.Drawing.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
----------------------------------------
Microsoft.VisualStudio.Designer.Interfaces
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.573
    CodeBase: 
file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll
----------------------------------------
ConnectionDlg
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
----------------------------------------
Microsoft.SqlServer.Management.Controls
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Controls.DLL
----------------------------------------
Microsoft.SqlServer.RegSvrEnum
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1447.4 ((KJ_RTM).100213-0103 )
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
----------------------------------------
Microsoft.SqlServer.Management.SqlStudio.Explorer
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: 
file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SqlStudio.Explorer.DLL
----------------------------------------
System.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4236 (VistaSP2GDR.050727-4200)
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
    CodeBase: 
file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Microsoft.NetEnterpriseServers.ExceptionMessageBox
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/10.0.0.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
----------------------------------------
Microsoft.SqlServer.ConnectionInfo
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1447.4 ((KJ_RTM).100213-0103 )
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
----------------------------------------
Microsoft.SqlServer.Management.RegisteredServers
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1447.4 ((KJ_RTM).100213-0103 )
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Management.RegisteredServers/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.RegisteredServers.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4246 (VistaSP2GDR.050727-4200)
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.SqlServer.SqlClrProvider
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1447.4 ((KJ_RTM).100213-0103 )
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlClrProvider/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlClrProvider.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4246 (VistaSP2GDR.050727-4200)
    CodeBase: 
file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.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.

//Tony



"Erland Sommarskog" <esquel@sommarskog.se> skrev i meddelandet 
news:XnsA2C4614B83F82Yazorman@127.0.0.1...
> Tony Johansson (johansson.andersson@telia.com) writes:
>> Do you think it's possible in any way to fix my problem without
>> reinstalling SQL Server 2008.
>
> Yes. First of all, in the SQL Server program group, there is the SQL 
> Server
> Installation Center (in the folder Configuration Tools). There is a Repair
> option.
>
> And obvioously, it is worth trying to rename that file to see what 
> happens.
>
> But don't forget to install the service pack.
>
>
> -- 
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Get Error when I start SQL Server Management Studio for SQL Server 2008 "Tony Johansson" <johansson.andersson@telia.com> - 2014-01-28 13:14 +0100
  Re: Get Error when I start SQL Server Management Studio for SQL Server 2008 Erland Sommarskog <esquel@sommarskog.se> - 2014-01-28 21:18 +0100
    Re: Get Error when I start SQL Server Management Studio for SQL Server 2008 Mark D Powell <Mark.Powell2@hp.com> - 2014-01-28 12:43 -0800
    Re: Get Error when I start SQL Server Management Studio for SQL Server 2008 "Tony Johansson" <johansson.andersson@telia.com> - 2014-01-28 23:31 +0100
      Re: Get Error when I start SQL Server Management Studio for SQL Server 2008 Erland Sommarskog <esquel@sommarskog.se> - 2014-01-29 08:33 +0000
        Re: Get Error when I start SQL Server Management Studio for SQL Server 2008 "Tony Johansson" <johansson.andersson@telia.com> - 2014-01-29 13:09 +0100
        Re: Get Error when I start SQL Server Management Studio for SQL Server 2008 "Tony Johansson" <johansson.andersson@telia.com> - 2014-01-29 14:04 +0100
        Re: Get Error when I start SQL Server Management Studio for SQL Server 2008 "Tony Johansson" <johansson.andersson@telia.com> - 2014-01-29 14:55 +0100
          Re: Get Error when I start SQL Server Management Studio for SQL Server 2008 suryasekhar4105@gmail.com - 2015-06-01 14:43 -0700
            Re: Get Error when I start SQL Server Management Studio for SQL Server 2008 Erland Sommarskog <esquel@sommarskog.se> - 2015-06-02 07:19 +0000
    Re: Get Error when I start SQL Server Management Studio for SQL Server 2008 rja.carnegie@gmail.com - 2014-01-28 16:27 -0800
      Re: Get Error when I start SQL Server Management Studio for SQL Server 2008 "Tony Johansson" <johansson.andersson@telia.com> - 2014-01-29 02:34 +0100

csiph-web