• Article

Considerations for Installing SQL Server Samples and Sample Databases (Report Builder 2.0)

The code samples and sample databases for SQL Server are not included with the product. Instead, you can locate and download the samples and sample databases from the Microsoft SQL Server 2008 Community Projects & Products Samples Web page on CodePlex at https://www.codeplex.com/sqlserversamples. On this page the samples are grouped into categories. For example, Microsoft SQL Server Reporting Services is a category. You can download samples for a specific category or all samples.

The tutorials and most of the sample reports use the AdventureWorks or AdventureWorks2008 sample databases. The sample reports will not run without the relevant database installed on a computer users can access and users will not be able to do the tutorials. For Report Builder 2.0 sample reports and tutorials, you need only install AdventureWorks2008. You must have permission to access the databases before you can use them. The samples include the AdventureWorksOffline reports. These reports do not use external data and have no dependency on the AdventureWorks2008 database.

You can install a specific database or the family of AdventureWorks databases.

The following URLs directly access Reporting Services samples and sample databases:

Downloading Samples and Sample Databases

CodePlex includes samples and sample databases for current and past releases of SQL Server. You can download all samples or samples related to a specific SQL Server component such as Reporting Services and a database from AdventureWorks family of sample databases.

To download all SQL Server 2008 samples

  1. Go to the Microsoft SQL Server 2008 Community Projects & Products home page.

  2. Click the link, "Download all the samples together".

To download Reporting Services specific samples

  1. Go to the Microsoft SQL Server 2008 Community Projects & Products home page.

  2. Click the category link, "Microsoft SQL Server Reporting Services".

  3. In the Microsoft SQL Server Reporting Services section, click the link, "Download".

  4. On the Microsoft SQL Server 2008 Reporting Services Product Samples page, in the Downloads & Files list, click the processor version you want download. Downloads for x86, x64, and Itanium processors are available.

    Note

    By default, the sample files are installed in the following location: C:\Program Files\Microsoft SQL Server\100\Samples\ReportingServices.

To download a database from the AdventureWorks family of databases

  1. Go to the Microsoft SQL Server 2008 Community Projects & Products home page.

  2. Do one of the following:

    • Click the link, "Download the AdventureWorks family of samples".

    • Click the category link, "Sample Databases".

  3. In the Samples Database section, click the link, "Download".

  4. On the Microsoft SQL Server 2008 Database Product Samples,in the Dowloads & Files list,click the database and processor version you want download.

    Note

    For Report Builder 2.0 samples and tutorials, click the link,"SQL2008.AdventureWorks OLTP DB".

To download samples from previous releases of SQL Server

  1. Go to the Microsoft SQL Server 2008 Community Projects & Products home page.

  2. Click the Releases tab.

    Note

    The default release is the most current release.

  3. In the Releases pane, click the release for which you want to download samples.

  4. In the Downloads & Files list, click the processor version of the samples you want download.

Installing AdventureWorks2008

Full-text search is integrated into AdventureWorks2008 and full-text search must be installed. Also, because AdventureWorks2008 uses FILESTREAM.

To install AdventureWorks2008

  1. The installer runs. Depending on the operating system installed, you might be prompted to confirm the file download and installation. If prompted, click Run.

  2. In the Microsoft SQL Server AdventureWorks OLTP (v2008) RTM Samples <processor version> Setup Wizard, click Next.

  3. Accept the license agreement and click Next.

  4. On the Custom Setup page, click the icon for Restore AdventureWorks2008 (OLTP) and select Will be installed on local hard drive.

  5. Click Next.

  6. On the Database Setup page, in the Select Local Database Instance for AdventureWorks drop-down list, select the instance on which to install the database.

  7. Click Next.

  8. Click Install.

  9. Click Finish.

Enabling FILESTREAM

You need to enable FILESTREAM in two places: SQL Server Configuration Manager and SQL Server Management Studio. In SQL Server Management Studio, you can either enable FILESTREAM in the Properties dialog box or run a Transact-SQL statement in query window. After you make the changes, restart the Database Engine.

To enable FILESTREAM in SQL Server Configuration Manager

  1. On the Start menu, point to All Programs, point to SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.

  2. In the list of services, right-click SQL Server Services, and then click Open.

  3. In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.

  4. Right-click the instance and click Properties.

  5. In the SQL ServerProperties dialog box, click the FILESTREAM tab.

  6. Select the Enable FILESTREAM for Transact-SQL access check box.

  7. If you want to read and write FILESTREAM data from Windows, click Enable FILESTREAM for file I/O streaming access.

  8. Optionally, update the default value the Windows share name text box. This is the share that contains the FILESTREAM data.

  9. If remote clients must access the FILESTREAM data that is stored on this share, select Allow remote clients to have streaming access to FILESTREAM data.

  10. Click Apply.

To enable FILESTREAM in SQL Server Management Studio using the Properties dialog box

  1. On the Start menu, point to All Programs, point to SQL Server 2008, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, select Database Engine in the Server type drop-down list.

  3. In the Server name drop-down list, select the instance of the SQL Server Database Engine to connect to. This is the instance on which you will install the AdventureWorks2008 database.

  4. If the authentication type is SQL Server Authentication, provide the user name and password.

  5. Click Connect.

  6. Right-click the instance of SQL Server you want and click Properties.

  7. In the Select a page pane, click Advanced.

  8. Set the Filestream Access Level property to Full access enabled.

  9. Click OK.

To enable FILESTREAM in SQL Server Management Studio using a Transact-SQL statement

  1. Open SQL Server Management Studio.

  2. In the Connect to Server dialog box, select Database Engine in the Server type drop-down list.

  3. In the Server name drop-down list, select the instance of the SQL Server Database Engine to connect to. This is the instance on which you will install the AdventureWorks2008 database.

  4. If the authentication type is SQL Server Authentication, provide the user name and password.

  5. Click Connect.

  6. In SQL Server Management Studio, click New Query.

  7. Paste the following statement into the query window:

    EXEC sp_configure ‘filestream_access_level’, ‘[access_level]’

    RECONFIGURE

    Note

    Set the access level to 1 or 2, depending on your access needs. Valid values of access level are as follows:

    0 Disables FILESTREAM support for this instance.

    1 Enables FILESTREAM for Transact-SQL access.

    2 Enables FILESTREAM for Transact-SQL and Win32 streaming access.

  8. .Click Execute to run the statement.

Installing Sample Reports on the Report Server

The Readmes, available on CodePlex and in SQL Server Books Online, provide installation information for the sample reports. Sample reports were created in a Business Intelligence Development Studio Reporting Services project within a solution. To make the sample reports available on the report server you need to open the reports in Business Intelligence Development Studio and publish the reports to a report server by using the Business Intelligence Development Studio deployment features.