Link to home
Create AccountLog in
Avatar of vbchewie
vbchewieFlag for United States of America

asked on

Where can I get a copy of the AdventrureWorks2008R2 database?

I'm trying to get the sample SQL Server 2008 R2 Reports loaded so I can learn more about what the SSRS reports can do.  I've downloaded the sample R2 reports from here.
http://msftrsprodsamples.codeplex.com/

I've loaded the sample R2 database from here.
http://msftdbprodsamples.codeplex.com/

When I install the database these are the only database I get.
AdventureWorks
AdventureWorksDW
AdventureWorksDW2008R2
AdventureWorksLT
AdventureWorksLT2008R2
The sample reports are looking for the database named "AdventureWorks2008R2", and because I have no database by that name I tried pointing to the database I do have.

If I change it to point to:
AdventureWorks
Instead it tells me:
Invalid column name 'BusinessEntityID'.

If I change it to point to one of these instead:
AdventureWorksDW
AdventureWorksDW2008R2
AdventureWorksLT
AdventureWorksLT2008R2
It tells me
Invalid object name 'Sales.SalesPerson'.

Where or how do I get a copy of the AdventureWorks2008R2 that has all of the correct tables and columns so the I can view the sample reports.

Thank You,

Avatar of Rahul Agarwal
Rahul Agarwal
Flag of India image

you can use the following link

http://msftdbprodsamples.codeplex.com/releases/view/55926

and download AdventureWorks2008R2_SR1.exe and follow the instructions on

http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20SQL%20Server%202008R2%20Databases
Avatar of vbchewie

ASKER

Sorry I see I put the same link in twice.  I did get the database from
http://msftdbprodsamples.codeplex.com/releases/view/55926
and I only get these database

AdventureWorks
AdventureWorksDW
AdventureWorksDW2008R2
AdventureWorksLT
AdventureWorksLT2008R2

Not the AdventureWorks2008R2 that the sample reports are referring to.
SOLUTION
Avatar of Rahul Agarwal
Rahul Agarwal
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of GKalosky
GKalosky

Is there an SQL 2008 R2 RTM version or do I need to do a cumulative update?  I get this error when I try to attach the database.

The database 'AdventureWorks2008R2' cannot be opened because it is version 679. This server supports version 661 and earlier. A downgrade path is not supported.
Yes, SQL Server 2008 is a new version of SQL Server, it does not refer so a Service Pack level of SQL Server 2008.  You must be running SQL Server 2008 R2 for this database to work.  When you install it, be sure to do the SQL Reporting component install to be able to run SQL Reporting on the server.
I am on R2 the SQL version on the server is 10.50.1600
Then try this CU which is the latest in case the database was created under a later CU and the notes were not included on the codeplex site.

http://support.microsoft.com/kb/2345451/
Even after I apply the CU (Now version 10.50.1746) I still get this error when trying to attach the database:

The database 'AdventureWorks2008R2' cannot be opened because it is version 679. This server supports version 661 and earlier. A downgrade path is not supported.
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I just downloaded Denali and installed it on virtual box.  It allowed me to play with the examples and see how they performed.  Good enough for what I was trying to get out of it.

Happy Holiday.