Installation Prerequisites for the SQL Server 2008 and 2008R2 Sample Databases

Before you install the AdventureWorks 2008 and 2008R2 family of sample databases:
  • Some edition of SQL Server 2008 or SQL Server 2008R2 must be installed.
  • If installing on Windows XP or Windows Server 2003, the SQL Server service account must be something other than NT Authority\Network Service (Local System will do).
  • You must install using an account with sysadmin privileges on the instance where you want to install the sample databases.

In order to be able to successfully install the AdventureWorks2008 or AdventureWorks2008R2 (OLTP) database the following additional requirements must be met:
  • At least SQL Server Express with Advanced Services must be installed. Ordinary SQL Server Express will not work. You can download SQL Server 2008 Express with Advanced Services from the Microsoft Download Center.
  • FILESTREAM must be enabled and the SQL Full-text Filter Daemon Launcher service must be running. See below for how to configure these features.

In order to successfully deploy the Analysis Services databases after installation, SQL Server Standard, SQL Server Enterprise, or SQL Server Developer are required. Note that this deployment must be done manually using Business Intelligence Development Studio after installation is complete.

How to install the prerequisites on an existing installation of SQL Server

Installing Full-Text Search

Note If Full-Text Search is already installed, but the SQL Full-text Filter Daemon Launcher service is not running, the installation will fail with a message that the Full-Text Search feature is missing. Therefore, if you already have Full-Text Search installed, follow the procedure to enable the SQL Full-text Filter Daemon Launcher Service.
  1. To install Full-Text Search, you must run SQL Server Setup. When you do, select the New SQL Server stand-alone installation or add features to an existing installation installation option.
  2. When you get to the Installation Type page, select Add features to an existing instance of SQL Server 2008, select the instance name, and then click Next.
  3. When you get to the Feature Selection page, under the Instance Features/Database Engine Services node, select the Full-Text Search check box, click Next, and then complete the rest of the pages in the wizard.

Enabling the SQL Full-text Filter Daemon Launcher Service

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.
  2. In the left pane, click SQL Server Services.
  3. In the list of services, right-click SQL Full-text Filter Daemon Launcher for the instance that you are configuring, and then click Properties.
  4. Click the Service tab.
  5. Next to Start Mode, click Disabled, and then click Automatic in the list that appears.
  6. Click OK.
  7. Right-click SQL Full-text Filter Daemon Launcher for the instance that you are configuring, and then click Start.

Enabling FILESTREAM

For information about how to enable FILESTREAM, see “How to: Enable FILESTREAM” in SQL Server Books Online. Note the following additional information:
  • Steps 7 and 8 are optional. If you find that you need to enable FILESTREAM for file I/O streaming access, you can enable this option later.
  • In step 11, the example sp_configure statement shows how to enable FILESTREAM for both Transact-SQL access and for file I/O streaming access. To enable FILESTREAM for Transact-SQL access only, issue the following statements:
EXEC sp_configure filestream_access_level, 1
RECONFIGURE

For more information about the access levels, see “filestream access level” in SQL Server Books Online.

How to install the prerequisites on a new installation of SQL Server

If you want to install the prerequisites at the same time that you install a new instance of SQL Server, note the following information:
  1. You must install Full-Text Search during SQL Server Setup. To do this, when you get to the Feature Selection page of the Setup wizard, under the Instance Features/Database Engine Services node, make sure that the Full-Text Search check box is selected.
  2. You can enable FILESTREAM during installation. To do this, follow these steps:
    1. When you get to the Database Engine Configuration page, after you configure account provisioning and data directories, click the FILESTREAM tab.
    2. Select the Enable FILESTREAM for Transact-SQL access check box, and then click Next. (Note that if you use a sample that requires file I/O streaming access, you can enable the Enable FILESTREAM for file I/O streaming access option later. Also note that if you enable FILESTREAM during SQL Server Setup, you do not have to run the sp_configure stored procedure with the filestream_access_level option to enable FILESTREAM.)
  3. After the installation, you must enable the SQL Full-text Filter Daemon Launcher service.

Last edited Nov 8, 2010 at 7:42 PM by bonniefe, version 4

