Saturday, August 20, 2011

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 (x86)\Microsoft Office\OFFICE11\1033\SETUP.CHM.


I was sitting in the class and my friend was trying to install SQL server on his laptop but it was continuously failing. He has a windows laptop which came with small business server installed with it. I started the setup with my magic hands and it failed with the below error.

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 (x86)\Microsoft Office\OFFICE11\1033\SETUP.CHM.

Ok, even with magic hands we cannot do magic with SQL setup. So I started with the first step of checking the setup logs. Started with SQLSetup003_SystemName_OWC11_1.log. The setup was failing as it was not able to validate the MSI file as per the below message in the log file.

MSI (s) (64:3C) [14:22:07:275]: SOURCEMGMT: Looking for sourcelist for product {90A40409-6000-11D3-8CFE-0150048383C9}
MSI (s) (64:3C) [14:22:07:275]: SOURCEMGMT: Adding {90A40409-6000-11D3-8CFE-0150048383C9}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (64:3C) [14:22:07:275]: SOURCEMGMT: Now checking product {90A40409-6000-11D3-8CFE-0150048383C9}
MSI (s) (64:3C) [14:22:07:275]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (64:3C) [14:22:07:275]: SOURCEMGMT: Trying source c:\windows\temp\mount\204836\OWC11\.
MSI (s) (64:3C) [14:22:07:291]: Note: 1: 2203 2: c:\windows\temp\mount\204836\OWC11\OWC11.MSI 3: -2147287037
MSI (s) (64:3C) [14:22:07:291]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (64:3C) [14:22:07:291]: Note: 1: 1706 2: -2147483647 3: OWC11.MSI
MSI (s) (64:3C) [14:22:07:291]: SOURCEMGMT: Processing net source list.
MSI (s) (64:3C) [14:22:07:291]: Note: 1: 1706 2: -2147483647 3: OWC11.MSI
MSI (s) (64:3C) [14:22:07:291]: SOURCEMGMT: Processing media source list.
MSI (s) (64:3C) [14:22:07:322]: Note: 1: 2203 2:  3: -2147287037
MSI (s) (64:3C) [14:22:07:322]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (64:3C) [14:22:07:322]: Note: 1: 1706 2: -2147483647 3: OWC11.MSI
MSI (s) (64:3C) [14:22:07:322]: SOURCEMGMT: Processing URL source list.
MSI (s) (64:3C) [14:22:07:322]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (64:3C) [14:22:07:322]: Note: 1: 1706 2: -2147483647 3: OWC11.MSI
MSI (s) (64:3C) [14:22:07:322]: Note: 1: 1706 2:  3: OWC11.MSI
MSI (s) (64:3C) [14:22:07:322]: SOURCEMGMT: Failed to resolve source
MSI (s) (64:3C) [14:23:01:042]: 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 (x86)\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 (x86)\Microsoft Office\OFFICE11\1033\SETUP.CHM.

And the reason it was not able to validate the file is because my good friend has saved his laptop previously by restoring it from the recovery disc. This has installed all the components from the mount point created in the Temp drive which is no longer valid.

Having dealt with this kind of issues previously I had explained my frined that we can do it in two ways.

1.       Download the get the required file.
a.       Download the express edition of SQL Server 2005 which installs with small business server and extract the exe file.
b.      Copy the location of OWC11.msi file in the extracted location.
c.       Open the registry location “HKEY_CLASSES_ROOT\Installer\Products” and search for the GUID as per the log above.
d.      In this case the product GUID is 90A40409-6000-11D3-8CFE-0150048383C9). So search by reversing the first part of the above GUID 90404A09………
e.      Under the key in registry select SourceList. Open the key LastUsedSource and paste the location of new OWC11.msi and click ok.

f.        Expand SourceList and select Net. Open the key 1 and paste the same location and click ok.

Rerun the setup and it should complete successfully.

2.       Uninstall the Microsoft Office Web Components from add and remove programs. Rerun the setup of SQL Server and it will reinstall the Office Web Components successfully.

My friend was intelligent and chooses the second option which saved the pain I go through every day with many others.

Happy Troubleshooting,
Manu

3 comments:

  1. Don't muck about - option 2 is the one to go for. Why sweat when you can point and click

    ReplyDelete