none
Attempts to install SQL Server 2008 R2 SP2 fails, many missing MSI and MSP files

Answers

  • Hi Sean, did you try to run repair for the existing SQL Server 2008 instance?  And are you trying to upgrade the existing instance or install a new 2008 R2 instance?

    Thanks,
    Sam Lester (MSFT)


    http://blogs.msdn.com/b/samlester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    • Marked as answer by SSAS is Fun Tuesday, October 29, 2013 1:19 PM
    Friday, October 25, 2013 1:32 PM
    Moderator
  • Hello,

    About the MSIs just put the media on the D drive on the same path, run the VB script and it will recreate all those MSI on the Windows\Installer with the appropriate names (908dea.msi, 908f13.msi, etc.).

    About the MSPs, I am not sure to remember well but the script tries to reach the MSIs on temp folders and then if not found on the original media. I don’t remember to have manipulated MSPs.

    If this is an important production server and this is the first time you try this procedure, try to call Microsoft Support and contact a guy named Gagan Hiremath. I hope they take the case because when cached files have been deleted the server is considered on a not supported state, if they take it will be on a best effort basis.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com


    Friday, October 25, 2013 3:29 PM
    Moderator
  • Albert and Sam, Both of your suggestions helped me with the final solution.  I was able to upgrade to SP2 yesterday.    I ran the findsql script repeatedly after restoring some of the files.   Also, I was able to restore enough of the files in the windows installer directory to be able to run the repair with the original installation media.   That then restored a few more of the files.     4 or the MSPs I could not copied into the installer directory because they were in use.

    One thing to note is that the SP2 installation still pointed to some of the files that I had already copied, they were all MSIs and I was able to point them to the extracted Service Pack 1 installation files location.

    Whew...

    Tuesday, October 29, 2013 1:23 PM

