Add Full-Text Search to existing SQLServer Express installation

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

knobbylowboyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
knobbylowboyConnect With a Mentor Author Commented:
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
 
knobbylowboyAuthor Commented:
Should mention the original install was of "SQL Server 2005 Express Edition SP2", without the "Advanced Services" (which includes Full-Text Search).
0
All Courses

From novice to tech pro — start learning today.