none
Sql Server Data Tools won't install because KB2544514 is blocked or not applicable

    Question

  • I'm trying to install SQL Server Data Tools on a machine with Windows 7 64-bit, VS2010, SQL Server 2008 R2, etc., but it fails to install. Looking at the log, the failure is because it can't install KB2544514. I've tried downloading and installing that seperately (NDP40-KB2544514-x86-x64.exe) and it reports "KB2544514 does not apply, or is blocked by another condition on your computer.". Is there a workaround or fix to let me install SSDT?
    Tuesday, December 06, 2011 1:31 PM

Answers

  • OK, I figured this out.

    Whne I checked my list of installed programs, I fund that, in addition to Visual Studio 11 Developer Preview and SQL Server "Denali" Client CTP, I also had .NET Framework 4.5 Developer Preview. But I did not actually have .NET Framework 4.0. Presumably, 4.5 "replaced" it, hence KB2544514 (and hence SSDT) could not be installed because a later version already existed!

    The solution was to remove .NET Framework 4.5 Developer Preview (I also removed VS11 and Denali as I'm not currently doing anything with them) and to reinstall .NET Framework 4.0 (and KB2544514). SSDT then installed without a hitch.

    I wonder if SSDT CTP4 will break if I reinstall .NET Framework 4.5 Developer Preview?

    • Marked as answer by Derek Dongray Wednesday, December 07, 2011 2:22 PM
    Wednesday, December 07, 2011 2:22 PM

All replies

  • My guess is that the KB2544514 installer believes that VS2010 SP1 is not installed. Either because it is not installed or because you are running in to the following issue: http://blogs.msdn.com/b/ssdt/archive/2011/11/30/ctp4-installation-issue-with-vs2010-service-pack-1.aspx
    -GertD @ www.sqlproj.com
    Wednesday, December 07, 2011 7:54 AM
    Moderator
  • Just tried another reinstallation of SP1 using the web installer (must be the 3rd or 4th now). Still the same error.

     

    The registry key HKLM\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\SP is 1.

    Tail end of log...

    [2424:225C][2011-12-07T10:23:34]: Caching payload from working path 'C:\Users\ddongray\AppData\Local\Temp\KB2544514' to path 'C:\ProgramData\Package Cache\DEEE0479FA9313AA67ABDA1EF1D9AB25646CC401\payload\NDP40-KB2544514-x86-x64.exe'
    [2424:20D8][2011-12-07T10:23:34]: Setting numeric variable 'BootstrapperAction' to value 4
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'dotnetfx4setupexe_x64_DetectKey' to value '4.5.40805'
    [2424:20D8][2011-12-07T10:23:34]: Setting numeric variable 'dotnetfx4setupexe_x64_DetectKeyExists' to value 1
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'dotnetfx4setupexe_x86_DetectKey' to value '4.5.40805'
    [2424:20D8][2011-12-07T10:23:34]: Setting numeric variable 'dotnetfx4setupexe_x86_DetectKeyExists' to value 1
    [2424:20D8][2011-12-07T10:23:34]: Setting numeric variable 'InstallLanguage' to value 1033
    [2424:20D8][2011-12-07T10:23:34]: Setting numeric variable 'KB2468871V2_DetectKeyExists' to value 1
    [2424:20D8][2011-12-07T10:23:34]: Setting numeric variable 'KB2544514_DetectKeyExists' to value 0
    [2424:20D8][2011-12-07T10:23:34]: Setting numeric variable 'localDBInstall_x64_DetectKeyExists' to value 0
    [2424:20D8][2011-12-07T10:23:34]: Setting numeric variable 'localDBInstall_x86_DetectKeyExists' to value 0
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'procore_DetectKey' to value '1'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'procore1033_DetectKey' to value '1'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'RegSearch_SSDTCTP3Exists' to value '11.0.10806.00'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'VS2010SP1AppliedOnEachVSComponentKey' to value '1'
    [2424:20D8][2011-12-07T10:23:34]: Setting numeric variable 'vs2010sp1Install_DetectKeyExists' to value 1
    [2424:20D8][2011-12-07T10:23:34]: Setting numeric variable 'WebDeployV3_DetectKeyExists' to value 1
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_DACFX11X64' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_4_DACFX11X64.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_DBSQLPACKAGEPROVIDER10' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_13_DBSQLPACKAGEPROVIDER10.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_KB2544514' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_0_KB2544514.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_SQLCLRTYPES11X64' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_7_SQLCLRTYPES11X64.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_SQLCLRTYPES11X86' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_6_SQLCLRTYPES11X86.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_SQLDOM11X64' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_2_SQLDOM11X64.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_SQLLOCALDBX64' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_5_SQLLOCALDBX64.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_SQLLS11X64' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_1_SQLLS11X64.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_SQLSMO11X64' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_9_SQLSMO11X64.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_SQLSMO11X86' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_8_SQLSMO11X86.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_SSDT10' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_12_SSDT10.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_SSDTBUILDUTILITIES10' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_11_SSDTBUILDUTILITIES10.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_SSDTEXTERNALS10' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_10_SSDTEXTERNALS10.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleLog_TSQLLANGSVC11X64' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_3_TSQLLANGSVC11X64.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleName' to value 'Microsoft SQL Server Data Tools - Database Projects'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleOriginalSource' to value 'C:\Users\ddongray\Downloads\SSDTSetup.exe'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleRollbackLog_DBSQLPACKAGEPROVIDER10' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_13_DBSQLPACKAGEPROVIDER10_rollback.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleRollbackLog_SSDT10' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_12_SSDT10_rollback.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleRollbackLog_SSDTBUILDUTILITIES10' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_11_SSDTBUILDUTILITIES10_rollback.log'
    [2424:20D8][2011-12-07T10:23:34]: Setting string variable 'WixBundleRollbackLog_SSDTEXTERNALS10' to value 'C:\Users\ddongray\AppData\Local\Temp\sql_SSDT_1000_20111207101803_10_SSDTEXTERNALS10_rollback.log'
    [2424:20D8][2011-12-07T10:23:34]: Applying package: KB2544514, action: Install, path: C:\ProgramData\Package Cache\DEEE0479FA9313AA67ABDA1EF1D9AB25646CC401\payload\NDP40-KB2544514-x86-x64.exe, arguments: '"C:\ProgramData\Package Cache\DEEE0479FA9313AA67ABDA1EF1D9AB25646CC401\payload\NDP40-KB2544514-x86-x64.exe"'
    [2424:20D8][2011-12-07T10:23:43]: Error 0x80004005: Result was not set by netfx chainer
    [2424:20D8][2011-12-07T10:23:43]: Error 0x80004005: Failed to run netfx chainer: C:\ProgramData\Package Cache\DEEE0479FA9313AA67ABDA1EF1D9AB25646CC401\payload\NDP40-KB2544514-x86-x64.exe
    [2424:20D8][2011-12-07T10:23:43]: Error 0x80004005: Failed to execute EXE package.
    [1B78:173C][2011-12-07T10:23:43]: Error 0x80004005: Failed to configure per-machine EXE package.
    [1B78:173C][2011-12-07T10:23:43]: Error 0x80004005: Failed to execute EXE package.
    [2424:20D8][2011-12-07T10:23:43]: Removing cached package: DEEE0479FA9313AA67ABDA1EF1D9AB25646CC401, from path: C:\ProgramData\Package Cache\DEEE0479FA9313AA67ABDA1EF1D9AB25646CC401\
    [1B78:173C][2011-12-07T10:23:44]: Error 0x80004005: Failed to execute apply.
    [2424:20D8][2011-12-07T10:23:44]: Removing bundle dependency key: {a1e861a1-26b1-441b-8d19-5b547c727140}
    [2424:20D8][2011-12-07T10:23:44]: Removing cached bundle: {a1e861a1-26b1-441b-8d19-5b547c727140}, from path: C:\ProgramData\Package Cache\{a1e861a1-26b1-441b-8d19-5b547c727140}\
    [1B78:173C][2011-12-07T10:23:44]: Apply complete, result: 0x80004005 restart: No

    Wednesday, December 07, 2011 10:33 AM
  • Just tried the ISO version of SP1. No change.
    Wednesday, December 07, 2011 11:37 AM
  • OK, I figured this out.

    Whne I checked my list of installed programs, I fund that, in addition to Visual Studio 11 Developer Preview and SQL Server "Denali" Client CTP, I also had .NET Framework 4.5 Developer Preview. But I did not actually have .NET Framework 4.0. Presumably, 4.5 "replaced" it, hence KB2544514 (and hence SSDT) could not be installed because a later version already existed!

    The solution was to remove .NET Framework 4.5 Developer Preview (I also removed VS11 and Denali as I'm not currently doing anything with them) and to reinstall .NET Framework 4.0 (and KB2544514). SSDT then installed without a hitch.

    I wonder if SSDT CTP4 will break if I reinstall .NET Framework 4.5 Developer Preview?

    • Marked as answer by Derek Dongray Wednesday, December 07, 2011 2:22 PM
    Wednesday, December 07, 2011 2:22 PM
  • The problem is not with .NET 4.5 but with the Visual Studio 11 Developer Preview, it relies on older and incompatible components based on SQL Server 2012 CTP3 which are incompatible with CTP4 with reliease on the SQL Server 2012 RC0 components.

     


    -GertD @ www.sqlproj.com
    Wednesday, December 07, 2011 11:08 PM
    Moderator
  • You ROCK !!!

    Saturday, June 09, 2012 2:08 AM
  • All I had to do is to uninstall .NET 4.5 and then it worked.  But this posting led me in that direction.
    Thursday, September 27, 2012 8:58 AM