<div>
Should mention the original install was of &quot;SQL Server 2005 Express Edition SP2&quot;, without the &quot;Advanced Services&quot; (which includes Full-Text Search).
</div>


Should mention the original install was of "SQL Server 2005 Express Edition SP2", without the "Advanced Services" (which includes Full-Text Search).

<div>
<div class="content wysiwyg-content">
We have a Windows 2003 Server with SQLExpress 2005 installed. We need to install the Full-Text Search engine, but can't. &nbsp;If I try to add the feature via Add/Remove programs, it prompts for the Setup.exe file, which I do not have.<br />
<br />
If I run the SQLEXPR-ADV.EXE (full SQLExpress &amp;&nbsp;Advance Services install), and select the Full-Text Search option, I get this:<br />
<br />
Name: Microsoft SQL Server 2005 (SQLEXPRESS)<br />
Allowed Action: Maintain (Action is only available from Add or Remove Programs)<br />
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs<br />
<br />

</div>
</div>


We have a Windows 2003 Server with SQLExpress 2005 installed. We need to install the Full-Text Search engine, but can't.  If I try to add the feature via Add/Remove programs, it prompts for the Setup.exe file, which I do not have.

If I run the SQLEXPR-ADV.EXE (full SQLExpress & Advance Services install), and select the Full-Text Search option, I get this:

Name: Microsoft SQL Server 2005 (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs



Add Full-Text Search to existing SQLServer Express installation

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.