KB4057113 Installation Issue - sqlsupport.msi

  • Ok, I'm trying to install this security patch.  When I first started trying, it kept saying I can't files... I had to copy a ton of files to c:\windows\installer to even get the install wizard to pop up.  I thought I had fixed it and it started installing.  I got to the update progress section and then it popped up a window saying the feature you are trying to use is on a network resource is unavailable.  It asked me to tell it where sqlsupport.msi is.  I did... but it doesn't like it.  It then says the file is not a valid installation package product for SQL Server 2008 R2.  

    I have SQL Server 2008 R2 Service Pack 3 installed.  I copied the sqlsupport.msi file from the SP3 installation ISO. 

    What file does it want?  I'm so scared if I hit cancel that its going to mess up my SQL Server instance.  Please help!!

  • Ok, nevermind... I think I fixed my own issue.  I went to our production server and found another version of the file and gave it that file and that seemed to make it happy.  Course its asking me for more files now..... heh.

  • We used to run into this issue in the past and we were using VBS script to fix (https://support.microsoft.com/en-us/help/969052/how-to-restore-the-missing-windows-installer-cache-files-and-resolve-p)
    Well, now there's a tool called "FixMissingMSI" from Microsoft to fix these annoying issues which is way more efficient than VBS script approach. Take a look at below
    https://blogs.msdn.microsoft.com/psssql/2018/01/24/sql-setup-toolsuite-introduction-1-fixmissingmsi/
    Hope this helps.

  • UGH!!!!  After all this and all the time it took - the darned installation failed..... GRRRR!

  • Sreekanth B - Tuesday, May 29, 2018 2:18 PM

    We used to run into this issue in the past and we were using VBS script to fix (https://support.microsoft.com/en-us/help/969052/how-to-restore-the-missing-windows-installer-cache-files-and-resolve-p)
    Well, now there's a tool called "FixMissingMSI" from Microsoft to fix these annoying issues which is way more efficient than VBS script approach. Take a look at below
    https://blogs.msdn.microsoft.com/psssql/2018/01/24/sql-setup-toolsuite-introduction-1-fixmissingmsi/
    Hope this helps.

    Ok I ran the Fix tool.... it shows me a ton of stuff that needs to be fixed... and I see "fix it" in the first column but nothing on the menu bar is enabled (everything is grayed out) .... how do I make it fix stuff?

  • amy26 - Tuesday, May 29, 2018 3:17 PM

    Sreekanth B - Tuesday, May 29, 2018 2:18 PM

    We used to run into this issue in the past and we were using VBS script to fix (https://support.microsoft.com/en-us/help/969052/how-to-restore-the-missing-windows-installer-cache-files-and-resolve-p)
    Well, now there's a tool called "FixMissingMSI" from Microsoft to fix these annoying issues which is way more efficient than VBS script approach. Take a look at below
    https://blogs.msdn.microsoft.com/psssql/2018/01/24/sql-setup-toolsuite-introduction-1-fixmissingmsi/
    Hope this helps.

    Ok I ran the Fix tool.... it shows me a ton of stuff that needs to be fixed... and I see "fix it" in the first column but nothing on the menu bar is enabled (everything is grayed out) .... how do I make it fix stuff?

    FYI Here is the documentation for this tool.
    https://github.com/suyouquan/SQLSetupTools/blob/master/FixMissingMSI/Manual/FixMissingMSI%20Readme.pdf

  • Sreekanth B - Tuesday, May 29, 2018 3:46 PM

    amy26 - Tuesday, May 29, 2018 3:17 PM

    Sreekanth B - Tuesday, May 29, 2018 2:18 PM

    We used to run into this issue in the past and we were using VBS script to fix (https://support.microsoft.com/en-us/help/969052/how-to-restore-the-missing-windows-installer-cache-files-and-resolve-p)
    Well, now there's a tool called "FixMissingMSI" from Microsoft to fix these annoying issues which is way more efficient than VBS script approach. Take a look at below
    https://blogs.msdn.microsoft.com/psssql/2018/01/24/sql-setup-toolsuite-introduction-1-fixmissingmsi/
    Hope this helps.

    Ok I ran the Fix tool.... it shows me a ton of stuff that needs to be fixed... and I see "fix it" in the first column but nothing on the menu bar is enabled (everything is grayed out) .... how do I make it fix stuff?

    FYI Here is the documentation for this tool.
    https://github.com/suyouquan/SQLSetupTools/blob/master/FixMissingMSI/Manual/FixMissingMSI%20Readme.pdf

    Interesting, I didn't had any issues with this in the past. Well, they have two flavors of this tool, One for .Net3.5 and one for .Net4.5, Are you sure you got the right one? Go through the notes under section "FixMissingMSI Version 2.2" here: https://github.com/suyouquan/SQLSetupTools

  • Sreekanth B - Tuesday, May 29, 2018 3:46 PM

    amy26 - Tuesday, May 29, 2018 3:17 PM

    Sreekanth B - Tuesday, May 29, 2018 2:18 PM

    We used to run into this issue in the past and we were using VBS script to fix (https://support.microsoft.com/en-us/help/969052/how-to-restore-the-missing-windows-installer-cache-files-and-resolve-p)
    Well, now there's a tool called "FixMissingMSI" from Microsoft to fix these annoying issues which is way more efficient than VBS script approach. Take a look at below
    https://blogs.msdn.microsoft.com/psssql/2018/01/24/sql-setup-toolsuite-introduction-1-fixmissingmsi/
    Hope this helps.

    Ok I ran the Fix tool.... it shows me a ton of stuff that needs to be fixed... and I see "fix it" in the first column but nothing on the menu bar is enabled (everything is grayed out) .... how do I make it fix stuff?

    FYI Here is the documentation for this tool.
    https://github.com/suyouquan/SQLSetupTools/blob/master/FixMissingMSI/Manual/FixMissingMSI%20Readme.pdf

    Interesting, I didn't had any issues with this in the past. Well, they have two flavors of this tool, One for .Net3.5 and one for .Net4.5, Are you sure you got the right one? Go through the notes under section "FixMissingMSI Version 2.2" here: https://github.com/suyouquan/SQLSetupTools

  • Ok, I got the Fix to work and wow I had over 70 missing/mismatched files.  Once I got that fixed, the patch installed.

    Course now it won't install on my production server for a totally different reason haha... the pre check found my WMI stuff is broken and then an odd one about my clustering not being available... I'm not using SQL clustering... so not sure about that one.  Ugh, all this over a damn security patch! 😀

  • So, its been installing on my production server now for over an hour and its just sitting at this one place saying updating MSSQLSERVER: DowntimeTimingConfigAction ...

    I can't believe this patch is such an annoyance... should I stop it?  Will it screw up my production server?  I got it installed on the test server fine and didn't have any issues...it did take a long time but I always saw it moving on to different things.  Its just been sitting on this one thing forever.  The CPU isn't maxed out and the process still says "running" but I can't keep my prod server down this much just for a patch. 🙁

  • amy26 - Wednesday, May 30, 2018 7:23 PM

    So, its been installing on my production server now for over an hour and its just sitting at this one place saying updating MSSQLSERVER: DowntimeTimingConfigAction ...

    I can't believe this patch is such an annoyance... should I stop it?  Will it screw up my production server?  I got it installed on the test server fine and didn't have any issues...it did take a long time but I always saw it moving on to different things.  Its just been sitting on this one thing forever.  The CPU isn't maxed out and the process still says "running" but I can't keep my prod server down this much just for a patch. 🙁

    Not trying to criticize, but this is why it's so important to keep your test systems in sync with production, down to the last bit, as often as possible.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • Totally agree, our sites are identical... as much as they can be.  I am at a loss why the production site didn't go as smoothly.  At least with production I didn't have all the missing MSI file stuff...

  • amy26 - Thursday, May 31, 2018 7:42 AM

    Totally agree, our sites are identical... as much as they can be.  I am at a loss why the production site didn't go as smoothly.  At least with production I didn't have all the missing MSI file stuff...

    Yeah, at least there was the lack of missing files.   And of course, you don't have that much longer to worry about it, but do be sure not to jinx it.... 😀

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • amy26 - Thursday, May 31, 2018 7:42 AM

    Totally agree, our sites are identical... as much as they can be.  I am at a loss why the production site didn't go as smoothly.  At least with production I didn't have all the missing MSI file stuff...

    The current log file in the instance's \Setup Bootstrap\Log directory should have more information on what the problem is. You should at least be able to see where it is hung up.

    Sue

  • Sue_H - Thursday, May 31, 2018 8:04 AM

    amy26 - Thursday, May 31, 2018 7:42 AM

    Totally agree, our sites are identical... as much as they can be.  I am at a loss why the production site didn't go as smoothly.  At least with production I didn't have all the missing MSI file stuff...

    The current log file in the instance's \Setup Bootstrap\Log directory should have more information on what the problem is. You should at least be able to see where it is hung up.

    Sue

    Which LOG would I need to check?  I looked in there and I didn't see anything that told me much of anything.

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply