Solved

Add Full-Text Search to existing SQLServer Express installation

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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Divide by zero error encountered. 2 43
Not selecting duplicate data 6 60
MS SQLK Server multi-part identifier cannot be bound 5 41
Need help debbuging stored procedure 21 44
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 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