Results 1 to 4 of 4

Thread: How to Uninstall Multiple Database Instances of Microsoft SQL Server 2005

  1. #1
    Join Date
    Sep 2005
    Posts
    229

    How to Uninstall Multiple Database Instances of Microsoft SQL Server 2005

    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

  2. #2
    Join Date
    Jan 2006
    Posts
    4,221

    Re: How to Uninstall Multiple Database Instances of Microsoft SQL Server 2005

    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.

  3. #3
    Join Date
    Jan 2006
    Posts
    605

    Re: How to Uninstall Multiple Database Instances of Microsoft SQL Server 2005

    • 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

  4. #4
    Join Date
    Jan 2006
    Posts
    3,792

    Re: How to Uninstall Multiple Database Instances of Microsoft SQL Server 2005

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

Similar Threads

  1. How to connect multiple PCs to sql 2005 database
    By Operatorr in forum Networking & Security
    Replies: 5
    Last Post: 03-01-2011, 07:48 PM
  2. Access database upgrade to SQL Server 2005
    By Umberto-Micro in forum Software Development
    Replies: 4
    Last Post: 13-02-2010, 12:16 AM
  3. How to restore database in SQL Server 2005
    By Mahendra varma in forum Software Development
    Replies: 3
    Last Post: 02-05-2009, 01:10 PM
  4. Replies: 3
    Last Post: 20-02-2009, 02:33 AM
  5. Replies: 5
    Last Post: 25-10-2007, 07:58 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,689,387.58023 seconds with 17 queries