Issue

The SQL Server 2008 R2 Reporting Services (SSRS) AdventureWorks sample reports do not run and you receive the message “Cannot create a connection to data source AdventureWorks2008R2”.
  

Installation of AdventureWorks 2008 R2 RTM Sample Databases

The download package, AdventureWorks2008R2_RTM.exe, available on CodePlex (Sample Databases for Microsoft SQL Server 2008R2 (RTM)), includes three versions of the Adventure Works databases:

·         AdventureWorksLT2008R2 (the light weight version with a simpler schema)

·         AdventureWorksDW2008R2 (the data warehouse version)

·         AdventureWorks2008R2 (the online transaction processing (OLTP) version that the AdventureWorks sample reports use)

·         Full-Text Search is installed

·         SQL Full-text Filter Daemon Launcher is running

·         FILESTREAM is enabled

Installing Sample Databases on SQL Server 2008 R2 Express

View Reports Successfully

Reports are designed to work with AdventureWorks2008R2. Updating the data sources of will not solve the problem. These databases have different schemas (for example, tables and columns have different names) and the report queries do not work with them. You must install AdventureWorks2008R2 to run the reports.

Your Reporting Services Reports Displays Different or No Data

The date/time data in the AdventureWorks2008R2 database has changed from earlier versions of the database. Four years were added to date/time column values. If your reports, use parameters or filters set by date/time values, the data that displays in the reports might be different or the report might be blank.  

Showcase Localized Data in Reports

Additional localized product descriptions have been added to the AdventureWorksDW2008R2 database. The data is in the FactAdditionalInternationalProductDescription table. The addition of this table does not affect reports that use the AdventureWorksDW2008R2 database. They continue to run without modification.