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

value="Adventure works 2008 installation SQL Server samples">

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:

• href="http://mosshowto.blogspot.com/2009/01/integrating-sql-server-2008-reporting.html">Step
  1 - SQL Server 2008 with reporting Services Installation and Configuration
  
  
• href="http://mosshowto.blogspot.com/2009/01/reporting-services-2008-sharepoint-2007.html">Step
  2 - SharePoint Installation
  
• href="http://mosshowto.blogspot.com/2009/01/sharepoint-report-server-2008.html">Step
  3 - Configuring Reporting Services for SharePoint 3.0 Integration - Part 1 :
  Operations performed with Reporting Services Configuration tool
  
• href="http://mosshowto.blogspot.com/2009/01/integrating-ssrs-2008-sharepoint-2007.html">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

• href="http://mosshowto.blogspot.com/2009/02/reporting-services-2008-report.html">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:
  href="http://mosshowto.blogspot.com/2009/01/integrating-sql-server-2008-reporting.html">Step
  1 - SQL Server 2008 with reporting Services Installation and Configuration
  
  
  
• During SQL Server 2008 Installation you have installed Full Text Search
  feature
  
  href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTwQ36XqBZM4YrrKSiVPLIsj2tJhb4_Rq8_B_3Jp25_Vnb0KuCyfVvG38HDuuBmPrFpC7Iv15JnPfQXg3sG_QTbUKf7F5S15ghPXH_A8amlJqFZcVwDYY_lWXZjhg0EfHncylda4X7edY_/s1600-h/SQLServer2008Install_17_01SelectingInstanceFeatures.jpg"> id=BLOGGER_PHOTO_ID_5296779992428819250
  style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 240px"
  alt=""
  src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTwQ36XqBZM4YrrKSiVPLIsj2tJhb4_Rq8_B_3Jp25_Vnb0KuCyfVvG38HDuuBmPrFpC7Iv15JnPfQXg3sG_QTbUKf7F5S15ghPXH_A8amlJqFZcVwDYY_lWXZjhg0EfHncylda4X7edY_/s320/SQLServer2008Install_17_01SelectingInstanceFeatures.jpg"
  border=0>
  
  
  
• You have downloaded one of the href="http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=18407">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

href="#5---SQL-Full-Text-issue-for-SQL-Server-2008-Express-edition">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)

href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbUk5lkefo1JNW6ECTJxLfRN_dvRC1a3fUMIaSzImkz6Kjd8kOZ5jh0MXYVYYbTpx_KQeg8kiCKnTtZNO7rUgJkRv5f6RjZpoLKpkjT8VNNldl7Y3PdUOGbXYSuIT1QACli54Z4_25JG2h/s1600-h/AdventureWorks2008Install_01_Files.jpg">id=BLOGGER_PHOTO_ID_5296779989537487218
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 92px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbUk5lkefo1JNW6ECTJxLfRN_dvRC1a3fUMIaSzImkz6Kjd8kOZ5jh0MXYVYYbTpx_KQeg8kiCKnTtZNO7rUgJkRv5f6RjZpoLKpkjT8VNNldl7Y3PdUOGbXYSuIT1QACli54Z4_25JG2h/s320/AdventureWorks2008Install_01_Files.jpg"
border=0>

2 - Run Setup

href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWIgDIMGPtfGlZLcfml9i46RNEO4rncXTdIVHBdMkTQj-_c5J2NWdevvx7_wuGRAnN5FfilAkI7b8DQqeHdwukMhWsMuEnOEWiacfbPaB4l1X4HAo4cG6W2KwnSMUDIbjX2pLvdyuEoksF/s1600-h/AdventureWorks2008Install_02_RunSetup.jpg">id=BLOGGER_PHOTO_ID_5296779996013073362
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 228px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWIgDIMGPtfGlZLcfml9i46RNEO4rncXTdIVHBdMkTQj-_c5J2NWdevvx7_wuGRAnN5FfilAkI7b8DQqeHdwukMhWsMuEnOEWiacfbPaB4l1X4HAo4cG6W2KwnSMUDIbjX2pLvdyuEoksF/s320/AdventureWorks2008Install_02_RunSetup.jpg"
border=0>

4.2 Step 2 - Pass Welcome page

In the Wizard "Welcome" page click "Next"

href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzRCzfj5wMRRLa1S-oTWB88-jCGZEsRC6-y9cMeK05nCynCOp1aENDjQW3_aK043fOldve7Q2eaf1mEEl6xT56MGwSfQnL5wGxf2zdxOWM6jEkAycVGfaPma6OTys6CWDV9nT_3KWrgfMv/s1600-h/AdventureWorks2008Install_03_SetupWzdWecome.jpg">id=BLOGGER_PHOTO_ID_5296779994710386354
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 250px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzRCzfj5wMRRLa1S-oTWB88-jCGZEsRC6-y9cMeK05nCynCOp1aENDjQW3_aK043fOldve7Q2eaf1mEEl6xT56MGwSfQnL5wGxf2zdxOWM6jEkAycVGfaPma6OTys6CWDV9nT_3KWrgfMv/s320/AdventureWorks2008Install_03_SetupWzdWecome.jpg"
border=0>

4.3 Step 3 - Accept License Agreement terms

Accept the License terms agreement and click "Next"


href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwqHG1FY0P7L4BmDwZY4LsPE4lAdeb5EMTBV4ZtZmDUC-DsEtBbiKY-OFBeTMzAeYr6fbb7g7zJtnlk4KKTtZ43mLvd-q11uq-WxJGW6IuqorwVLoBYDx8Q-imqluPWdThgiQH2GJV8fU4/s1600-h/AdventureWorks2008Install_04_SetupWzdLicenseTerms.jpg">id=BLOGGER_PHOTO_ID_5296779995012328834
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 249px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwqHG1FY0P7L4BmDwZY4LsPE4lAdeb5EMTBV4ZtZmDUC-DsEtBbiKY-OFBeTMzAeYr6fbb7g7zJtnlk4KKTtZ43mLvd-q11uq-WxJGW6IuqorwVLoBYDx8Q-imqluPWdThgiQH2GJV8fU4/s320/AdventureWorks2008Install_04_SetupWzdLicenseTerms.jpg"
border=0>

4.4 Step 4 - Optionally change Custom Set Up

href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifQhEnXm8wRk-uQ5cfzePfw3nHAN3RaIs7sMHOlCScFWm7EZI810tD4vVXeCzR3wL7ERr_EFNqaOxCl0iWEp1xmE1S52v8wh3cu6dsxWdcmCI_EuiF6SvKKCW4vH_uChTGycqkEaUblAYy/s1600-h/AdventureWorks2008Install_05_SetupWzdCstmSetUp.jpg">id=BLOGGER_PHOTO_ID_5296780893038274050
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 246px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifQhEnXm8wRk-uQ5cfzePfw3nHAN3RaIs7sMHOlCScFWm7EZI810tD4vVXeCzR3wL7ERr_EFNqaOxCl0iWEp1xmE1S52v8wh3cu6dsxWdcmCI_EuiF6SvKKCW4vH_uChTGycqkEaUblAYy/s320/AdventureWorks2008Install_05_SetupWzdCstmSetUp.jpg"
border=0>

4.5 Step 5 - Select database Instance

In the drop down list select your Database instance and
click "Next"

href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr_EkuBk5H5lBYHDD9YCukzBuosa_9NGBZ4EygxYT7W1olzbMHbfJ2qoD-LBzhqmIe9LquYElrgGCto0LiG-KUzJEdZKd4LscFFdPhhmRjiJmbiR6ILXOv9n4NCTER1pD0PqH0QSBO_WLf/s1600-h/AdventureWorks2008Install_06_SetupWzdDataBaseSetUp.jpg">id=BLOGGER_PHOTO_ID_5296780892923299458
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 248px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr_EkuBk5H5lBYHDD9YCukzBuosa_9NGBZ4EygxYT7W1olzbMHbfJ2qoD-LBzhqmIe9LquYElrgGCto0LiG-KUzJEdZKd4LscFFdPhhmRjiJmbiR6ILXOv9n4NCTER1pD0PqH0QSBO_WLf/s320/AdventureWorks2008Install_06_SetupWzdDataBaseSetUp.jpg"
border=0>

4.6 Step 6 - Launch Installation

Click "Install".

href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtrptID-pjENCuWiGv7eEXVkK6EbCNfhsC-vXcyjF4rF0TNrmGC-ckT5nB_cTLFvzj1d3IV6VsC1r-HDwC3pknBaj2tJp1zglNlDeY_P85nWXaL_zBpjfTbSobvOIg4pTfAIVRcG9QPfe9/s1600-h/AdventureWorks2008Install_07_SetupWzdReady.jpg">id=BLOGGER_PHOTO_ID_5296780901289645090
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 247px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtrptID-pjENCuWiGv7eEXVkK6EbCNfhsC-vXcyjF4rF0TNrmGC-ckT5nB_cTLFvzj1d3IV6VsC1r-HDwC3pknBaj2tJp1zglNlDeY_P85nWXaL_zBpjfTbSobvOIg4pTfAIVRcG9QPfe9/s320/AdventureWorks2008Install_07_SetupWzdReady.jpg"
border=0>

Wait while Wizard is creating the database samples


href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDsC08cjXbjd54FNMqVx_0lMRhZAsTC8ictSuBtbJtensEaNGPbQimLFD7vmd7W7VfqnsM_7bcqwmNazKjknGv6fwk8Vmhuz_8zCUtirUVJPpHm_IQ7gsa50gUbxX7mWNtGfyDszcRisXO/s1600-h/AdventureWorks2008Install_08_SetupWzdInstlProgress.jpg">id=BLOGGER_PHOTO_ID_5296780901175598818
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 247px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDsC08cjXbjd54FNMqVx_0lMRhZAsTC8ictSuBtbJtensEaNGPbQimLFD7vmd7W7VfqnsM_7bcqwmNazKjknGv6fwk8Vmhuz_8zCUtirUVJPpHm_IQ7gsa50gUbxX7mWNtGfyDszcRisXO/s320/AdventureWorks2008Install_08_SetupWzdInstlProgress.jpg"
border=0>

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."

href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhraPIjrLl94gLyeFkVtr-AhyE79y1IpT9Wflk-yPOB_tzx3qq2pFmr4oYBSln5PRP18DxbdGgJVn4Wshe-n7kmFjy8OAubwr5VgkcTvxpsY7G5hCtwhsW6pXAZw4StlIV3iuZiRlynTZf_/s1600-h/AdventureWorks2008Install_09_1SetupFullTextIssue.jpg">id=BLOGGER_PHOTO_ID_5296780900788018322
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 246px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhraPIjrLl94gLyeFkVtr-AhyE79y1IpT9Wflk-yPOB_tzx3qq2pFmr4oYBSln5PRP18DxbdGgJVn4Wshe-n7kmFjy8OAubwr5VgkcTvxpsY7G5hCtwhsW6pXAZw4StlIV3iuZiRlynTZf_/s320/AdventureWorks2008Install_09_1SetupFullTextIssue.jpg"
border=0>

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

href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjl7GbMKoCOOxBq0hqr6SjUlHKg8ywRu_cPRn6J2bsxhGsHzkVufdub8MihhIcLGwFY-U-Lqcrbr4i0NInfJm6c9XLYFjg4Yztu67VlaDzukg9mhAyMKrr8aVtWjLu45q81rMHRrJgLdMMQ/s1600-h/AdventureWorks2008Install_09_2SetupFullTextIssueOpenSces.jpg">id=BLOGGER_PHOTO_ID_5296782444158754418
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 210px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjl7GbMKoCOOxBq0hqr6SjUlHKg8ywRu_cPRn6J2bsxhGsHzkVufdub8MihhIcLGwFY-U-Lqcrbr4i0NInfJm6c9XLYFjg4Yztu67VlaDzukg9mhAyMKrr8aVtWjLu45q81rMHRrJgLdMMQ/s320/AdventureWorks2008Install_09_2SetupFullTextIssueOpenSces.jpg"
border=0>

