Failed to Install SQL 2008 R2 SP1 CU5 - Failed to Update the Shared Features

Question

We're stuck on trying to install the Cumulative update package 5 for SQL Server 2008 R2 Service Pack 1 on a Windows 7 workstation. It gets stuck at 'Updating Shared Features'

the Details.txt log stops at these lines

      ----------------------------------------------------------------------
 Slp: Running Action: MsiTimingAction
 Slp: ----------------------------------------------------------------------
 Slp: Running Action: Install_sql_common_core_Cpu64_Action
 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
 Slp: Sco: Attempting to open registry subkey
 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VisualStudio\9.0
 Slp: Sco: Attempting to get registry value InstallDir
 Slp: Target package: "{36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}"

Also, the sql_common_core_Cpu64_1.log shows

SOURCEMGMT: Looking for sourcelist for product {36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}
SOURCEMGMT: Adding {36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}; to potential sourcelist list (pcode;disk;relpath).
SOURCEMGMT: Now checking product {36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}
SOURCEMGMT: Media is enabled for product.
SOURCEMGMT: Attempting to use LastUsedSource from source list.
SOURCEMGMT: Trying source \\notebookpc\e$\Microsoft\SQL\SQL 2008 R2\SQL 2008 R2\x64\setup\sql_common_core_msi\.
Note: 1: 1314 2: \\notebookpc\e$\Microsoft\SQL\SQL 2008 R2\SQL 2008 R2\x64\setup\sql_common_core_msi\

It looks like the update is trying to find the original source of SQL 2008 on one of our admin notebook computers, notebookpc which is no longer in service. Is there a way I can change the LastUsedSource to a current location for SQL 2008?

---

Orange County District Attorney

Answer 1

SQL Server on Windows 7 workstation - therefore I assume the SQL Server does not need to be available 24hours/day.

Have you already tried reinstalling service pack 1 from the new location and than installing latest CU again?

Answer 2

Found the solution for us on this one. I searched the workstations registry and found many references to unreachable InstallSource locations for the original SQL 2008 R2 media. It seems that the original installation was done from a remotely-shared cd on someone's notebook. I chaged all these outdated locations to the correct location and the reinstall worked like a charm.

---

Orange County District Attorney

Answer 3

Hi Sandy Wood,

Regarding to the error message and your description, which might occurs because the installation media for SQL Server 2008 SP1 CU 5 does not exist in the location from which you originally installed the instance.

There are two workarounds, please one of the following methods:
Method 1: Use the location from which you installed the instance of SQL Server 2008 to run the Setup command, please follow the steps as below:
1. Make sure that the SQL Server 2008 installation media exists in the location from which you originally installed the instance of SQL Server 2008.
2. Click Start, click Run, type cmd, and then click OK.
3. Run the following command to rebuild the system databases:
start /wait Original_Location\setup.exe /qn INSTANCENAME=Instance_Name REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=StrongPassword

>>  Is there a way I can change the LastUsedSource to a current location for SQL 2008?
Method 2 is to Update the location that is saved in the value of the LastUsedSource registry entry, please follow the steps as below:
1. Click Start, click Run, type regedit, and then click OK.
2. Locate the following registry entry:
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products\<Product_Code>\SourceList\LastUsedSource
Note <Product_Code> represents the registry subkey that contains the ProductName registry entry whose value is Microsoft SQL Server 2008.
3. Update the location that is saved in the value of the LastUsedSource registry entry to the location from which you want execute the Setup command.

If you have any error, please post SQL error log for further troubleshooting.

---

Regards,
Amber zhang
TechNet Subscriber Support

If you are TechNet Subscriptionuser and have any feedback on our support quality, please send your feedback here.

Answer 4

I had the same issue with SQL 2012 SP1 CU3. Thanks for the suggestion. As soon as I inserted the original SQL 2012 DVD, the CU3 completed its install.