Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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

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

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

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:
    How to Add Features to an Instance of SQL Server 2008 R2 (Setup)
    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.

↑ Back to the top

More Information

For more information, visit the following Microsoft website:
Considerations for Side-by-Side Instances of SQL Server 2008 R2 and SQL Server 2008
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.

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2561774
Revision : 1
Created on : 1/7/2017
Published on : 6/21/2014
Exists online : False
Views : 396