full-text-searchsql server
I can't for the life of me install full text search on my SQL Server 2008 R2 instance.
Every installer I have tried shows me this:
Feature selection only shows Replication under features http://www.vme2-server.co.uk/images/sql.jpg
I've tried:
Any ideas what i'm doing wrong?
The SQL Server is reporting a version of 10.52.4000.0
Thanks in advance,
Dave
Full Text Search features are available in
Microsoft SQL Server 2005 Express Edition with Advanced Services
Microsoft® SQL Server® 2008 Express with Advanced Services
Installation and configuration are pretty simple, hope you have already installed express edition.
Give it a try!
UPDATE: 2011 - MARCH - 08
You will not be able manage Full Text Catalogs via SSMS.
SQL Server Management Studio Express
- You cannot update the full-text catalog by using SSMSE. You can use sqlcmd utility or Windows Scheduler to update the full-text catalog.
I finally found the cause of my problem!
I tried for months to track down the issue, but finally gave up, disabled automatic change tracking, just manually initiated incremental population and moved on with my life.
Meanwhile, there had been another nagging error that I was having trouble tracking down. Periodically the website would throw a DB connection error:
Cannot open database "XXXX" requested by the login. The login failed. Login failed for user 'XXXX'.
It turned out that both of these problems had the same solution. All I had to do is turn off a database setting called Auto Close. To do this, just right-click the database and click properties. In the properties window select Options and set "Auto Close" to false.
As soon as I disabled Auto Close, my DB login issues went away and the automatic change tracking worked perfectly.
Thanks again for everyone's help. I appreciate it!
Best Answer
If you want to use Full text search, you need the 'Advanced Services' edition of SQL Server Express 2008, which can be obtained at Microsoft
However, you need to uninstall the current version first.