Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Sql Server Management Studio 2008 (MSSQL 2008) problem.

Proposed Answer Sql Server Management Studio 2008 (MSSQL 2008) problem.

  • Monday, November 23, 2009 2:55 PM
     
      Has Code
    Sign In to Vote
    0
    I have a problem with SQL Database and managing of them. I have a VS2010 VWD EE (Beta 2). And SQL Server Express Edition 2008. Now I have a problem with this:
    TITLE: Registered Servers
    
------------------------------
    
Unable to read the list of previously registered servers on this system. Re-register your servers in the 'Registered Servers' 
    
window.
    
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1312.2+((dac_stab2).090829-0704+)
    
&LinkId=20476
    
------------------------------
    
ADDITIONAL INFORMATION:
    
Deserialization operation on /RegisteredServersStore/ServerGroup/DatabaseEngineServerGroup has failed. 
    
(Microsoft.SqlServer.Management.Sdk.Sfc)
    
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1312.2+((dac_stab2).090829-0704+)
    
&LinkId=20476
    
------------------------------
    
There is an error in XML document (0, 0). (System.Xml)
    
------------------------------
    
The type initializer for 'System.Xml.Serialization.XmlSerializationReader' threw an exception. (System.Xml)
    
------------------------------
    
Configuration system failed to initialize (System.Configuration)
    
------------------------------
    
Unrecognized configuration section system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config 
    
line 136) (System.Configuration)
    
------------------------------
    
BUTTONS:
    
OK
    
