I can't find AdventureWorks2008

Question

Hi ,

in this article : (Reporting Services Tutorial) http://msdn.microsoft.com/en-us/library/ms166599%28v=SQL.100%29.aspx ,

it's needed to select AdventureWorks2008 as underlying database ,

I've already downloaded AdventureWorks2008R2_RTM.exe from Codeplex and installed it , but I can't find AdventureWorks2008 in the list of installed databases (although AdventureWorksDW2008 and some others are installed but there is no AdventureWorks2008 ! )

Should i install any other file instead of AdventureWorks2008R2_RTM.exe ???

Please help me ASAP :(

Thanks

Answer 1

The .exe that you ran displays the databases to be installed and allows you to select the databases.  So, perhaps you didn't select AdventureWorks2008, or perhaps it wasn't available for selection because you do not have the right prerequisites in place to run that database.  Both AdventureWorks2008 and AdventureWorks2008R2  require that you have full-text installed and filestream enabled.  See Database Prerequisites for steps to take before installing the databases.

If you have met the prerequistes, you can run the .exe again and it should list the appropriate databases.  Alternatively, you can run the AdventureWorks2008 installation program directly from here:  http://msftdbprodsamples.codeplex.com/releases/view/37109   Note that the same prerequisites must be met for this installation package to succeed. 

Regards,

Gail

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Hi aryan

I was wondered, if you can send me the AdventureWorks2008R2_RTM.exe, because i can't found it on the web, the link they give me is

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

and there isn't the file i need, my e-mail is [e-mail], thanks in advance

best regards.

Answer 3

hi aryan, saboseo

see Derrick's last posting in the pinned thread http://social.msdn.microsoft.com/Forums/en-US/sqlserversamples/thread/9dd84ee1-8a97-49a1-8f4b-ab0fad4e0d9d

in addition:

if you are using SQL Server 2008 you need to use the setup for SQL 2008 - you'll find the db script in Derrick's posting

if you're using SQL Server 2008R2 you need to use the setup for SQL Server 2008R2 - you'll find the setup here http://msftdbprodsamples.codeplex.com/ - click on button SQL Server 2008 R2 OLTP.

if you're using SQL Server 2012 you need to use the setup for SQL Server 2012 - - you'll find the setup here http://msftdbprodsamples.codeplex.com/ - click on button SQL Server 2012 OLTP.

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 4

Hello,

The AdventureWorks2008R2 database files is at http://msftdbprodsamples.codeplex.com/downloads/get/198008. When using this option, you will need to remove the SQL Server Log file in the SQL Management Studio attach file dialog box.

See http://social.technet.microsoft.com/wiki/contents/articles/3735.sql-server-samples-readme-en-us.aspx#Readme_TOC_worknow for instructions on how to attach the AdventureWorks2008R2 database.

The AdventureWorks2008R2 set up script is at http://msftdbprodsamples.codeplex.com/downloads/get/363849

The script install instructions are at http://msftdbprodsamples.codeplex.com/releases/view/89502 or at http://social.technet.microsoft.com/wiki/contents/articles/3735.sql-server-samples-readme-en-us.aspx#Readme_TOC_worknow

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 5

Hello,

I uploaded AdventureWorks databases for 2012, 2008R2 and 2008. Each download zip file contains an mdf database file and ldf log file. This consolidates AdventureWorks databases for several SQL Server versions to one page. Please let me know what you think.

AdventureWorks Databases – 2012, 2008R2 and 2008

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

The AdventureWorks2008 database is at http://msftdbprodsamples.codeplex.com/downloads/get/478218.

Answer 6

You can use this DB http://msftdbprodsamples.codeplex.com/releases/view/37109 is the same on the example, best regards!!

---

EP!!