Solved

Add Full-Text Search to existing SQLServer Express installation

Posted on 2008-10-27
2
1,149 Views
Last Modified: 2012-06-21
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

0
Comment
Question by:knobbylowboy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 

Author Comment

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

Accepted Solution

by:
knobbylowboy earned 0 total points
ID: 22827437
Resolved:

Download the Advance Services install (SQLEXPR_ADV.EXE) from MS. Unzip it with Winzip/WinRAR etc. Go to Add/Remove Programs, select "Change" on SQLServer 2005. In wizard click link to "add new component" and when prompted browse to setup.exe (which was unzipped previously). The rest is academic.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Query to return total 6 26
SQL Error - Query 6 54
SQL Server 2005 database messed up. Can it be fixed? 4 38
Need to merge 3 large tables into one Table in SQL server 2 35
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question