------------------------------
    When I press Ok button it shows me another dialog: 
    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.Sdk.Sfc.SfcSerializationException: Serialization operation on ServerGroup[@Name='DatabaseEngineServerGroup'] has failed. ---> System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException: Unrecognized configuration section system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 136)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
   at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
   at System.Configuration.BaseConfigurationRecord.ThrowIfInitErrors()
   at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)
   --- End of inner exception stack trace ---
   at System.Configuration.ConfigurationManager.PrepareConfigSystem()
   at System.Configuration.ConfigurationManager.GetSection(String sectionName)
   at System.Configuration.PrivilegedConfigurationManager.GetSection(String sectionName)
   at System.Diagnostics.DiagnosticsConfiguration.GetConfigSection()
   at System.Diagnostics.DiagnosticsConfiguration.Initialize()
   at System.Diagnostics.DiagnosticsConfiguration.get_SwitchSettings()
   at System.Diagnostics.Switch.InitializeConfigSettings()
   at System.Diagnostics.Switch.InitializeWithStatus()
   at System.Diagnostics.Switch.get_SwitchSetting()
   at System.Diagnostics.BooleanSwitch.get_Enabled()
   at System.Xml.Serialization.TempAssembly.LoadGeneratedAssembly(Type type, String defaultNamespace, XmlSerializerImplementation& contract)
   at System.Xml.Serialization.XmlSerializer..ctor(Type type, String defaultNamespace)
   at System.Xml.Serialization.XmlSerializer..ctor(Type type)
   at Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.WriteInternal(XmlWriter instanceWriter, Object instance, Dictionary`2 namespaces)
   at Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.Write(XmlWriter instanceWriter, Object instance, Dictionary`2 namespaces)
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.Write(XmlWriter instanceWriter, Object instance, Dictionary`2 namespaces)
   at Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.WriteAllInstances()
   at Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.Write(XmlWriter xmlWriter)
   at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServersStore.Serialize()
   at Microsoft.SqlServer.Management.RegisteredServers.ServerGroup.Create()
   at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServersStore.get_DatabaseEngineServerGroup()
   at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerControl.RegisteredServerControl_Load(Object sender, EventArgs e)
   at System.Windows.Forms.UserControl.OnLoad(EventArgs e)
   at System.Windows.Forms.UserControl.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.UserControl.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.3053 (netfxsp.050727-3000)
    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
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    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.3053 (netfxsp.050727-3000)
    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.3053 (netfxsp.050727-3000)
    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.1312.2 ((dac_stab2).090829-0704 )
    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
----------------------------------------
Microsoft.SqlServer.Management.Sdk.Sfc
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1312.2 ((dac_stab2).090829-0704 )
    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
----------------------------------------
Microsoft.SqlServer.Management.RegisteredServersUI
    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.RegisteredServersUI.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
----------------------------------------
System.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
Microsoft.SqlServer.Management.RegisteredServers
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1312.2 ((dac_stab2).090829-0704 )
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Management.RegisteredServers/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.RegisteredServers.dll
----------------------------------------
Microsoft.SqlServer.ConnectionInfo
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1312.2 ((dac_stab2).090829-0704 )
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.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
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    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.1312.2 ((dac_stab2).090829-0704 )
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlClrProvider/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlClrProvider.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.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
----------------------------------------
System.Web
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.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.
    And in Label it's shows:
    "Serialization operation on
    ServerGroup[@Name='DatabaseEngineServerGroup'] has failed.
    Then I can Log-In into database, and do just half work.

    I have installed: MS Framework 2.0, 3.5, 4.0. I am using MS Windows XP SP2.  It makes me crazy. Everything running okay but just this application have problems.
     

All Replies

  • Monday, November 23, 2009 3:09 PM
     
     
    Sign In to Vote
    0

    Error message when you start SQL Server Management Studio in SQL Server 2008: "Unable to read the list of previously registered servers on this system"

     

    http://support.microsoft.com/kb/955648

     
  • Monday, November 23, 2009 5:21 PM
     
     
    Sign In to Vote
    0
    Here is one more solution of this issue: http://www.devnewsgroups.net/sqlservertools/t67445-ssms-2008-registered-server-problem.aspx

    ---
    Paul Svirin
    StarWind Software developer ( http://www.starwindsoftware.com )
     
  • Monday, November 23, 2009 8:13 PM
     
     
    Sign In to Vote
    0
    To Paul : Thanks guys, but I don't have Windows Vista, I am on Win XP (Administrator account) so it doesn't have anything about permissions but I can try to remove this temporaries.
    To Chirag:     I have seen but when I do it, it doesn't show any window, so I can't do it.
     
  • Monday, November 23, 2009 10:26 PM
     
     
    Sign In to Vote
    0

    This happens because XML file from which SQL reads server registration info is missing or corrupt

    Not sure which window you are talking about


    1.Start SQL Server Management Studio.
    2.Press CTRL+ALT+G to open the Registered Servers window.
    3.Expand the Database Engine node.
    4.Update Previously Registered Servers


    Of course,

    You can always create  a new server registration by re-registering them

     
  • Tuesday, November 24, 2009 2:25 PM
     
     
    Sign In to Vote
    0
    One more time I say:
     "When I press Ctrl + Alt + G or Menu -> View -> Registered Server, it doesn't show anything."
     
  • Saturday, November 28, 2009 2:12 PM
     
     
    Sign In to Vote
    0
    Nothing guys?
     
  • Thursday, January 07, 2010 4:57 PM
     
     Proposed Answer
    Sign In to Vote
    0
    I'm having the exact issue. Same environment. I've been browsing the internet for a solution for a couple of days and haven't seen a resolution yet. I've completely uninstalled everything SQL Server and DOT NET related and reinstalled and still have the same issue. The registered servers tab generates the error and after clicking continue there is nothing in the registered servers tab.

    There have been serveral postings on various sites but no solutions that I've found yet.


    Sorry laik1458 that I dont have more but you're definately not alone on this.
    • Proposed As Answer by csatola Thursday, February 18, 2010 2:22 PM
    •  
     
  • Thursday, February 18, 2010 2:25 PM
     
     Proposed Answer
    Sign In to Vote
    1
    Oops - I clicked the wrong button and proposed an answer - sorry about that...

    Anyway, here's the steps I took that fixed it:

    1. Gave "everyone" rights to the C:\Windows\Temp folder
    2. Ran SSMS as administrator
    3. Click "View > Registered Servers"
    4. Right click on "Local Server Groups" and select "Tasks > Register Local Servers"
    5. Close and reopen SSMS as normal user - no errors

    Hope this helps others.
     
  • Wednesday, March 17, 2010 8:43 PM
     
     
    Sign In to Vote
    0

    I caused this a bug pretty much exactly like this one by deleting all files in my C:\Documents and Settings\MYUSERID\Local Settings\Temp\ directory. 

    Foolish me, that I thought that would be safe to do!

    Thanks to the earlier poster csatola for their advice which I modified to solve my issue also.

    I gave "everyone" Full Control rights to that folder and reran SSMS as per the earlier poster's steps 1,2,3 and the issue went away.   (I didn't actually need to do steps 4+5).

    The following is relevant only for understanding the root cause and/or others' related issues.  When the issue went away, I noticed that a subdirectory named "2" was created in the Temp directory but saw it was empty.  I tried removing "Everyone"'s rights to the TEMP folder and the problem stayed fixed.  I then thought to try clicking Start->Run->%TEMP% and discovered that my %TEMP% variable was set by my IT department to C:\Documents and Settings\MYUSERID\Local Settings\Temp\2\, so I had apparently caused the issue by deleting my true %TEMP% folder.

     
  • Tuesday, December 28, 2010 8:13 AM
     
     
    Sign In to Vote
    0
    Dear All,

    SQL Server Management Studio for 2008 was creating problems during the installation. What i did was i disabled the key for SQL Server 2005 (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90) to (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90_0) and installed Microsoft Visual Studio 2008 Service Pack 1 (Installer) from microsoft.com and it worked perfectly. :)

    Regards,
    Syed Mujtaba Ahmed Razvi
     
  • Thursday, March 17, 2011 5:44 PM
     
     
    Sign In to Vote
    0

    I am running Server 2008 R2 and SQL Server 2008 R2. I didn't alter the rights to the Temp folder. I just ran SSMS as Administrator and all was good.

     
  • Thursday, April 21, 2011 8:03 PM
     
     Proposed Answer
    Sign In to Vote
    3

    When I am trying to login to SSMS and Import “Previously registered Servers” Using “regsrvr.xml” file or “*.regsrv” export file, I got the below error:

    Microsoft .NET Framework:

    Unhandled exception has occured in a component in your application. If you click continue, the application will ignore this error and attempt to continue.

    Key not valid for use in specified state

    Buttons: Details and Continue.

    After this error, every time I login to SSMS, it prompts me this message box, If I hit continue it will allow me to login to the server but not to register any new server or see any existing server

    I searched online in lot of blogs but did not get the accurate solutions.

    You can try the below steps to resolve this issue

    1.      Copy this on your windows explorer: %APPDATA%\Microsoft\Microsoft SQL Server\100\Tools\Shell\ this will prompt you to the directory: C:\Users\User_Name\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell

    2.      Delete “windows.prf” & “windowsidx.prf”

    3.      Move the old “regsrvr.xml” file

    4.      Try to login to SSMS

    5.      You won’t see this error and also, you can try to registered the servers from scratch


    • Proposed As Answer by tmw_DBA Wednesday, February 01, 2012 12:49 AM
    •  
     
  • Monday, March 19, 2012 9:39 AM
     
     
    Sign In to Vote
    0

    If you are using windows XP I have a solution,it worked for me :) :)

    Go to path:

    %windir%\Documents and Settings\username\Local Settings\Application Data\Microsoft_Corporation\somefolder\x.xx.xx.xx\user.conig

    You will find either that file is corrupted or totally blank

    paste the below content [please replace somefolder with your machine's folder name]

     

    <?xml version="1.0" encoding="utf-8"?>

    <configuration>

        <configSections>

            <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >

                <section name="Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />

            </sectionGroup>

        </configSections>

        <userSettings>

            <Microsoft.SqlServer.Configuration.somefolder.Properties.Settings>

                <setting name="WindowPlacement" serializeAs="Xml">

                    <value>

                        <WINDOWPLACEMENT xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                            xmlns:xsd="http://www.w3.org/2001/XMLSchema">

                            <showCmd>1</showCmd>

                            <ptMinPosition>

                                <x>0</x>

                                <y>0</y>

                            </ptMinPosition>

                            <ptMaxPosition>

                                <x>-1</x>

                                <y>-1</y>

                            </ptMaxPosition>

                            <rcNormalPosition>

                                <left>0</left>

                                <top>0</top>

                                <right>800</right>

                                <bottom>600</bottom>

                            </rcNormalPosition>

                        </WINDOWPLACEMENT>

                    </value>

                </setting>

            </Microsoft.SqlServer.Configuration.somefolder.Properties.Settings>

        </userSettings>

    </configuration>


    • Edited by PingdKing Monday, March 19, 2012 9:41 AM some wrong text was there
    •  
     
  • Wednesday, November 21, 2012 11:22 PM
     
     
    Sign In to Vote
    0

    Thanks Parthik Parikh, your solution actually worked; I don't see the 'Propose As Answer' link though, at the bottom, on it.
     
  • Friday, March 29, 2013 4:42 AM
     
     
    Sign In to Vote
    0

    Guys,

    I had a similar error as the 1st post, but when i tried to open SSMS and it complained that it could not find the files in a specific temp folder located here "C:\Users\Administrator\AppData\Local\Temp". I checked this location and the folder mentioned in the detail of the error message was missing, it was supposed to contain folders named "2" and "3" but my "3" folder was missing.

    I eventually figured out that the RDP session was removing it.

    There are some settings on the RDP Host to remove temp folders on exit, so i unchecked this. Then i opened SSMS as Administrator to use the Ctrl + Alt + G as suggested here and in the KB article (http://support.microsoft.com/kb/955648), re-registered my SQL Server, saved, exited, logged off and then back on again and it was all fine.

    Thanks,

    Rich.