All replies

  • Hi Sean, did you try to run repair for the existing SQL Server 2008 instance?  And are you trying to upgrade the existing instance or install a new 2008 R2 instance?

    Thanks,
    Sam Lester (MSFT)


    http://blogs.msdn.com/b/samlester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    • Marked as answer by SSAS is Fun Tuesday, October 29, 2013 1:19 PM
    Friday, October 25, 2013 1:32 PM
    Moderator
  • Hello,

    The best way to do this is to download the original media (ISO, Service Pack) and put it exactly where the FindSQLInstall.vbs is telling you it was located. Run that VB script again and it will copy the MSI/MSP files on the Windows Installer cache and with the names (it will rename original MSI files) required.


    Hope this helps.
    Regards,
    Alberto Morillo
    SQLCoffee.com

    Friday, October 25, 2013 1:37 PM
    Moderator
  • Hi Sam,

    Thank you for your reply.   I did try to run a repair but that was using the SP1 and SP2 software.   I will see if I can run from the original software via the program files start menu item.    I am trying to upgrade the instance to 2008 R2 SP2.   The current version is below.

    select @@version

    Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)   Jun 17 2011 00:54:03   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    I will let you know the results of your suggestion.

    Sean

    Friday, October 25, 2013 2:57 PM
  • Alberto,

    Thank you for your reply.   I will try that.  I didn't know the vbs would copy the files for me.  Some of the locations will be easier to restore than the others. Do you know if the folders like "e:\1ec986b2510fb9dd1a79e895963473" below would have been created during the install?   I am not sure how I would figure out restoring a folder like that, the folder name looks generated. Below are the missing msi and msp btw.

    --Need the MSIs
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\x64\setup\sql_bids.msi" C:\Windows\Installer\908dea.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi" C:\Windows\Installer\908f13.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\SQLServerBestPracticesPolicies.msi" C:\Windows\Installer\908c71.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\SQLServerBOL.msi" C:\Windows\Installer\908c69.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\x64\setup\sql_fulltext.msi" C:\Windows\Installer\908f23.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\sql_engine_core_shared_loc_msi\sql_engine_core_shared_loc.msi" C:\Windows\Installer\908ed3.msi
    Copy "C:\Users\XX\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\ZP8PHNBR\PowerPivot_for_Excel_amd64.msi" C:\Windows\Installer\15750822.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\sql_tools_loc.msi" C:\Windows\Installer\908ef7.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\sqlbrowser.msi" C:\Windows\Installer\908f02.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\SSCESqlWbTools.msi" C:\Windows\Installer\908c59.msi
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\sqlsupport_msi\sqlsupport.msi" C:\Windows\Installer\908f67.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\sql_engine_core_inst_loc_msi\sql_engine_core_inst_loc.msi" C:\Windows\Installer\908f1b.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\sql_ssms_loc.msi" C:\Windows\Installer\908eee.msi
    Copy "C:\Users\Administrator\Downloads\SharedManagementObjects.msi" C:\Windows\Installer\ef74d66.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\sql2008support\sqlsupport.msi" C:\Windows\Installer\908d5e.msi
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\x64\sqlncli.msi" C:\Windows\Installer\908fa7.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\x64\setup\sql_engine_core_shared_msi\sql_engine_core_shared.msi" C:\Windows\Installer\908d71.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\x64\setup\sql_tools.msi" C:\Windows\Installer\908ec3.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\sql_common_core_loc_msi\sql_common_core_loc.msi" C:\Windows\Installer\908ecb.msi
    Copy "C:\Users\XX\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\YGP575UV\SQLServer2012_PerformanceDashboard.msi" C:\Windows\Installer\aaf13ec9.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\sql_bids_loc.msi" C:\Windows\Installer\908ee4.msi
    Copy "e:\1ec986b2510fb9dd1a79e895963473\x64\setup\rsfx.msi" C:\Windows\Installer\909345.msi
    Copy "C:\Users\Administrator\Downloads\SQLSysClrTypes.msi" C:\Windows\Installer\908c89.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\1033_ENU_LP\x64\setup\x64\SqlWriter.msi" C:\Windows\Installer\908c61.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\x64\setup\sql_common_core_msi\sql_common_core.msi" C:\Windows\Installer\908d69.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\x64\setup\sql_ssms.msi" C:\Windows\Installer\908e7a.msi
    Copy "D:\SQL_Svr_Enterprise_Edtn_2008_R2\x64\setup\sqlsqm.msi" C:\Windows\Installer\908c81.msi

    --MSPs

    Copy "e:\1ec986b2510fb9dd1a79e895963473\x64\setup\sql_bids.msp" C:\Windows\Installer\9091a5.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msp" C:\Windows\Installer\90936c.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\x64\setup\sql_fulltext.msp" C:\Windows\Installer\90938c.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\sql_engine_core_shared_loc_msi\sql_engine_core_shared_loc.msp" C:\Windows\Installer\9092eb.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\sql_tools_loc.msp" C:\Windows\Installer\90932b.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\sqlbrowser.msp" C:\Windows\Installer\90933c.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\sql_engine_core_inst_loc_msi\sql_engine_core_inst_loc.msp" C:\Windows\Installer\909381.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\sql_ssms_loc.msp" C:\Windows\Installer\90931d.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\x64\setup\sql_engine_core_shared_msi\sql_engine_core_shared.msp" C:\Windows\Installer\9090ac.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\x64\setup\sql_tools.msp" C:\Windows\Installer\9092cf.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\sql_common_core_loc_msi\sql_common_core_loc.msp" C:\Windows\Installer\9092db.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\x64\setup\sql_is.msp" C:\Windows\Installer\9090fb.msp
    Copy "M:\SQL2008R2BPA_Setup64.msi" C:\Windows\Installer\94f39ad.msi
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\sql_is_loc.msp" C:\Windows\Installer\9092fa.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\sql_bids_loc.msp" C:\Windows\Installer\909310.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\x64\SQLSysClrTypes.msp" C:\Windows\Installer\908fcd.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\1033_ENU_LP\x64\setup\x64\SqlWriter.msp" C:\Windows\Installer\908fbf.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\x64\setup\sql_common_core_msi\sql_common_core.msp" C:\Windows\Installer\909035.msp
    Copy "e:\1ec986b2510fb9dd1a79e895963473\x64\setup\sql_ssms.msp" C:\Windows\Installer\90926d.msp

    Friday, October 25, 2013 3:04 PM
  • Hello,

    About the MSIs just put the media on the D drive on the same path, run the VB script and it will recreate all those MSI on the Windows\Installer with the appropriate names (908dea.msi, 908f13.msi, etc.).

    About the MSPs, I am not sure to remember well but the script tries to reach the MSIs on temp folders and then if not found on the original media. I don’t remember to have manipulated MSPs.

    If this is an important production server and this is the first time you try this procedure, try to call Microsoft Support and contact a guy named Gagan Hiremath. I hope they take the case because when cached files have been deleted the server is considered on a not supported state, if they take it will be on a best effort basis.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com


    Friday, October 25, 2013 3:29 PM
    Moderator
  • Albert and Sam, Both of your suggestions helped me with the final solution.  I was able to upgrade to SP2 yesterday.    I ran the findsql script repeatedly after restoring some of the files.   Also, I was able to restore enough of the files in the windows installer directory to be able to run the repair with the original installation media.   That then restored a few more of the files.     4 or the MSPs I could not copied into the installer directory because they were in use.

    One thing to note is that the SP2 installation still pointed to some of the files that I had already copied, they were all MSIs and I was able to point them to the extracted Service Pack 1 installation files location.

    Whew...

    Tuesday, October 29, 2013 1:23 PM
  • Hello,

    I am glad you found the way to get out of the problem.

    It’s a long process…

    Thank you for sharing your experience with this problem.
    Regards,
    Alberto Morillo
    SQLCoffee.com

    Tuesday, October 29, 2013 2:20 PM
    Moderator