Monday, May 2, 2016

Uninstall of SQL fails with error about RsFx Driver


I was working on uninstalling installations of SQL 2012 and SQL 2008 R2 to later do a clean install of SQL 2012. All seems to be going relatively smooth until I encountered the following message:
Warning 26003. Microsoft SQL Server 2008 R2 Setup 
Support Files cannot be uninstalled because the 
following products are installed: 
Microsoft SQL Server 2008 R2 RsFx Driver

Understandable; So I will uninstall using Control Panel\Programs\Programs and Features (Add/Remove for the old school). However the item wasn’t listed. After searching on how to do this using the registry I found a simpler way, I am now calling it a clean and supported way to doing this.
Steps to correct this issue:
We need to obtain the product GUID from WMI using WMIC so that we can use the MSIEXEC /X {GUID} command to remove the software.
Open a command prompt as administrator and type: WMIC PRODUCT LIST to get a list of products and the GUID associated with them. I found using the following command works best: WMIC PRODUCT GET Caption, IdentifyingNumber > c:\info.txt 

Once you have the GUID of the software you want to uninstall you simply type: MSIEXEC /X {GUID}
Software is now uninstalled and you can proceed.
*note* the steps provided can be used for any software you are looking to uninstall that is not listed under Add/Remove programs. Just follow the steps as such:
  1. Get the product GUID from WMI (Win32_Product class)
  2. Find the GUID related to the product or products that the SQL error mentions
  3. Run MSIEXEC /X {GUID} for each of the products to uninstall them manually.

10 comments:

  1. Thanks for sharing the very useful info about SQL Server and please keep updating........

    ReplyDelete
  2. This is an best post. It is Really very informative concept.I like it and help me to development very well.Thanks alot for this brief explanation and very nice information.BEST SQl Server Training In Hyderabad

    ReplyDelete
  3. thank your valuable content.we are very thankful to you.one of the recommanded blog.which is very useful to new learners and professionals.content is very useful for hadoop learners


    Best Spring Classroom Training Institute
    Best Devops Classroom Training Institute
    Best Corejava Classroom Training Institute
    Best Oracle Classroom Training Institute
    Best Oracle Classroom Training Institute

    ReplyDelete
  4. Thank your valuable content.we are very thankful to you.one of the recommended blog.which is very useful to new learners and professionals.content is very useful for hadoop learners


    Best Spring Online Training Institute
    Best Devops Online Training Institute
    Best Datascience Online Training Institute
    Best Oracle Online Training Institute
    Best Sql server Online Training Institute

    ReplyDelete
  5. Thanks For Sharing The Information The Information Shared Is Very Valuable Please Keep Updating Us Time Just Went On Reading The article sql server Online Course

    ReplyDelete
  6. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Worthful Sql server tutorial. Appreciate a lot for taking up the pain to write such a quality content on SQL server tutorial. Just now I watched this similar sql server Online Course

    ReplyDelete
  7. This is very helping information thanks for sharing such information if any one willing to learn SQL Server Database Training in Delhi

    ReplyDelete
  8. I just wanted to give a genuine thank you, since it seems every other comment was created by a bot.... You actually really truly helped me and I'm grateful.

    ReplyDelete
  9. Here is the best music to calm and relax your mind

    1. best relaxing music
    2. best Depp sleep music
    3. best meditation music
    4. best calm music
    5. best deep focus music

    ReplyDelete
  10. Your blog post is very useful to me. Thank you for sharing this blog post.
    SQL Server Training in Hyderabad

    ReplyDelete