Comments

Dragonvic Dec 29, 2011 at 1:33 PM 
FILESTREAM cannot be enabled on my NEW installation of the SQL Sever TRIAL.

There are no options when I go to the proprerties.

Any suggestions?

crossman Dec 7, 2011 at 3:05 PM 
For those who have trouble getting filestream enabled, you must use a domain account for the SQL Service or this will not work. There are no warning or error messages when you configure this using sp_configure.

clivestrong Aug 28, 2011 at 11:21 AM 
Try this - Open up configuration manager and open the SQL Server Services. Right click your SQL Server Service and go to Properties. Click the FILESTREAM tab and enable the FileStream for T-SQL access. I also enabled the IO streaming access.

LittleHorse Jun 23, 2011 at 2:23 AM 
Use AdventureWorks2008R2_SR1.exe,Next and Next ,install succes.don't enable nothing!

FruMurphy Jun 18, 2011 at 11:30 PM 
I've run up against the same as basba. I've pulled from the same website as clairestreb has indicated but I am unable to find the service "SQL Full-text Filter Daemon Launcher ". I have selected to install all choices. My only guess is that the 32 bit vs. 64 may be different. I'm running Win7Enterprise 32.

rhodrie Jun 13, 2011 at 10:27 AM 
2nd point above: "If installing on Windows XP or Windows Server 2003, the SQL Server service account must be something other than NT Authority\Network Service (Local System will do)." is vital!

tracyk859 Nov 8, 2010 at 2:13 AM 
Thanks for the post.
Hi guys, Im a newbie. Nice to join this forum.


_________________
http://moviesonlinefree.biz

JeffLann Oct 31, 2010 at 6:01 PM 
I'm not seeing Full text search as an option. Here is my setup: SQL Express 2008 was installed on my Win7 64-bit during installation of SharePoint 2010. I subsequently installed SQL Express 208 R2. I now want to install the AdventureWorks DB which requires Full text search. I downloaded the 64 bit installer that includes the Advanced Services. I run the installer per the directions on this page, but there is no option in the dialog to add Full text search. Anyone have any suggestions?

G1 Oct 10, 2010 at 7:39 AM 
To enable FullText Search....
run the Sql Server Installation Center" available in Configuration Tools" of the "Microsoft Sql Server 2008R2" programs group. Select the "Installation" category and "New installation or add..." You will need the Sql Server media or in my case a DVD Image referenced by MagicISO. The process examines your existing installation for suitability and downloads any need patches prior to allowing you to modify the existing configuration. After updating the installation and without notification of completion of that process, it will may prompt you to enter an instance name for a new installation at which point you can select to cancel the process.

To enable the FILESTREAM option...
my experience was that after enabling the FILESTREAM option (Configuration Manager, right click instance, select properties, select Advanced paged); ensuring that the launch service is configured to start "automatically" and is running (Sql Server Configuration Services (local)-> Sql Server Services-> Sql Full-text Filter....); and restarting the server, the "running" status of the FILESTREAM option remain disable (there is a configuration/running button at the bottom of the settings page). However, the installation proceeded and appear to be successful. Perhaps rebooting my computer will update this value's running status.

persiannet Aug 29, 2010 at 1:35 AM 
OLTP over up my job

clairestreb Aug 11, 2010 at 7:27 AM 
basba, I use SQL Server 2008 R2 Express, and I downloaded Database with Advanced Services from http://www.microsoft.com/express/Database/InstallOptions.aspx, which is the only Express version that contains Full-Text Search

basba Jul 29, 2010 at 1:07 AM 
I can't find the "Full-Text Search " anywhere ?????? I only found the FileStream and that's it,, the full text-search is not under any node

peterbernhardt Jun 22, 2010 at 1:28 PM 
acorum1, I had the same problem. But then I went back and followed the instructions in “How to: Enable FILESTREAM”. You need to enable FILESTREAM in the Sql Server Configuration Manager. Restart the SQL Server instance and you should be good to go.

acorum1 Jun 21, 2010 at 9:48 PM 
Yea, did all this. Filestreamis up and running. Still won't install AdventureWorks OLTP 2008R2: Says it is not enabled.