Registered Server window does not show Database Engine or Local Server Groups

Problem

I am running SQL Server Management Studio 2012 on a Windows 7 machine. After a failed attempt to import my registred servers from SSMS 2008, the icons for Database Engine and Local Server Groups are not displayed in the Registered Servers window: the Registred Servers window is empty.

As such I cannot register a server from the SSMS GUI, by right clicking the Local Server Groups.

How can I restore the Database Engine and Local Server Groups items?

Solution

In the folder %APPDATA%\Microsoft\Microsoft SQL Server\110\Tools\Shell you should find a file named RegSrvr.xml. That's the file where Management Studio stores local registered servers. If the file is missing or corrupt, SSMS won't display anything.

In this case, you can create a new file and paste this:

```

urn:uuid:96fe1236-abf6-4a57-b54d-e9baab394fd1
http://documentcollection/

/system/schema/RegisteredServers

/RegisteredServersStore

/RegisteredServersStore/ServerGroup/AnalysisServicesServerGroup

/RegisteredServersStore/ServerGroup/CentralManagementServerGroup

/RegisteredServersStore/ServerGroup/DatabaseEngineServerGroup

/RegisteredServersStore/ServerGroup/IntegrationServicesServerGroup

/RegisteredServersStore/ServerGroup/ReportingServicesServerGroup

/RegisteredServersStore/ServerGroup/SqlServerCompactEditionServerGroup

/RegisteredServersStore/ServerGroup/AnalysisServicesServerGroup

/RegisteredServersStore

AnalysisServicesServerGroup
AnalysisServices

/RegisteredServersStore/ServerGroup/CentralManagementServerGroup

/RegisteredServersStore

CentralManagementServerGroup
DatabaseEngine

/RegisteredServersStore/ServerGroup/DatabaseEngineServerGroup

/RegisteredServersStore

DatabaseEngineServerGroup
DatabaseEngine

/RegisteredServersStore/ServerGroup/IntegrationServicesServerGroup

/RegisteredServersStore

IntegrationServicesServerGroup
IntegrationServices

/RegisteredServersStore/ServerGroup/ReportingServicesServerGroup

/RegisteredServersStore

ReportingServicesServerGroup
ReportingServices

/RegisteredServersStore/ServerGroup/SqlServerCompactEditionServerGroup

Code Snippets

<?xml version="1.0"?>
<model xmlns="http://schemas.serviceml.org/smlif/2007/02">
  <identity>
    <name>urn:uuid:96fe1236-abf6-4a57-b54d-e9baab394fd1</name>
    <baseURI>http://documentcollection/</baseURI>
  </identity>
  <xs:bufferSchema xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <definitions xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08">
      <document>
        <docinfo>
          <aliases>
            <alias>/system/schema/RegisteredServers</alias>
          </aliases>
          <sfc:version DomainVersion="1" />
        </docinfo>
        <data>
          <xs:schema targetNamespace="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
            <xs:element name="RegisteredServersStore">
              <xs:complexType>
                <xs:sequence>
                  <xs:any namespace="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08" processContents="skip" minOccurs="0" maxOccurs="unbounded" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="ServerGroup">
              <xs:complexType>
                <xs:sequence>
                  <xs:any namespace="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08" processContents="skip" minOccurs="0" maxOccurs="unbounded" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <RegisteredServers:bufferData xmlns:RegisteredServers="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08">
              <instances xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08">
                <document>
                  <docinfo>
                    <aliases>
                      <alias>/RegisteredServersStore</alias>
                    </aliases>
                    <sfc:version DomainVersion="1" />
                  </docinfo>
                  <data>
                    <RegisteredServers:RegisteredServersStore xmlns:RegisteredServers="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/XMLSchema">
                      <RegisteredServers:ServerGroups>
                        <sfc:Collection>
                          <sfc:Reference sml:ref="true">
                            <sml:Uri>/RegisteredServersStore/ServerGroup/AnalysisServicesServerGroup</sml:Uri>
                          </sfc:Reference>
                          <sfc:Reference sml:ref="true">
                            <sml:Uri>/RegisteredServersStore/ServerGroup/CentralManagementServerGroup</sml:Uri>
                          </sfc:Reference

Context

StackExchange Database Administrators Q#96305, answer score: 4

Revisions (0)

No revisions yet.