You are currently offline, waiting for your internet to reconnect

Access to the installation media for SQL Server 2008 R2 may be required when you install SQL Server 2008 side by side with a SQL Server 2008 R2 instance

Symptoms
Consider the following scenarios.
Scenario 1
  • You install an instance of Microsoft SQL Server 2008 R2 that does not include the Full-Text component.
  • You then try to install an instance Microsoft of SQL Server 2008 that includes the Full-Text Search feature by using SQL Server Installation Center.
In this scenario, you may be prompted for the installation media for SQL Server 2008 R2.
Scenario 2
If you install the SQL Server from the command prompt in silent mode by specifying either the /Q or /QS parameter, you are not prompted for the installation media. However, the installation fails silently.

In both scenarios, the Sql_engine_core_shared_Cpu32_1.log contains an entry that resembles the following:
MSI (s) (E4:A8) [17:48:18:322]: Product: SQL Server 2008 R2 Database Engine Shared -- Error 1706. An installation package for the product SQL Server 2008 R2 Database Engine Shared cannot be found. Try the installation again using a valid copy of the installation package 'sql_engine_core_shared.msi'.

Error 1706. An installation package for the product SQL Server 2008 R2 Database Engine Shared cannot be found. Try the installation again using a valid copy of the installation package 'sql_engine_core_shared.msi'.

Note If the original installation media for SQL Server 2008 R2 is still available to the SQL Server 2008 Setup program, you do not see this behavior.
Cause
The issue occurs because of the dependencies that the Full-Text installation package has on shared packages when SQL Server 2008 is installed side by side with SQL server 2008 R2. When you do not select the Full-Text feature when you install SQL Server 2008 R2, the shared package is only partly installed and does not include the Full-Text features. Therefore, when you try to install the Full-Text feature with SQL Server 2008, the setup detects that a later version of the shared package exists on the system and tries to use it. But because Full-Text component is missing from that package, setup prompts for the installation media for that shared package.

This behavior is by design.
Workaround
To work around this issue, you can use one of the following methods:
  • Locate the SQL Server 2008 R2 media that was used to install the SQL Server 2008 R2 instance on the system, and point the Setup program for SQL Server 2008 to this location.
  • You can add the Full-Text feature to SQL Server 2008 R2 instance before you run the setup for SQL Server 2008. For more information about how to do this, visit the following Microsoft TechNet website:Note This method does require the installation media for SQL Server 2008 R2.
  • When you install the instance of SQL Server 2008, make sure that the Full-Text feature is not selected.
More information
For more information, visit the following Microsoft website:Steps to Repro
  1. Install any edition of SQL Server 2008 R2 that does not include the Full-Text Search feature.
  2. Make sure that the installation media for SQL Server 2008 R2 is inaccessible on the system.
  3. Install any edition of SQL Server 2008 that includes Full-Text Search.
Properties

Article ID: 2561774 - Last Review: 06/21/2014 16:27:00 - Revision: 3.0

  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • KB2561774
Feedback