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.
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.
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.
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: