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

This post is the fifth of a group showing how to use SQL Server 2008 Reporting Services with SharePoint 2007. However, it can be used for itself, independently from the others.
The previous steps are:

• Step 1 - SQL Server 2008 with reporting Services Installation and Configuration
• Step 2 - SharePoint Installation
• Step 3 - Configuring Reporting Services for SharePoint 3.0 Integration - Part 1 : Operations performed with Reporting Services Configuration tool
• Step 4 - Configuring Reporting Services for SharePoint 3.0 Integration - Part 2: Operations performed in SharePoint Central Administration (includes Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies Installation)

The next step is

• Step 6 - Report Creation and Deployment in SharePoint 2007 with Business Intelligence Development Studio (BIDS)

 

 

2- Prerequisites

• You have installed SQL Server 2008 on the virtual machine with a Windows 2003 Server OS.
  if not you can refer to the step 1 of these articles group:
  Step 1 - SQL Server 2008 with reporting Services Installation and Configuration
  
• During SQL Server 2008 Installation you have installed Full Text Search feature
  
  
  
  
• You have downloaded one of the SQL2008.AdventureWorks_All_Databases.xXX.msi depending on your system configuration

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.