+ Post New Thread
Results 1 to 8 of 8
Windows Thread, MSSQL Instance won't remove in Technical; Hi I'm trying to remove a MSSQL 2005 Express instance from my server however when using ARP to uninstall this ...
  1. #1
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19

    MSSQL Instance won't remove

    Hi

    I'm trying to remove a MSSQL 2005 Express instance from my server however when using ARP to uninstall this it completes with no error but the instance is still listed in the "Select an instance" list under the "Microsoft SQL Server 2005 Uninstall" window. Also the MSSQL.1 folder is still present under "C:\Program Files\Microsoft SQL Server"

    I need to re-install this instance using the same name due to a problem so need to remove this first from the system before I attempt a re-install.

    Any ideas?

  2. #2
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    936
    Thank Post
    35
    Thanked 164 Times in 132 Posts
    Rep Power
    94
    The folder will always stay when you delete as the data files are not deleted when you remove an SQL server.

  3. Thanks to Mcshammer_dj from:

    randle (7th April 2010)

  4. #3

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,154
    Thank Post
    114
    Thanked 527 Times in 450 Posts
    Blog Entries
    2
    Rep Power
    123
    Have you tried this - How to uninstall an instance of SQL Server 2005 manually

    It gives details of how to manually remove the instance of SQL 2005

  5. #4
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    I have seen the article prior to starting this thread but doesn't appear to cover the problem I'm having as performing the "%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove" command just runs the same process as ARP and have done this but the instance is still shown in the list even after completing this.

  6. #5

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,154
    Thank Post
    114
    Thanked 527 Times in 450 Posts
    Blog Entries
    2
    Rep Power
    123
    Quote Originally Posted by randle View Post
    I have seen the article prior to starting this thread but doesn't appear to cover the problem I'm having as performing the "%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove" command just runs the same process as ARP and have done this but the instance is still shown in the list even after completing this.
    Have you gone all the way through that article? The arpwrapper bit is just the start - it seems to go into a mass of detail about finding GUIDs and removing stuff with MSICUU etc and looked pretty thorough!

  7. #6
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    I haven't tbh. I'm in the process of doing that right now as it goes.......Lazy

  8. #7
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    @jinnantonnix: I'm not able to connect to the instance in SQLSMSE to run a query. I've only had the occasional encounter with SQL so you'll have to be patient with me.

  9. #8
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    Found this site in the end which did the job. Tidied everything up nicely and installed a new instance over the top with no problems.

    Thanks for your time

SHARE:
+ Post New Thread

Similar Threads

  1. MSDE the instance name specified is invalid
    By timbo343 in forum Windows
    Replies: 8
    Last Post: 30th September 2010, 05:10 AM
  2. Link switch driver instance to a port? (Netgear)
    By pete in forum Wireless Networks
    Replies: 0
    Last Post: 23rd June 2009, 10:20 AM
  3. Replies: 2
    Last Post: 14th July 2008, 02:58 PM
  4. Replies: 3
    Last Post: 20th February 2008, 05:22 PM
  5. No Instance for WSUS in SQL service manager
    By petectid in forum Windows
    Replies: 1
    Last Post: 6th February 2007, 12:05 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •