Thursday, January 29, 2009

Installing SQL Server 2008 samples: Adventure works (Integrating Reporting Services 2008 with SharePoint 2007 Step 5)

Integrating Reporting Services 2008 with SharePoint 2007 Step 5 - Installing SQL Server 2008 Samples: Adventure Works

Introduction

 
 
2- Prerequisites
3 - Installation Overview

Notice that even you have installed Full Text Search feature you may have an issue because SQL Full-text Filter Daemon Launcher service is disabled and stopped.
Because I take into account that the issue may occur, the installation steps are:
  • Step 1 - Run Installation Wizard
  • Step 2 - Pass Welcome page
  • Step 3 - Accept License Agreement terms
  • Step 4 - Optionally change Custom Set Up
  • Step 5 - Select database Instance
  • Step 6 - Launch Installation
  • Step 7 - Optionally get Full Text Search Issue Message
  • Step 8 - Optionally enable and startSQL Full-text Filter Daemon Launcher Service
  • Step 9 - Optionally restart installation
  • Step 10 - Check Created Databases and Close Installation Wizard
If you are using SQL Server 2008 Express edition and had the SQL Full Text issue read this section

4 - Installation
4.1 Step 1 - Run Installation Wizard


1 - Open the file where you have stored the downloaded executable for SQL 2008 Samples installation (SQL2008.AdventureWorks_All_Databases.xXX.msi)



2 - Run Setup



4.2 Step 2 - Pass Welcome page
In the Wizard "Welcome" page click "Next"



4.3 Step 3 - Accept License Agreement terms
Accept the License terms agreement and click "Next"



4.4 Step 4 - Optionally change Custom Set Up



4.5 Step 5 - Select database Instance
In the drop down list select your Database instance and click "Next"



4.6 Step 6 - Launch Installation
Click "Install".



Wait while Wizard is creating the database samples



4.7 Step 7 - Optionally get Full Text Search Issue Message
You may see appear this issue pop up : "PrepInstance() failed for ... The following features are missing: Full Text Search Fix the problem and re-run setup."



4.8 Step 8 - Optionally enable and start SQL Full-text Filter Daemon Launcher Service
1 - Open the Services Microsoft Management Console.
In start menu point to Administrative Tools, click Services



2 - Locate SQL Full-text Filter Daemon Launcher Service



3 - Enable and start SQL Full-text Filter Daemon Launcher Service
Right click the Service row, enable it (automatic or manual) and start it.



4.9 Step 9 - Optionally restart installation
If you had Full Text Search Issue and had to re-start SQL Full-text Filter Daemon Launcher Service, re-start installation from Step 1.
4.10 Step 10 - Check Created Databases Close Installation Wizard
You can check databases creation with SQL Server Management Studio and close the Wizard




5 - SQL Full Text issue for SQL Server 2008 Express edition

This explanation of going through SQL Full Text issue for SQL Server 2008 Express edition was left by an anonymous reader as a comment of this post. Thanks you to him (her).

Prerequistes:

download this edition of SQL Server Express: Microsoft® SQL Server® 2008 Express with Advanced Services that is the version with the Full Text Search Service included.

Configuration:

1 - choose Microsoft Sql Server 2008, Configuration Tools, Sql Server Configuration Manager, Sql Server Services
2- then right click on SQL Full-text Filter.
You will notice that no start options are enabled.
3 - Choose Properties
4 - then choose the Service tab.
5 - Then change the Start Mode to Manual and then hit Apply.
6 - Then go back to right clicking the SQL Full-text Filter and the Start option will be enabled.
7 - Choose it then go back and download the databases again.


20 comments:

Anonymous said...

thank you for your very kind and detailed full-text search issue solution!

Anonymous said...

Thanks for the solution. Wondering why MS couldn't have told us this.

Anonymous said...

Thanks...very helpful

Ani said...

Ah what would I have done without your solution to the Full Text Search problem? A thousand thank-yous!

Anonymous said...

