如何使用 SQL Server 2012 內建的 SQL Server Data Tools

本文將介紹當您安裝了 SQL Server 2012 後,如何開始使用內建的 SQL Server Data Tools。

上一篇筆者提到可以利用 Web PI 下載 SQL Server Data Tools 來加強 Visual Studio 2010 有關 SQL Server 的各項功能,若您已安裝 SQL Server 2012 會發現,在程式集中會看到已經內建 SQL Server Data Tools,但實際上開啟 Visual Studio 2010 卻找不到 SQL Server 物件總管。

 

image

 

手動嘗試安裝也失敗。

 

image

 

詳細的錯誤訊息如下:

 

   1:  [19AC:0BD8][2012-03-18T07:38:15]: Burn v3.6.2019.0, path: C:\Users\使用者名稱\Downloads\SSDTSetup.exe, cmdline: '-burn.unelevated BurnPipe.{A2E7DA99-E089-40DD-A74F-F595FBA3265B} {A389DE3E-B86A-4695-9307-65DD4E90CE29} 7072'
   2:  [19AC:0BD8][2012-03-18T07:38:15]: Initializing numeric variable 'InstallLanguage' to value '1033'
   3:  [19AC:0BD8][2012-03-18T07:38:15]: Setting string variable 'WixBundleName' to value 'Microsoft SQL Server Data Tools'
   4:  [19AC:0BD8][2012-03-18T07:38:15]: Setting string variable 'WixBundleLog' to value 'C:\Users\使用者名稱\AppData\Local\Temp\sql_SSDT_1000_20120318073815.log'
   5:  [19AC:0BD8][2012-03-18T07:38:15]: Setting string variable 'WixBundleOriginalSource' to value 'C:\Users\使用者名稱\Downloads\SSDTSetup.exe'
   6:  [19AC:0BD8][2012-03-18T07:38:15]: Detect 24 packages
   7:  [19AC:0BD8][2012-03-18T07:38:15]: Setting string variable 'dotnetfx4setupexe_x64_DetectKey' to value '4.0.30319'
   8:  [19AC:0BD8][2012-03-18T07:38:15]: Setting numeric variable 'dotnetfx4setupexe_x64_DetectKeyExists' to value 1
   9:  [19AC:0BD8][2012-03-18T07:38:15]: Setting string variable 'dotnetfx4setupexe_x86_DetectKey' to value '4.0.30319'
  10:  [19AC:0BD8][2012-03-18T07:38:15]: Setting numeric variable 'dotnetfx4setupexe_x86_DetectKeyExists' to value 1
  11:  [19AC:0BD8][2012-03-18T07:38:15]: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\VS\Servicing\10.0\IntShell\1033'
  12:  [19AC:0BD8][2012-03-18T07:38:15]: Setting numeric variable 'KB2468871V2_DetectKeyExists' to value 1
  13:  [19AC:0BD8][2012-03-18T07:38:15]: Setting numeric variable 'KB2544514_DetectKeyExists' to value 1
  14:  [19AC:0BD8][2012-03-18T07:38:15]: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB'
  15:  [19AC:0BD8][2012-03-18T07:38:15]: Setting numeric variable 'localDBInstall_x64_DetectKeyExists' to value 0
  16:  [19AC:0BD8][2012-03-18T07:38:15]: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB'
  17:  [19AC:0BD8][2012-03-18T07:38:15]: Setting numeric variable 'localDBInstall_x86_DetectKeyExists' to value 0
  18:  [19AC:0BD8][2012-03-18T07:38:15]: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\procore\'
  19:  [19AC:0BD8][2012-03-18T07:38:15]: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\procore\1033'
  20:  [19AC:0BD8][2012-03-18T07:38:15]: Registry key not found. Key = 'SOFTWARE\Microsoft\SSDT\1.0\'
  21:  [19AC:0BD8][2012-03-18T07:38:15]: Setting numeric variable 'vs2010sp1Install_DetectKeyExists' to value 1
  22:  [19AC:0BD8][2012-03-18T07:38:15]: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\vstdcore\'
  23:  [19AC:0BD8][2012-03-18T07:38:15]: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\vstdcore\1033'
  24:  [19AC:0BD8][2012-03-18T07:38:15]: Setting string variable 'vstscore_DetectKey' to value '1'
  25:  [19AC:0BD8][2012-03-18T07:38:15]: Setting string variable 'vstscore1033_DetectKey' to value '1'
  26:  [19AC:0BD8][2012-03-18T07:38:15]: Registry key not found. Key = 'SOFTWARE\Microsoft\IIS Extensions\MSDeploy\3'
  27:  [19AC:0BD8][2012-03-18T07:38:15]: Setting numeric variable 'WebDeployV3_DetectKeyExists' to value 0
  28:  [19AC:0BD8][2012-03-18T07:38:15]: Detected related bundle: {cec9ef3a-14b4-4a9b-b2fc-66084086df03}, scope: PerMachine, version: 10.3.20225.0, operation: None
  29:  [19AC:0BD8][2012-03-18T07:38:15]: Setting numeric variable 'BootstrapperAction' to value 4
  30:  [19AC:0BD8][2012-03-18T07:38:15]: Condition '((1 <> 1) OR ((vstscore1033_DetectKey = 1)) OR ((vstdcore1033_DetectKey = 1)) OR ((procore1033_DetectKey = 1)) OR ((NOT((1 <> 1) OR ( (vstscore_DetectKey = 1)) OR ( (vstdcore_DetectKey = 1)) OR ( (procore_DetectKey = 1))))))' evaluates to true.
  31:  [19AC:0BD8][2012-03-18T07:38:15]: Condition '(NOT(RegSearch_SSDTCTP3Exists = v10.1.10712.0))' evaluates to true.
  32:  [19AC:0BD8][2012-03-18T07:38:15]: Condition '((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))' evaluates to true.
  33:  [19AC:0BD8][2012-03-18T07:38:15]: Condition '(dotnetfx4setupexe_x86_DetectKeyExists AND dotnetfx4setupexe_x86_DetectKey >= v4.0.30319) AND (NOT ((VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))) OR (dotnetfx4setupexe_x64_DetectKeyExists AND dotnetfx4setupexe_x64_DetectKey >= v4.0.30319))' evaluates to true.
  34:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: NETFX4, state: Present, cached: No
  35:  [19AC:0BD8][2012-03-18T07:38:15]: Condition '((NOT VersionNT64) AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))) AND (KB2468871V2_DetectKeyExists)' evaluates to false.
  36:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: KB2468871V2_x86, state: Absent, cached: No
  37:  [19AC:0BD8][2012-03-18T07:38:15]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))) AND (KB2468871V2_DetectKeyExists)' evaluates to true.
  38:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: KB2468871V2_x64, state: Present, cached: No
  39:  [19AC:0BD8][2012-03-18T07:38:15]: Condition '(intShellInstall_DetectKey = 1)' evaluates to false.
  40:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: VISUALSTUDIO2010INTEGRATEDRTM, state: Absent, cached: No
  41:  [19AC:0BD8][2012-03-18T07:38:15]: Condition '(vs2010sp1Install_DetectKeyExists) AND ((intShellInstall_DetectKey = 1) OR (1 <> 1) OR ( (vstscore_DetectKey = 1)) OR ( (vstdcore_DetectKey = 1)) OR ( (procore_DetectKey = 1)))' evaluates to true.
  42:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: VISUALSTUDIO2010SP1PATCH, state: Present, cached: No
  43:  [19AC:0BD8][2012-03-18T07:38:15]: Condition '(KB2544514_DetectKeyExists)' evaluates to true.
  44:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: KB2544514, state: Present, cached: Yes
  45:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SQLLS11X86, state: Absent, cached: No
  46:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SQLLS11X64, state: Present, cached: No
  47:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SQLDOM11X86, state: Absent, cached: No
  48:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SQLDOM11X64, state: Present, cached: No
  49:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: TSQLLANGSVC11X86, state: Absent, cached: No
  50:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: TSQLLANGSVC11X64, state: Present, cached: No
  51:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: DACFX11X86, state: Absent, cached: No
  52:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: DACFX11X64, state: Present, cached: No
  53:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SQLLOCALDBX86, state: Absent, cached: No
  54:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SQLLOCALDBX64, state: Absent, cached: No
  55:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SQLCLRTYPES11X86, state: Present, cached: No
  56:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SQLCLRTYPES11X64, state: Present, cached: No
  57:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SQLSMO11X86, state: Present, cached: No
  58:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SQLSMO11X64, state: Present, cached: No
  59:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SSDTEXTERNALS10, state: Present, cached: No
  60:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SSDTBUILDUTILITIES10, state: Absent, cached: No
  61:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: SSDT10, state: Absent, cached: No
  62:  [19AC:0BD8][2012-03-18T07:38:15]: Detected package: DBSQLPACKAGEPROVIDER10, state: Absent, cached: No
  63:  [19AC:0BD8][2012-03-18T07:38:15]: Comparing bundle tags: SSDT 10.3.20225.0 1033 {ACC007DE-6558-46E4-A0A0-F76A2E10DA06} --- SSDT 10.3.20225.0 1028 {ACC007DE-6558-46E4-A0A0-F76A2E10DA06}
  64:  [19AC:0BD8][2012-03-18T07:38:15]: Detect complete, result: 0x0
  65:  [19AC:0BD8][2012-03-18T07:38:26]: Plan 24 packages, action: Install
  66:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: NETFX4, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
  67:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '((NOT VersionNT64) AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to false.
  68:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: KB2468871V2_x86, state: Absent, default requested: Absent, ux requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: Unregister
  69:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
  70:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: KB2468871V2_x64, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
  71:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '(NOT((1 <> 1) OR ((vstscore1033_DetectKey = 1)) OR ((vstdcore1033_DetectKey = 1)) OR ((procore1033_DetectKey = 1))))' evaluates to false.
  72:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: VISUALSTUDIO2010INTEGRATEDRTM, state: Absent, default requested: Absent, ux requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: Unregister
  73:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: VISUALSTUDIO2010SP1PATCH, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
  74:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: KB2544514, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
  75:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '((NOT VersionNT64) AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to false.
  76:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SQLLS11X86, state: Absent, default requested: Absent, ux requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: Unregister
  77:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
  78:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SQLLS11X64, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
  79:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '((NOT VersionNT64) AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to false.
  80:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SQLDOM11X86, state: Absent, default requested: Absent, ux requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: Unregister
  81:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
  82:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SQLDOM11X64, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
  83:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '((NOT VersionNT64) AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to false.
  84:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: TSQLLANGSVC11X86, state: Absent, default requested: Absent, ux requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: Unregister
  85:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
  86:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: TSQLLANGSVC11X64, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
  87:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))' evaluates to true.
  88:  [19AC:0BD8][2012-03-18T07:38:26]: Setting string variable 'WixBundleLog_DACFX11X86' to value 'C:\Users\使用者名稱\AppData\Local\Temp\sql_SSDT_1000_20120318073815_0_DACFX11X86.log'
  89:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: DACFX11X86, state: Absent, default requested: Present, ux requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
  90:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
  91:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: DACFX11X64, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
  92:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '((NOT VersionNT64) AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to false.
  93:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SQLLOCALDBX86, state: Absent, default requested: Absent, ux requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: Unregister
  94:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
  95:  [19AC:0BD8][2012-03-18T07:38:26]: Setting string variable 'WixBundleLog_SQLLOCALDBX64' to value 'C:\Users\使用者名稱\AppData\Local\Temp\sql_SSDT_1000_20120318073815_1_SQLLOCALDBX64.log'
  96:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SQLLOCALDBX64, state: Absent, default requested: Present, ux requested: Present, execute: Install, rollback: None, cache: Yes, uncache: No, dependency: Register
  97:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))' evaluates to true.
  98:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SQLCLRTYPES11X86, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
  99:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
 100:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SQLCLRTYPES11X64, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
 101:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1))' evaluates to true.
 102:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SQLSMO11X86, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
 103:  [19AC:0BD8][2012-03-18T07:38:26]: Condition '(VersionNT64 AND ((VersionNT = v6.0 AND ServicePackLevel >= 2) OR (VersionNT = v6.1 AND ServicePackLevel >= 1) OR (VersionNT > v6.1)))' evaluates to true.
 104:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SQLSMO11X64, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
 105:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SSDTEXTERNALS10, state: Present, default requested: Present, ux requested: None, execute: None, rollback: None, cache: No, uncache: No, dependency: Register
 106:  [19AC:0BD8][2012-03-18T07:38:26]: Setting string variable 'WixBundleLog_SSDTBUILDUTILITIES10' to value 'C:\Users\使用者名稱\AppData\Local\Temp\sql_SSDT_1000_20120318073815_2_SSDTBUILDUTILITIES10.log'
 107:  [19AC:0BD8][2012-03-18T07:38:26]: Setting string variable 'WixBundleRollbackLog_SSDTBUILDUTILITIES10' to value 'C:\Users\使用者名稱\AppData\Local\Temp\sql_SSDT_1000_20120318073815_2_SSDTBUILDUTILITIES10_rollback.log'
 108:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SSDTBUILDUTILITIES10, state: Absent, default requested: Present, ux requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
 109:  [19AC:0BD8][2012-03-18T07:38:26]: Setting string variable 'WixBundleLog_SSDT10' to value 'C:\Users\使用者名稱\AppData\Local\Temp\sql_SSDT_1000_20120318073815_3_SSDT10.log'
 110:  [19AC:0BD8][2012-03-18T07:38:26]: Setting string variable 'WixBundleRollbackLog_SSDT10' to value 'C:\Users\使用者名稱\AppData\Local\Temp\sql_SSDT_1000_20120318073815_3_SSDT10_rollback.log'
 111:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: SSDT10, state: Absent, default requested: Present, ux requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
 112:  [19AC:0BD8][2012-03-18T07:38:26]: Condition 'WebDeployV3_DetectKeyExists' evaluates to false.
 113:  [19AC:0BD8][2012-03-18T07:38:26]: Planned package: DBSQLPACKAGEPROVIDER10, state: Absent, default requested: Absent, ux requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: Unregister
 114:  [19AC:0BD8][2012-03-18T07:38:26]: Plan complete, result: 0x0
 115:  [19AC:0BD8][2012-03-18T07:38:26]: Apply begin
 116:  [1BA0:19D4][2012-03-18T07:38:26]: Caching executable from: 'C:\Users\使用者名稱\Downloads\SSDTSetup.exe' to: 'C:\ProgramData\Package Cache\{86b4d378-8e43-49f9-b42d-f2141c6244cf}\SSDTSetup.exe'
 117:  [1BA0:19D4][2012-03-18T07:38:26]: Registering bundle dependency key: {86b4d378-8e43-49f9-b42d-f2141c6244cf}, version 10.3.20225.0
 118:  [19AC:0E78][2012-03-18T07:38:28]: Download engine HTTP 200 HEAD to http://go.microsoft.com/fwlink/?LinkId=241392&clcid=0x409
 119:  [19AC:0E78][2012-03-18T07:38:29]: Download engine HTTP 200 GET to http://go.microsoft.com/fwlink/?LinkId=241392&clcid=0x409
 120:  [1BA0:0B4C][2012-03-18T07:39:14]: Caching payload from working path 'C:\Users\使用者名稱\AppData\Local\Temp\DACFX11X86' to path 'C:\ProgramData\Package Cache\{B1B8C860-CEC6-4725-A2FC-EF876B99E82D}v11.0.2100.60\payload\x86\DACFramework.msi'
 121:  [19AC:0E78][2012-03-18T07:39:15]: Download engine HTTP 200 HEAD to http://go.microsoft.com/fwlink/?LinkId=241396&clcid=0x409
 122:  [19AC:0E78][2012-03-18T07:39:16]: Download engine HTTP 200 GET to http://go.microsoft.com/fwlink/?LinkId=241396&clcid=0x409
 123:  [1BA0:0B4C][2012-03-18T07:42:33]: Error 0x80092009: Failed to get authenticode certificate embedded in: C:\Users\使用者名稱\AppData\Local\Temp\SQLLOCALDBX64
 124:  [1BA0:0B4C][2012-03-18T07:42:33]: Error 0x80092009: Failed to verify payload signature: C:\ProgramData\Package Cache\{13D558FE-A863-402C-B115-160007277033}v11.0.2100.60\payload\x64\SqlLocalDB.msi
 125:  [1BA0:0B4C][2012-03-18T07:42:33]: Error 0x80092009: Failed to cache payload.
 126:  [19AC:0E78][2012-03-18T07:42:33]: Error 0x80092009: Failed to layout or cache payload.
 127:  [19AC:0E78][2012-03-18T07:42:33]: Error 0x80092009: Failed to cache per-machine payload.
 128:  [1BA0:0B4C][2012-03-18T07:42:33]: Removing cached package: {B1B8C860-CEC6-4725-A2FC-EF876B99E82D}v11.0.2100.60, from path: C:\ProgramData\Package Cache\{B1B8C860-CEC6-4725-A2FC-EF876B99E82D}v11.0.2100.60\
 129:  [19AC:0E78][2012-03-18T07:42:33]: Error 0x80092009: Failed to cache packages.
 130:  [19AC:0BD8][2012-03-18T07:42:33]: Error 0x80092009: Failed while waiting for cache thread to complete before executing.
 131:  [1BA0:19D4][2012-03-18T07:42:33]: Removing bundle dependency key: {86b4d378-8e43-49f9-b42d-f2141c6244cf}
 132:  [1BA0:19D4][2012-03-18T07:42:33]: Removing cached bundle: {86b4d378-8e43-49f9-b42d-f2141c6244cf}, from path: C:\ProgramData\Package Cache\{86b4d378-8e43-49f9-b42d-f2141c6244cf}\
 133:  [19AC:0BD8][2012-03-18T07:42:33]: Apply complete, result: 0x80092009 restart: No

 

 

 

既然透過 Web PI 安裝失敗,筆者嘗試直接到  Data Developer Center 下載適合 SSDT 安裝程式,以筆者的環境為例,因為 Visual Studio 2010 安裝的是英文版,因此下載 English(United States) 版的安裝程式。

下載完畢之後重點在於必須先將安裝程式解除封鎖。

 

image

 

接著必須以系統管理員身分執行安裝作業。

 

螢幕截圖00087

 

螢幕截圖00088

 

最後總算安裝成功,您可以在 About Microsift Visual Studio 看到 Microsoft SQL Server Data Tools 的項目。

 

螢幕截圖00089

 

雖然 SQL Server 2012 看起來有內建 SQL Server Data Tools,不過實際上仍需自行到 Data Developer Center  或是透過 Web PI 下載並安裝,無法直接使用,希望本文可以對您有幫助。

 

【參考資料】

SQL Server 2012–SQL Server Data Tools