Can''t reinstall sql virtual server

  • I had active/active sql server cluster running on two nodes. All worked perfectly. For some purposes I needed to reinstall these 2 sql server instances. I have run setup cd to uninstall these virtual servers and removed them sucessfully. I followed microsoft recommendations how to uninstall sql instance

    http://support.microsoft.com/default.aspx?scid=kb;en-us;290991&sd=tech

    Maybye I've done some steps not in order, but when I try to install new sql virtual server I get always the same error:

    "COMPUTER,"The description for Event ID ( 17055 ) in Source ( MSSQL$SERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and

    Support for details. "

    This is not exact error, because I'm writing from my home, but it sounds very similar. Tomorrow from my job place I will detail these errors more further

    Is there any other way to fix this problem without reinstalling my server OS? If not I'm dead

    Any help would be very appreciate

  • Check for any references to the old instance in the registry and try deleting them.

  • Hello, sa24

    Do you mean I  must delete these :

    Locate, and then delete the %drive%:\Program Files\Microsoft SQL Server\MSSQL\Binn folder

    and registries:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer$InstanceName

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT$InstanceName

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper

    If so it doesn't help. My installation with the same name fails

  • Detailed errors:

    The description for Event ID ( 17055 ) in Source ( MSSQL$INST1 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 17052, Recovery complete.

    The description for Event ID ( 17055 ) in Source ( MSSQL$INST1 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 17834, Using 'SSNETLIB.DLL' version '8.0.194'.

    The description for Event ID ( 17055 ) in Source ( MSSQL$INST1 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 17658, SQL Server started in single user mode. Updates allowed to system catalogs.

    The description for Event ID ( 17055 ) in Source ( MSSQL$INST1 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 17125, Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.

    And so on.

    If does it say anyone something please let me know

     

  • Well, hi again Did you reboot both nodes after uninstalling each of the instances or did you uninstall right after each other and did not boot at all yet?

    Another search is probably in the cluster administrator. Check if the virtual resources are deleted.

    These are just hunches, I did not encounter these error's.

  • Finally it works again!

    Yes I think that my both servers where rebooted in tens times. Don't as me what concrete I've done, you wouldn't get an answer  because I don't know. I can only guess that removing registries and installing a local copy of sql server with the same named instance name and then removing it helped me to install a clear virtual server instance.

    Thanks c70070540 for your attention! I hope you are not tired of me and my "cluster"

  • Not only the entries above but you might want to search for all the entries for the virtual name and delete them all.

Viewing 7 posts - 1 through 6 (of 6 total)

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