Я пытаюсь установить SSIS в нашу производственную коробку SQL 2005 SP2. Каждый раз, когда я пытаюсь выполнить эту попытку, экран установки / настройки приводит к сбою, начиная с нативного клиента и двигаясь дальше вниз. Снимки экрана ниже показывают то, что я вижу:
Вот результат нажатия на ссылку статуса справа от собственного клиента после сбоя установки:
=== Verbose logging started: 3/28/2012 16:38:08 Build type: SHIP UNICODE 3.01.4000.4042 Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (DC:00) [16:38:08:875]: Resetting cached policy values
MSI (c) (DC:00) [16:38:08:875]: Machine policy value 'Debug' is 0
MSI (c) (DC:00) [16:38:08:875]: ******* RunEngine:
******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
******* Action:
******* CommandLine: **********
MSI (c) (DC:00) [16:38:08:875]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (DC:00) [16:38:08:875]: Grabbed execution mutex.
MSI (c) (DC:00) [16:38:08:875]: Cloaking enabled.
MSI (c) (DC:00) [16:38:08:875]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (DC:00) [16:38:08:875]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (90:F0) [16:38:08:875]: Grabbed execution mutex.
MSI (s) (90:D4) [16:38:08:875]: Resetting cached policy values
MSI (s) (90:D4) [16:38:08:875]: Machine policy value 'Debug' is 0
MSI (s) (90:D4) [16:38:08:875]: ******* RunEngine:
******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
******* Action:
******* CommandLine: **********
MSI (s) (90:D4) [16:38:08:875]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (90:D4) [16:38:08:890]: Warning: Local cached package 'C:\WINDOWS\Installer\65eb99.msi' is missing.
MSI (s) (90:D4) [16:38:08:890]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (90:D4) [16:38:08:890]: User policy value 'DisableMedia' is 0
MSI (s) (90:D4) [16:38:08:890]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Looking for sourcelist for product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Adding {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Now checking product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Media is enabled for product.
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Trying source C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\.
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Source is invalid due to invalid package code (product code doesn't match).
MSI (s) (90:D4) [16:38:08:890]: Note: 1: 1706 2: -2147483646 3: sqlncli.msi
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Processing net source list.
MSI (s) (90:D4) [16:38:08:890]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (90:D4) [16:38:08:890]: SOURCEMGMT: Processing media source list.
MSI (s) (90:D4) [16:38:09:921]: SOURCEMGMT: Trying media source F:\.
MSI (s) (90:D4) [16:38:09:921]: Note: 1: 2203 2: F:\sqlncli.msi 3: -2147287038
MSI (s) (90:D4) [16:38:09:921]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (90:D4) [16:38:09:921]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (90:D4) [16:38:09:921]: SOURCEMGMT: Processing URL source list.
MSI (s) (90:D4) [16:38:09:921]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (90:D4) [16:38:09:921]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (90:D4) [16:38:09:921]: Note: 1: 1706 2: 3: sqlncli.msi
MSI (s) (90:D4) [16:38:09:921]: SOURCEMGMT: Failed to resolve source
MSI (s) (90:D4) [16:38:09:921]: MainEngineThread is returning 1612
MSI (c) (DC:00) [16:38:09:921]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (DC:00) [16:38:09:921]: MainEngineThread is returning 1612
=== Verbose logging stopped: 3/28/2012 16:38:09 ===
Вот журнал, который отображается, когда я щелкаю статус ошибки для MSXML6:
=== Verbose logging started: 3/28/2012 16:38:12 Build type: SHIP UNICODE 3.01.4000.4042 Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (DC:58) [16:38:12:250]: Resetting cached policy values
MSI (c) (DC:58) [16:38:12:250]: Machine policy value 'Debug' is 0
MSI (c) (DC:58) [16:38:12:250]: ******* RunEngine:
******* Product: {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}
******* Action:
******* CommandLine: **********
MSI (c) (DC:58) [16:38:12:250]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (DC:58) [16:38:12:250]: Grabbed execution mutex.
MSI (c) (DC:58) [16:38:12:250]: Cloaking enabled.
MSI (c) (DC:58) [16:38:12:250]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (DC:58) [16:38:12:250]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (90:58) [16:38:12:265]: Grabbed execution mutex.
MSI (s) (90:DC) [16:38:12:265]: Resetting cached policy values
MSI (s) (90:DC) [16:38:12:265]: Machine policy value 'Debug' is 0
MSI (s) (90:DC) [16:38:12:265]: ******* RunEngine:
******* Product: {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}
******* Action:
******* CommandLine: **********
MSI (s) (90:DC) [16:38:12:265]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (90:DC) [16:38:12:265]: Warning: Local cached package 'C:\WINDOWS\Installer\ce6d56e.msi' is missing.
MSI (s) (90:DC) [16:38:12:265]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (90:DC) [16:38:12:265]: User policy value 'DisableMedia' is 0
MSI (s) (90:DC) [16:38:12:265]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Looking for sourcelist for product {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Adding {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Now checking product {56EA8BC0-3751-4B93-BC9D-6651CC36E5AA}
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Media is enabled for product.
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Trying source d:\2a2ac35788eea9066bae01\.
MSI (s) (90:DC) [16:38:12:265]: Note: 1: 2203 2: d:\2a2ac35788eea9066bae01\msxml6.msi 3: -2147287037
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (90:DC) [16:38:12:265]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Processing net source list.
MSI (s) (90:DC) [16:38:12:265]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (90:DC) [16:38:12:265]: SOURCEMGMT: Processing media source list.
MSI (s) (90:DC) [16:38:12:296]: SOURCEMGMT: Trying media source F:\.
MSI (s) (90:DC) [16:38:12:296]: Note: 1: 2203 2: F:\msxml6.msi 3: -2147287038
MSI (s) (90:DC) [16:38:12:296]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (90:DC) [16:38:12:296]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (90:DC) [16:38:12:296]: SOURCEMGMT: Processing URL source list.
MSI (s) (90:DC) [16:38:12:296]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (90:DC) [16:38:12:296]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (90:DC) [16:38:12:296]: Note: 1: 1706 2: 3: msxml6.msi
MSI (s) (90:DC) [16:38:12:296]: SOURCEMGMT: Failed to resolve source
MSI (s) (90:DC) [16:38:12:296]: MainEngineThread is returning 1612
MSI (c) (DC:58) [16:38:12:296]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (DC:58) [16:38:12:296]: MainEngineThread is returning 1612
=== Verbose logging stopped: 3/28/2012 16:38:12 ===
Когда я нажимаю на неудачный статус для SSIS, файл журнала не появляется вообще. Честно говоря, я даже не уверен, с чего начать - никогда не предполагал, что добавить компонент прямо с диска будет так сложно. Любая помощь или указатели будут очень благодарны. Если есть какие-то подробности, спрашивайте - буду рад их добавить.
Часть тех лог-файлов, которые мне особенно понравились, была следующая:
Source is invalid due to invalid package code (product code doesn't
match)
Google нашел это, что кажется мне актуальным:
Ваши ошибки, похоже, указывают на отсутствие файлов кэша установщика Windows.
Посмотрите эту ссылку: Как восстановить отсутствующие файлы кэша установщика Windows и решить проблемы, возникающие при обновлении SQL Server