Installing AdventureWorks2008 (SQL Server Video)

Video Summary

This video shows you how to install the Adventure Works 2008 sample databases.

Video Transcript

Hello, my name is Kelly Wilson. I am a programming writer for SQL Server. In this video, I am going to show you how to install the Adventure Works 2008 sample databases.

The Adventure Works 2008 sample databases require FILESTREAM to be enabled. SQL Server Books Online describes how to enable FILESTREAM in How to: Enable FILESTREAM.

First, I will use SQL Server Configuration Manager to enable FILESTREAM on the instance of SQL Server where I want Adventure Works 2008 installed.

• Click Start, All Programs, Microsoft SQL Server 2008, Configuration Tools, SQL Server Configuration Manager.
• Right click SQL Server Services and select Open. This will display the list of available instances of SQL Server .
• Right click the instance of SQL Server that you want to enable for FILESTREAM and select Properties.
• Click the FILESTREAM tab.
• Select Enable FILESTREAM for Transact-SQL access.
• Click OK to apply the change.

Now, I will enable FILESTREAM on the SQL Server client by using SQL Server Management Studio.

• Click Start, All Programs, Microsoft SQL Server 2008, SQL Server Management Studio.
• Log onto the instance of SQL Server that you want to enable for FILESTREAM. Right-click the instance of SQL Server and select Properties.
• Click the Advanced tab.
• Click the Filestream Access Level item.
• Click Transact-SQL Access Enabled.
• Click OK, and then close SQL Server Management Studio.
• Right click the instance of SQL Server in SQL Server Configuration Manager, and then click Restart.

FILESTREAM is now enabled on the instance of SQL Server where I want Adventure Works 2008 installed.

Next, I will show you how to download and install Adventure Works 2008. The Adventure Works 2008 sample databases are available from the Microsoft open source project CodePlex.

• Connect to https://www.codeplex.com/SqlServerSamples.
• Click the Download the AdventureWorks family of sample databases link.
• Click the link that is most appropriate for your version of SQL Server.
• Read and accept the license agreement.
• Click Run in the File Download dialog box.
• Click Run in the Internet Explorer - Security Warning dialog box.
• Follow the Installation Wizard to complete the installation of the Adventure Works 2008 sample databases.

Thank you for watching this video. We hope that you have found this of value, and will return to the Web site to view other SQL Server videos.