Post reply

Previously registered servers awol

  • June 4, 2013 at 3:15 am

    #394902

    Hi all,

    Wondered if anyone could assist?

    I've logged on to one of my SQL Server 2008 R2 instances and have received the following message:

    TITLE: Registered Servers

    ------------------------------

    Unable to read the list of previously registered servers on this system. Re-register your servers in the 'Registered Servers' window.

    ------------------------------

    ADDITIONAL INFORMATION:

    Serialization output is invalid. (Microsoft.SqlServer.Management.Sdk.Sfc)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.5500.0+((Katmai_PCU_Main).110922-0336+)&LinkId=20476

    ------------------------------

    'None' is an invalid XmlNodeType. Line 7, position 9. (System.Xml)

    The 'help' link in the additional information directs to another message basically saying there's no additional information available! so I had a look at BOL and could only find one reference to this issue but it's to do with upgrading from SQL 2005. My instance has been running 2008 for easily 2-3 years now!! The instructions (http://support.microsoft.com/kb/955648) advise to open SSMS, open registered servers window, expand the Database Engine node, R/Click Local Server Groups, point to tasks and click Previously Registered Servers..... this would be great but my instance isn't displaying anything under any of the nodes (Database Engine, Analysis Services, Reporting Services etc etc).

    I can still view the DB's in object explorer but can't query any of the databases using T-SQL (even system stored procedures!), I get the following error:- 'An error occurred while executing batch. Error message is: The directory name is invalid.'

    Can anyone suggest anything please as I'm royally stumped.

    MCITP
    MCTS - E-Business Card
    Twitter: WWDMark

    Try not! Do or do not, there is no try

    email: info@weekendwebdesign.co.uk
    Personal Website: http://markallen.co.uk/
    Business Website: https://www.weekendwebdesign.co.uk

  • June 4, 2013 at 5:06 am

    #1620874

    It looks like a file on your local harddisk has become corrupt. Check the files in the following location:

    %appdata%\Microsoft\Microsoft SQL Server\100\Tools\ShellIt might help if you copy the ..\90\Tools\Shell folder to the ..\100\Tools\Shell folder.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply