Failed upgrade, now error 0x80070714

  • Upgrading an instance from SQL 2012 to SQL 2014. Instance has SQL Engine, SSAS, and SSIS. Using the GUI, everything proceeds normally until the very last step where I get the attached error (Install_error). After clicking retry and getting the same error, I clicked Cancel and received the results in the attachment "final.jpg"

    Now if I try and restart the setup routine, the SqlSetup log shows the following:

    10/28/2014 09:41:50.184 ======================================================================

    10/28/2014 09:41:50.184 Setup launched

    10/28/2014 09:41:50.185 Attempting to determine media source

    10/28/2014 09:41:50.185 Media source value not specified on command line argument.

    10/28/2014 09:41:50.186 Setup is launched from media directly so default the value to the current folder.

    10/28/2014 09:41:50.186 Media source: (removed for privacy)

    10/28/2014 09:41:50.187 Attempt to determine media layout based on file '(removed for privacy)'.

    10/28/2014 09:41:50.199 Media layout is detected as: Full

    10/28/2014 09:41:50.200 Not a slip stream media, so continuing to run setup.exe from media.

    10/28/2014 09:41:50.214 /? or /HELP or /ACTION=HELP specified: false

    10/28/2014 09:41:50.234 Help display: false

    10/28/2014 09:41:50.234 .Net version 3.5 is installed

    10/28/2014 09:41:50.235 .Net version 2.0 is installed

    10/28/2014 09:41:50.235 Current running setup.exe full path: (removed for privacy)

    10/28/2014 09:41:50.240 Media setup.exe file version detected: 2014.120.2000.8

    10/28/2014 09:41:50.241 Locally installed setup.exe full path: C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014\setup.exe

    10/28/2014 09:41:50.242 Unable to retrieve version information for file 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014\setup.exe'

    10/28/2014 09:41:50.242 Error: Cannot determine file version of local setup.exe: 0x80070714

    10/28/2014 09:41:50.242 Setup closed with exit code: 0x80070714

    10/28/2014 09:41:50.242 ======================================================================

    I have also tried running with the /REPAIR option, no luck with that either.

  • Solved it myself. When I looked at 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014\setup.exe' the file size was 0 KB. I renamed that to setup.exe.old, and re-ran the installer from our network share with the /REPAIR flag, and it worked like a charm.

  • tim_harkin (10/28/2014)


    Solved it myself. When I looked at 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014\setup.exe' the file size was 0 KB. I renamed that to setup.exe.old, and re-ran the installer from our network share with the /REPAIR flag, and it worked like a charm.

    Thanks for sharing the solution!

    After running into problems few times when upgrading, my preference is to do side by side installation rather than an upgrade.

    😎

Viewing 3 posts - 1 through 2 (of 2 total)

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