Thank you very much for the workaround to full-text search issue.

Anonymous said...

Thanks a lot! I tried many time and couldn't solve it. Now my problem is solved with your detailed explanation. Many thanks...

Anonymous said...

Thanks! I got the AdventureWorks databases successfully installed.

Anonymous said...

Thank you for the detailed instructions.

Anonymous said...

You Rock ! ... this should be part of Read me doc !

Anonymous said...

The Adventure works databases do not show in SQL (even after a refresh). The .mdf file is no where to be found. I get no error message on the install. Any suggestions?

Anonymous said...

Thanks a lot...this really shud be a part of online help of microsoft...

Marc Charmois said...

Hey tree, I think that there must be an error message there somewhere... Did you verify the Event Viewer?
Did you verify Sql Server logs? Do you work on a Virtual Machine or a physical one?
If you work on a Virtual Machine, for me it is a grave case of bad configuration and generally I drop the involved virtual machine and begin a clean installation on a new machine...
If you cannot read any error messages anywhere, if you want to install these samples on this machine anyway, I have an Extreme Solution...
Download this tool:
Less MSIĆ©rables
Use it to extract all the files of the Samples Installation .msi.

Inside the folder where you extracted the .msi, you will find very interesting things, as schemas of databases in pdf format, an SSIS solution and all the tables in csv format with .sql files for the installation.
I hope that you can manage to make work these samples that way, or trying that way will make you discover the configuration problem of your environment.

Anonymous said...

Thanks. This made for quick troubleshooting.

Anonymous said...


Thank you. It was very helpful. The only thing is I was using SQL Server Express so I had to look up online help to know where to go.
The following steps: choose Microsoft Sql Server 2008, Configuration Tools, Sql Server Configuration Manager, Sql Server Services then right click on SQL Full-text Filter. You will notice that no start options are enabled. Choose Properties then choose the Service tab. Then change the Start Mode to Manual and then hit Apply. Then go back to right clicking the SQL Full-text Filter and the Start option will be enabled. Choose it then go back and download the databases again.

Marc Charmois said...

Hi,

thank you very much for this contribution!

I was sometimes planning to put an adding to my post regarding SQL Server Express, but had no time to perform complete research on the topic.
I will put your comment in my post except if you have a blog and want to publish it in your blog, in this case send me the link.
Have a very good day.

Marc

Saurabh Dwivedy said...

Hi - I need some help here. When i follow the following steps
Choose Microsoft Sql Server 2008, Configuration Tools, Sql Server Configuration Manager, Sql Server Services:
I DO NOT SEE THE SQL FULL TEXT FILTER THAT YOU TALK ABOUT. I only see three options SQL SERVER(SQLEXPRESS), SQL SERVER AGENT(SQLEXPRESS), SQL SERVER BROWSER.

Is there some problem with my basic installation of SQL SERVER 2008 Express edition?? Any help would be appreciated.

Marc Charmois said...

Hi Saurabh,

I am sorry, regarding SQL Server Express, I did not perform installation myself, but just put in the post a comment from a user.

But, reading all the comments of the samples I found this:

Also ran into the issue with the "you need text search/reporting features" -- go to www.microsoft.com/express/sql and install the sql express with Advanced

So it seems you maybe have not installed sql express with Advanced Services.
Here is the link: http://www.microsoft.com/downloads/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

Would you tell me if it was the cause of your problem...

Good luck.

Marc

Tom Ritchie said...

I'm having the same problem that the previous poster Saurahb had. I see no "SQl full text filter" only the three fields he describes and I'm sure that I installed SQL express with advanced services. Any further advice or comments?

Marc Charmois said...

Hi Tom,

I am sorry to know that you have installed SQL express with advanced services and have the issue.
As I told to Saurabh, regarding SQL Server Express, I did not perform installation myself.
I should take some time and test it myself...

If you or someone find a solution before, please let us know.

Thank you.

Marc

Anonymous said...

Thanks a lot!!!

This was a life saver :)