2 - Locate SQL Full-text Filter Daemon Launcher Service


href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzw94x2uHgmp6quwho1ueROvxTWiJbhp1V0pZxvtcUoSZt7cKcXRNOWFp0tt2t_8bqsIfkgZj19XWIo_UGcJnpK91h0jrHvFilHDyzV_u5SublA2j_8A3LefhuQ_E8heenaOl2upI7C5K_/s1600-h/AdventureWorks2008Install_10_SetupFullTextIssueSce.jpg">id=BLOGGER_PHOTO_ID_5296782447809812642
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 63px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzw94x2uHgmp6quwho1ueROvxTWiJbhp1V0pZxvtcUoSZt7cKcXRNOWFp0tt2t_8bqsIfkgZj19XWIo_UGcJnpK91h0jrHvFilHDyzV_u5SublA2j_8A3LefhuQ_E8heenaOl2upI7C5K_/s320/AdventureWorks2008Install_10_SetupFullTextIssueSce.jpg"
border=0>

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

href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCkmFp63r6OqxLSDLL35UpINmkNsRF927ng5qtF4NOn7x7jx4tCb3Z-gcpWTHKijvo_EJkMPRI2EKSuYRQ_YJE5zgUd7bexaCpvWfwGgmljGWTJwigpn5xjkPk_zQk1NiPUu3EDLPeFb8P/s1600-h/AdventureWorks2008Install_11_SetupFullTextIssueSceLaunch.jpg">id=BLOGGER_PHOTO_ID_5296782446343374082
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 257px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCkmFp63r6OqxLSDLL35UpINmkNsRF927ng5qtF4NOn7x7jx4tCb3Z-gcpWTHKijvo_EJkMPRI2EKSuYRQ_YJE5zgUd7bexaCpvWfwGgmljGWTJwigpn5xjkPk_zQk1NiPUu3EDLPeFb8P/s320/AdventureWorks2008Install_11_SetupFullTextIssueSceLaunch.jpg"
border=0>

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

href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrvy4q66d1im0_ADbha3TwaaPuWhE4BmsS2Y2dXLZ2qHdImt9AVsChJyI2VoyPTHcRAaYE8a0z1CMYqbtXep0lYizS32U-vdvfA7wUMyzy64lStmVTxaTrohRea8jQvWfplhuMboObqtzF/s1600-h/AdventureWorks2008Install_12_SetupComplete.jpg">id=BLOGGER_PHOTO_ID_5296782449445516210
style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 233px"
alt=""
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrvy4q66d1im0_ADbha3TwaaPuWhE4BmsS2Y2dXLZ2qHdImt9AVsChJyI2VoyPTHcRAaYE8a0z1CMYqbtXep0lYizS32U-vdvfA7wUMyzy64lStmVTxaTrohRea8jQvWfplhuMboObqtzF/s320/AdventureWorks2008Install_12_SetupComplete.jpg"
border=0>

name="5---SQL-Full-Text-issue-for-SQL-Server-2008-Express-edition">5 -
SQL Full Text issue for SQL Server 2008 Express edition

style="PADDING-RIGHT: 5px; PADDING-LEFT: 5px; FONT-WEIGHT: normal; FONT-SIZE: 10pt; PADDING-BOTTOM: 5px; MARGIN: 1px 0px; COLOR: gray; PADDING-TOP: 5px; FONT-FAMILY: arial; TEXT-ALIGN: justify">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:

style="PADDING-RIGHT: 5px; PADDING-LEFT: 5px; FONT-WEIGHT: normal; FONT-SIZE: 10pt; PADDING-BOTTOM: 5px; MARGIN: 1px 0px; COLOR: gray; PADDING-TOP: 5px; FONT-FAMILY: arial; TEXT-ALIGN: justify">
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:

style="PADDING-RIGHT: 5px; PADDING-LEFT: 5px; FONT-WEIGHT: normal; FONT-SIZE: 10pt; PADDING-BOTTOM: 5px; MARGIN: 1px 0px; COLOR: gray; PADDING-TOP: 5px; FONT-FAMILY: arial; TEXT-ALIGN: justify">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.