Link to home
Start Free TrialLog in
Avatar of JaneHunter
JaneHunter

asked on

MS SQL Server 2005 install fails on new XP Professional machine with Office 2007 trial -- help, please!

I have a new laptop, fortunately with XP professional, perhaps unfortunately with a trial copy of MSOffice 2007. I can't get MS SQL 2005 Developer edition to install. The log, relevant section pasted below, suggests that the problem is with Office and also refers to Office 2003, which has never been on the machine. I see in this question
https://www.experts-exchange.com/questions/22553859/SQL-Server-2005-Dev-Edition-fails-to-install-on-VISTA.html?sfQueryTermInfo=1+1706+error 

that the problem in that case turned out to be 2003 web components, but he was wrestling with VISTA and I'm a bit hesitant to remove the components without understanding why they're the problem or what their function is in this situation. I'm suspecting that the problem is that the trial edition of Office 2007 doesn't expose its install files. But I really don't have any knowledge of Office aps. I hope someone can help me with this, as it has me totally stuck.

Here's the log section where the failure occurred:

MSI (s) (6C:30) [22:48:31:843]: Doing action: InstallExecute
Action ended 22:48:31: PublishProduct. Return value 1.
MSI (s) (6C:30) [22:48:31:843]: Running Script: C:\WINDOWS\Installer\MSI8E.tmp
MSI (s) (6C:30) [22:48:31:843]: PROPERTY CHANGE: Adding UpdateStarted property. Its value is '1'.
MSI (s) (6C:30) [22:48:31:843]: Machine policy value 'DisableRollback' is 0
MSI (s) (6C:30) [22:48:31:859]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (6C:30) [22:48:31:859]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=921548304,LangId=1033,Platform=0,ScriptType=1,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
Action start 22:48:31: InstallExecute.
MSI (s) (6C:30) [22:48:31:859]: Executing op: ProductInfo(ProductKey={90A40409-6000-11D3-8CFE-0150048383C9},ProductName=Microsoft Office 2003 Web Components,PackageName=OWC11.MSI,Language=1033,Version=184557379,Assignment=1,ObsoleteArg=0,ProductIcon=misc.exe,6,,PackageCode={2EA998DE-A4D0-46ED-8DAB-00D767E96989},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0)
MSI (s) (6C:30) [22:48:31:859]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (6C:30) [22:48:31:859]: Executing op: DialogInfo(Type=1,Argument=Microsoft Office 2003 Web Components)
MSI (s) (6C:30) [22:48:31:859]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back installation,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (6C:30) [22:48:31:859]: Executing op: SetBaseline(Baseline=0,)
MSI (s) (6C:30) [22:48:31:859]: Executing op: SetBaseline(Baseline=1,)
MSI (s) (6C:30) [22:48:31:859]: Executing op: ActionStart(Name=MsiPublishAssemblies,Description=Publishing assembly information,Template=Application Context:[1], Assembly Name:[2])
MSI (s) (6C:30) [22:48:31:859]: Executing op: AssemblyUnpublish(Feature=dummy_OWC11_PIA,Component={2B9CB878-8D8B-41C8-BDD4-17D80DC4FC5D},AssemblyType=1,,AssemblyName=Microsoft.Office.Interop.Owc11,Version="11.0.0.0000",Culture="neutral",PublicKeyToken="71e9bce111e9429c",FileVersion="11.0.5530.0",)
MSI (s) (6C:30) [22:48:31:859]: Executing op: AssemblyPublish(Feature=dummy_OWC11_PIA,Component={2B9CB878-8D8B-41C8-BDD4-17D80DC4FC5D},AssemblyType=1,,AssemblyName=Microsoft.Office.Interop.Owc11,Version="11.0.0.0000",Culture="neutral",PublicKeyToken="71e9bce111e9429c",FileVersion="11.0.5530.0",)
MSI (s) (6C:30) [22:48:31:859]: Executing op: AssemblyUnpublish(Feature=dummy_OWC11_PIA,Component={FE57061C-E523-41E7-A576-2E1311DD5EC6},AssemblyType=1,,AssemblyName=mscomctl,Version="10.0.4504.0",Culture="neutral",PublicKeyToken="31bf3856ad364e35",FileVersion="10.0.4504.0",)
MSI (s) (6C:30) [22:48:31:859]: Executing op: AssemblyPublish(Feature=dummy_OWC11_PIA,Component={FE57061C-E523-41E7-A576-2E1311DD5EC6},AssemblyType=1,,AssemblyName=mscomctl,Version="10.0.4504.0",Culture="neutral",PublicKeyToken="31bf3856ad364e35",FileVersion="10.0.4504.0",)
MSI (s) (6C:30) [22:48:31:859]: Executing op: AssemblyUnpublish(Feature=VSCommonPIAHidden,Component={D825F19F-87AB-11D5-A54F-0090278A1BB8},AssemblyType=1,,AssemblyName=ADODB,Version="7.0.3300.00",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="7.10.2346.0",)
MSI (s) (6C:30) [22:48:31:875]: Executing op: AssemblyPublish(Feature=VSCommonPIAHidden,Component={D825F19F-87AB-11D5-A54F-0090278A1BB8},AssemblyType=1,,AssemblyName=ADODB,Version="7.0.3300.00",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="7.10.2346.0",)
MSI (s) (6C:30) [22:48:31:875]: Executing op: AssemblyUnpublish(Feature=VSCommonPIAHidden,Component={D825F1BA-87AB-11D5-A54F-0090278A1BB8},AssemblyType=1,,AssemblyName=MSDATASRC,Version="7.0.3300.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="7.0.9466.0",)
MSI (s) (6C:30) [22:48:31:875]: Executing op: AssemblyPublish(Feature=VSCommonPIAHidden,Component={D825F1BA-87AB-11D5-A54F-0090278A1BB8},AssemblyType=1,,AssemblyName=MSDATASRC,Version="7.0.3300.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="7.0.9466.0",)
MSI (s) (6C:30) [22:48:31:875]: Executing op: AssemblyUnpublish(Feature=VSCommonPIAHidden,Component={D825F1F0-87AB-11D5-A54F-0090278A1BB8},AssemblyType=1,,AssemblyName=stdole,Version="7.0.3300.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="7.0.9466.0",)
MSI (s) (6C:30) [22:48:31:875]: Executing op: AssemblyPublish(Feature=VSCommonPIAHidden,Component={D825F1F0-87AB-11D5-A54F-0090278A1BB8},AssemblyType=1,,AssemblyName=stdole,Version="7.0.3300.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="7.0.9466.0",)
MSI (s) (6C:30) [22:48:31:875]: Executing op: ActionStart(Name=AllocateRegistrySpace,Description=Allocating registry space,Template=Free space: [1])
MSI (s) (6C:30) [22:48:31:875]: Executing op: RegAllocateSpace(Space=10240)
MSI (s) (6C:30) [22:48:31:875]: Executing op: ActionStart(Name=ProcessComponents,Description=Updating component registration,)
MSI (s) (6C:30) [22:48:31:875]: Executing op: ProgressTotal(Total=1,Type=1,ByteEquivalent=24000)
MSI (s) (6C:30) [22:48:31:875]: Executing op: ComponentRegister(ComponentId={2B9CB878-8D8B-41C8-BDD4-17D80DC4FC5D},KeyPath=<\Microsoft.Office.Interop.Owc11,Version="11.0.0.0000",Culture="neutral",PublicKeyToken="71e9bce111e9429c",FileVersion="11.0.5530.0",State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (6C:30) [22:48:31:875]: MSCOREE already loaded, using loaded copy
MSI (s) (6C:30) [22:48:31:890]: Executing op: ActionStart(Name=RemoveODBC,Description=Removing ODBC components,)
MSI (s) (6C:30) [22:48:31:890]: Executing op: ODBCDriverManager(,BinaryType=0)
MSI (s) (6C:30) [22:48:31:890]: Executing op: ODBCDriverManager(,BinaryType=1)
MSI (s) (6C:30) [22:48:31:890]: Executing op: ActionStart(Name=CreateFolders,Description=Creating folders,Template=Folder: [1])
MSI (s) (6C:30) [22:48:31:890]: Executing op: FolderCreate(Folder=C:\,Foreign=0,)
MSI (s) (6C:30) [22:48:31:890]: Executing op: ActionStart(Name=InstallFiles,Description=Copying new files,Template=Copying file: [1])
MSI (s) (6C:30) [22:48:31:890]: Executing op: SetTargetFolder(Folder=C:\Program Files\Microsoft Office\OFFICE11\)
MSI (s) (6C:30) [22:48:31:890]: Executing op: SetSourceFolder(Folder=1\FILES\PFILES\MSOFFICE\OFFICE11\|FILES\Program Files\Microsoft Office\OFFICE11\)
MSI (s) (6C:30) [22:48:31:890]: Executing op: ChangeMedia(MediaVolumeLabel=OFFICE11,MediaPrompt=Please insert the disk: Microsoft Office 2003 Web Components,MediaCabinet=1\PA800302.CAB,BytesPerTick=32768,CopierType=1,,,SignatureRequired=0,,,IsFirstPhysicalMedia=1)
MSI (s) (6C:30) [22:48:31:890]: Executing op: AssemblyCopy(SourceName=OWC11PIA.DLL|Microsoft.Office.Interop.Owc11.dll,SourceCabKey=OWC11PIA.DLL,DestName=Microsoft.Office.Interop.Owc11.dll,Attributes=1024,FileSize=461416,PerTick=32768,,VerifyMedia=1,,,,,ComponentId={2B9CB878-8D8B-41C8-BDD4-17D80DC4FC5D},IsManifest=1,,,AssemblyMode=0,)
MSI (s) (6C:30) [22:48:31:890]: Resolving source.
MSI (s) (6C:30) [22:48:31:890]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (6C:30) [22:48:31:890]: User policy value 'DisableMedia' is 0
MSI (s) (6C:30) [22:48:31:890]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Looking for sourcelist for product {90A40409-6000-11D3-8CFE-0150048383C9}
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Adding {90A40409-6000-11D3-8CFE-0150048383C9}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Now checking product {90A40409-6000-11D3-8CFE-0150048383C9}
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Media is enabled for product.
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Trying source C:\SWWORK\MOSOURCE\BCM\OWC11\.
MSI (s) (6C:30) [22:48:31:890]: Note: 1: 2203 2: C:\SWWORK\MOSOURCE\BCM\OWC11\OWC11.MSI 3: -2147287037
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (6C:30) [22:48:31:890]: Note: 1: 1706 2: -2147483647 3: OWC11.MSI
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Processing net source list.
MSI (s) (6C:30) [22:48:31:890]: Note: 1: 1706 2: -2147483647 3: OWC11.MSI
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Processing media source list.
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Trying media source D:\.
MSI (s) (6C:30) [22:48:31:890]: Note: 1: 2203 2: D:\OWC11.MSI 3: -2147287038
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Trying media source R:\.
MSI (s) (6C:30) [22:48:31:890]: Note: 1: 2203 2: R:\OWC11.MSI 3: -2147287038
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (6C:30) [22:48:31:890]: Note: 1: 1706 2: -2147483647 3: OWC11.MSI
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Processing URL source list.
MSI (s) (6C:30) [22:48:31:890]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (6C:30) [22:48:31:890]: Note: 1: 1706 2: -2147483647 3: OWC11.MSI
MSI (s) (6C:30) [22:48:31:890]: Note: 1: 1706 2:  3: OWC11.MSI
MSI (s) (6C:30) [22:48:31:890]: SOURCEMGMT: Failed to resolve source
MSI (s) (6C:30) [22:49:14:671]: Product: Microsoft Office 2003 Web Components -- Error 1706. Setup cannot find the required files.  Check your connection to the network, or CD-ROM drive.  For other potential solutions to this problem, see C:\Program Files\Microsoft Office\OFFICE11\1033\SETUP.CHM.
Error 1706. Setup cannot find the required files.  Check your connection to the network, or CD-ROM drive.  For other potential solutions to this problem, see C:\Program Files\Microsoft Office\OFFICE11\1033\SETUP.CHM.
MSI (s) (6C:30) [22:49:14:687]: User policy value 'DisableRollback' is 0
MSI (s) (6C:30) [22:49:14:687]: Machine policy value 'DisableRollback' is 0
Action ended 22:49:14: InstallExecute. Return value 3.
MSI (s) (6C:30) [22:49:14:687]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=921548304,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (6C:30) [22:49:14:687]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (6C:30) [22:49:14:687]: Executing op: DialogInfo(Type=1,Argument=Microsoft Office 2003 Web Components)
MSI (s) (6C:30) [22:49:14:687]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back installation,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (6C:30) [22:49:14:687]: Executing op: ActionStart(Name=InstallFiles,Description=Copying new files,Template=Copying file: [1])
MSI (s) (6C:30) [22:49:14:687]: Executing op: SetTargetFolder(Folder=C:\Program Files\Microsoft Office\OFFICE11\)
MSI (s) (6C:30) [22:49:14:687]: Executing op: ProductInfo(ProductKey={90A40409-6000-11D3-8CFE-0150048383C9},ProductName=Microsoft Office 2003 Web Components,PackageName=OWC11.MSI,Language=1033,Version=184557379,Assignment=1,ObsoleteArg=0,ProductIcon=misc.exe,6,,PackageCode={2EA998DE-A4D0-46ED-8DAB-00D767E96989},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0)
MSI (s) (6C:30) [22:49:14:687]: Executing op: ActionStart(Name=CreateFolders,Description=Creating folders,Template=Folder: [1])
MSI (s) (6C:30) [22:49:14:687]: Executing op: FolderRemove(Folder=C:\,Foreign=0)
MSI (s) (6C:30) [22:49:14:687]: Executing op: ActionStart(Name=RemoveODBC,Description=Removing ODBC components,)
MSI (s) (6C:30) [22:49:14:687]: Executing op: ActionStart(Name=ProcessComponents,Description=Updating component registration,)
MSI (s) (6C:30) [22:49:14:687]: Executing op: ComponentUnregister(ComponentId={2B9CB878-8D8B-41C8-BDD4-17D80DC4FC5D},ProductKey={90A40409-6000-11D3-8CFE-0150048383C9},BinaryType=0,)
MSI (s) (6C:30) [22:49:14:687]: Executing op: ActionStart(Name=AllocateRegistrySpace,Description=Allocating registry space,Template=Free space: [1])
MSI (s) (6C:30) [22:49:14:687]: Executing op: ActionStart(Name=MsiPublishAssemblies,Description=Publishing assembly information,Template=Application Context:[1], Assembly Name:[2])
MSI (s) (6C:30) [22:49:14:687]: Executing op: RegOpenKey(Root=-2147483646,Key=Software\Classes\Installer\Assemblies\Global,,BinaryType=0)
MSI (s) (6C:30) [22:49:14:687]: Executing op: RegRemoveValue(Name=stdole,Version="7.0.3300.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="7.0.9466.0",Value=k!LQVn-}f(ZXfeAR6.jiVSCommonPIAHidden>_*xOnBb5g(X*z?VXB]2d[~],)
MSI (s) (6C:30) [22:49:14:687]: Executing op: RegCreateKey()
Avatar of haim96
haim96

do you have SP2 installed?
http://support.microsoft.com/kb/922669
Avatar of JaneHunter

ASKER

Yes, I do
Solutions:
Completely remove Ms Office programs and Ms Sql from Add and remove as well as Registry, (HKLM> Software> Microsoft)
restart the machine and then try again...

You can try detect and repair Ms Office from word , i dont know if its gonna help.

Reason:
1) The Office suite installation got corrupted silently somewhere...and since both sql and office are microsoft products, windows installer brings up this issue.....I believe visual studio has to do something in between this....remove that also from registry intially...
ASKER CERTIFIED SOLUTION
Avatar of georgemason
georgemason
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Just to be clear, there's no need to uninstall anything but the Office 2003 web components - no need to make extra work for yourself ;-)