SQL: How to install the AdventureWorks2008R2 sample database and sample reports

Installing AdventureWorks2008R2 database:

1. Download AdventureWorks2008R2 sample database from:
• http://msftdbprodsamples.codeplex.com/releases/view/93587
2. Now Open the instance MSSQLSERVER using SQL Server Management Studio
3. From the Database object explorer 
• Select the Databases folder-->Right click and select Attach
• Click on the Add button-->Browse to your AdventureWorks2008R2_Data.mdf file and click Ok button. It will import the AdventureWorks2008R2 database

Installing AdventureWorks2008R2 Sample Reports:

1. You can Download AdventureWorks2008R2 sample reports from:
• http://sqlserversamples.codeplex.com/
2. Normally AdventureWorks SampleReports are available in C:\Program Files\Microsoft SQL Server\100\Samples\Reporting Services\AdventureWorks Sample Reports folder
3. Open the SQL server 2008 R2 Business Intelligence Development Studio and go to File-->Open-->Project/Solution browse to folder you have the sample reports and select the solution.