SQL2008.AdventureWorks install problem

Expand Post »

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

I already have installed on my PC:
Microsoft SQL Server 2008
Microsoft SQL Server 2008 Browser
Microsoft SQL Server 2008 Management Objects
Microsoft SQL Server 2008 Native Client
Microsoft SQL Server 2008 Setup Support File (English)
Microsoft SQL Server Compact 3.5 SP1 Design Tools English
Microsoft SQL Server Compact 3.5 English
Microsoft SQL Server Database Publishing Wizard 1.3
Microsoft SQL Server VSS Writer

Any suggestions?

BobLewiston

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

105 posts
since Nov 2008

Permalink

Mar 8th, 2009

Re: SQL2008.AdventureWorks install problem

I remember with SQL Server 2005 Express, Microsoft had a separate install package that did not include the Full-Text support. You may want to check for a SQL Server 2008 package that includes Full-Text services. You can double check to make sure Full Text is installed by going to Start -> Run and type "services.msc" and find this service "SQL Server FullText Search." This will tell you if it is installed or not.

Hope this helps,
GM

Geek-Master

Reputation Points: 12

Solved Threads: 6

Junior Poster

Offline

156 posts
since Dec 2004

Permalink

Mar 8th, 2009

Re: SQL2008.AdventureWorks install problem

Geek-Master:

services.msc shows:

SQL Active Directory Helper Service
SQL Server (SQLEXPRESS)
SQL Server Agent (SQLEXPRESS)
SQL Server Browser
SQL Server VSS Writer

but not SQL Server FullText Search. Do you (or does anyone else) know how I can obtain the FullText Search service?

BobLewiston

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

105 posts
since Nov 2008

Permalink

Jul 15th, 2009

Re: SQL2008.AdventureWorks install problem

Thread a bit old, but this will be usefull for others who see it.
SQL Server 2008 Express edition does not have Full Text Index service, the solution is downloading the Advanced Services version.
http://www.microsoft.com/downloads/d...displaylang=en
The size is far bigger from the standard edition, but it includes some nice features.

Gustavo MPO

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jul 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: selecting internal records

Next Thread in MS SQL Forum Timeline: Join on possible empty table

DaniWeb Message

Cancel Changes

User Name
Password