Solved

Add Full-Text Search to existing SQLServer Express installation

Posted on 2008-10-27
2
1,150 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

623 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