How to Uninstall Multiple Database Instances of Microsoft SQL Server 2005

[Jasonholt]

Hello,
I have installed 2 different Multiple Database Instances on my Microsoft SQL 2005 Server and I want to remove onle of these instances, so if anyone cna help me out in removing one of this instances without affecting other instances it would be great. Thank you

[Zachary]

Step 1: Make sure that the Microsoft SQL Server Setup Support Files component is installed
In Add or Remove Programs, make sure that Microsoft SQL Server Setup Support Files appears in the list of installed programs. If Microsoft SQL Server Setup Support Files appears in the list, go to the "Step 2: Run the command to uninstall the SQL Server components" section.

If Microsoft SQL Server Setup Support Files does not appear in the list, install this component before you continue. To install this component, follow these steps:

1. Locate the original SQL Server 2005 installation media.
2. To install the support files, double-click the Servers\setup\sqlsupport.msi file.

Note: In the "Step 5: Uninstall the Microsoft SQL Server Setup Support Files component" section, you uninstall this component.

For more information refer to this Micorsoft kb909967.

[Janos™]

• Login to the server with an administrator user account, or SQL Server 2005 service account.
• Stop all active SQL Server services in Services applet in Control Panel as any active connections may prevent the uninstallation process from finishing successfully.
• Go to Control Panel and then Add or Remove Programs applet.
• Search and verify that Microsoft SQL Server Setup Support Files appears in the list of installed programs. If it’s found, proceed to next step. If Microsoft SQL Server Setup Support Files component is not listed as one of the installed program, install the component by running sqlsupport.msi file locates in Servers\setup\ folder of the original SQL Server 2005 installation media, or disc, folder and USB flash drive that contains SQL Server 2005 setup files.
• Open command prompt (in Vista, use command prompt with administrator rights), and run the following command to uninstall the SQL Server components:

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove

• Uninstall the SQL Server instance components such as database engine one at a time.

• Once the removal completes, repeat all of the above steps again until all the SQL Server components are uninstalled.
• Finally, uninstall the Microsoft SQL Server Setup Support Files component by using Add or Remove Programs (It should has been removed, but double check to ensure that).

Source: mydigitallife

[Big Fish]

Did you try add/remove programs (or programs and features if you are on vista)? Click the "Show updates" checkbox.