Go Back   Computer Forums > General Computing > Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 03-08-2009, 01:05 PM   #1
Baseband Member
 
Join Date: Nov 2008
Posts: 91
Default how to obtain SQL Server FullText Search service?

I did a full installation of SQL Server 2008 Express. Looking at Add / Remove Programs, I see the following pertinent programs installed:
SQL Server 2008
SQL Server 2008 Browser
SQL Server 2008 Management Objects
SQL Server 2008 Native Client
SQL Server 2008 Setup Support File (English)
SQL Server Compact 3.5 SP1 Design Tools English
SQL Server Compact 3.5 English
SQL Server Database Publishing Wizard 1.3
SQL Server VSS Writer
SQL Server System CLR Types

And of course I also have installed .Net Framework 3.5 SP1.

I'm now trying to obtain sample SQL databases. To this end, and by the advice of others, I'm trying to install SQL2008.AdventureWorks_All_Databases.x86.msi. But whether I try to install "Sample Files" or "Create AdventureWorks DBs", I keep getting the following error:

PrepInstance() failed for MSSQL$SQLEXPRESS.
The following features are missing: Full Text Search

Running services.msc shows the following local services (but not SQL Server FullText Search):
SQL Active Directory Helper Service
SQL Server (SQLEXPRESS)
SQL Server Agent (SQLEXPRESS)
SQL Server Browser
SQL Server VSS Writer

Does anyone know how I can obtain the FullText Search service for SQL Server 2008 Express?
__________________

BobLewiston is offline   Reply With Quote
Old 03-08-2009, 01:18 PM   #2
In Runtime
 
Daeva's Avatar
 
Join Date: Dec 2005
Posts: 407
Send a message via AIM to Daeva Send a message via MSN to Daeva Send a message via Yahoo to Daeva
Default Re: how to obtain SQL Server FullText Search service?

You may be able to manually attach the database by opening up Sql Server Management Studio and right clicking databases and selecting attach.

You can browse here for adventureworks, which should be somewhere like:
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWor ks_Data.mdf

or, you can do a search for all files for *.mdf* and make note of those locations, then attach them to Sql Server in the same way as before once you know where they are located.

Alternatively, you can download the zip file instead of the msi installer which contains all of the databases, then unzip those to wherever you want them. Followed by a manual attach.
__________________

__________________
**Official Self-proclaimed glorified excessive (insert additional adjectives here) post editor/modifier.
Edit = Best feature ever
http://www.twitter.com/xDaevax
Daeva is offline   Reply With Quote
Old 03-09-2009, 06:58 AM   #3
Site Team
 
root's Avatar
 
Join Date: Mar 2004
Posts: 8,004
Default Re: how to obtain SQL Server FullText Search service?

did you install the full text search component.


full text search runs as a service, so the reason that you can't install the database from the MSI is their pre-requisite checks fail cause they can't find the full text search component.

Perhaps go back to the SQL 2008 installer and see if you've missed off full text search. It's possibly a feature you have to drill down the install options box to look for.
__________________
I didnít fight my way to the top of the food chain to be a vegetarianÖ
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
root is offline   Reply With Quote
Old 03-09-2009, 01:24 PM   #4
In Runtime
 
Daeva's Avatar
 
Join Date: Dec 2005
Posts: 407
Send a message via AIM to Daeva Send a message via MSN to Daeva Send a message via Yahoo to Daeva
Default Re: how to obtain SQL Server FullText Search service?

I don't know if you can install full text search in the express version...? I'll have to do some digging on that.
__________________
**Official Self-proclaimed glorified excessive (insert additional adjectives here) post editor/modifier.
Edit = Best feature ever
http://www.twitter.com/xDaevax
Daeva is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 10:46 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0