none
SQL server Uninstallation

    Question

  • Hi,

    we are trying to uninstall the SQL service on 4 production server and we are not able to uninstall the services we are getting errors

    Server Number 1 Error : Attributes do not match. Present attributes (Directory, Compressed)

    Server Number 2 Error : Some of the MSI is missing in windows installer but i have checked the log in Bootstrap and i have created MSI file manually and i tried again its not able to uninstall.

    server Numer 3 Error : MSSQL10_50.DEVSQL' is not a valid short file name. 

    Thursday, April 13, 2017 4:17 PM

All replies

  • I would probably try to run a repair on that instance of SQL Server and then try the uninstall again if it gets repaired successfully.  Those errors sound like something is highly screwed up with your SQL Installation.


    • Edited by sbogar Thursday, April 13, 2017 4:26 PM
    Thursday, April 13, 2017 4:26 PM
  • Hi,

    I have tried to repair the SQL server but its also got failed, If any other solution to remove SQL service 

    Regards, 

    karthik

    Thursday, April 13, 2017 4:58 PM
  • Hello,


    You can use below article to manually uninstall SQL Server:

    http://www.sqlcoffee.com/Tips0026.htm


    Alternatively, you can also use instructions provided on below article:

    http://jermsmit.com/uninstall-of-sql-fails-with-error-about-rsfx-driver/


    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, April 13, 2017 5:09 PM
    Moderator
  • Hello,

    You have take registry backup then changes in registry.Refer following article.

    https://dba.stackexchange.com/questions/68373/how-to-uninstall-sql-server-2012-not-showing-in-control-panels-programs-and-fe


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    Thursday, April 13, 2017 8:42 PM
  • HI,

    When i was uninstalling SQL service its showing below browse option but in setup file SyncServiceADO_x86_ENU.msi is not available. But in setup file only SyncServiceADO.msi available if i choosethe msi again 

    Friday, April 14, 2017 3:09 AM
  •  find file in local system and browse path SyncServiceADO_x86_ENU.msi.

     otherwise download following file using following link

    https://www.microsoft.com/en-in/download/details.aspx?id=5783

    try uninstall from path.


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    Friday, April 14, 2017 3:24 AM
  • HI

    I have installed and browsed the file and map the location but again its giving the same message. After i cancel the browses every this got failed. I am not able to uninstall.

    Friday, April 14, 2017 4:16 AM
  • Hello,

    can check msi files in server using following link

    https://support.microsoft.com/en-in/help/969052/how-to-restore-the-missing-windows-installer-cache-files-and-resolve-problems-that-occur-during-a-sql-server-update


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    Friday, April 14, 2017 4:20 AM
  • why did the repair fail?

    c:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log will help you out

    • Edited by sbogar Friday, April 14, 2017 2:40 PM
    Friday, April 14, 2017 2:40 PM
  • Hi All,

    I have fixed the issue after checked the error log in setup Boostrap. i have done one by one un-installation.

    First it got failed then i check log some of the MSP files are missing in windows installer folder then i have extract the SQL server 2008 R2 service pack and i picked the required MSP file and rename the MSP file in windows installer folder then i have tried to uninstall the services. It successfully uninstalled the SQL services.

    Regards,

    karthik B 

    Friday, April 14, 2017 9:52 PM