Where is AdventureWorks2008 ?

Question

I'm working on the 70-433 (Sql Server Database development ) exam and I need to have the AdventureWorks2008, AdventureWorksDW2008 & Northwind databases, I have the last two 

but I can't find AdventureWorks2008.  Downloaded "AdventureWorks2008R2_SR1.exe" from codeplex but this does *not* contain this database.  See screenshot.  Anyone tell me where I can get this missing database? 

Thanks in advance

Dave 

 

 

Answer 1

There are 2 different installs. One for SQL Server 2008 (and the databases have 2008 at the end) and one for SQL Server 2008 R2. Although I just checked what I have and I have  

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 2

Hi, 

Well I just downloaded the 2008 (not R2) version from codeplex (http://msftdbprodsamples.codeplex.com/releases/view/37109)  and it does 

not give you the option to install AdventureWorks2008, see below.  Could anyone make this database available via a file share? 

Regards

Dave 

Answer 3

Hi,

Adventureworks OLTP 2008 will be that database you are looking for.

I hope it helps.

J.

 

---

There are 10 type of people. Those who understand binary and those who do not.

Answer 4

Hi, 

Is it?  I simply going on what is in the study guide, it states you need AdventureWorks2008 database. 

If they are the same thing then that's fine, I can proceed. 

Regards

Dave 

Answer 5

Funny that I am also studying the same exam, same book, same weekend.
I was also looking for adventureworks2008. 
I would never guess that AdventureWorks OLTP would be AdventureWorks2008... but it looks like it is NOT AdventureWorks2008, but only AdventureWorks (not 2008). 

It certainly gives a good version of AdventureWorks, but it is not "the" one the book is based on as the first SELECT statement (page 27) ask for a "JobTitle" which does not exists in AdventureWorks

Maybe I am missing something here, but where is AdventureWorks database for the book?

Answer 6

Glad someone else has backed up what I said, thought I was cracking up. 

Come on Microsoft, we bought your book, will pay for the exam, so how about making the right db available????

Answer 7

Did you enable FileStream?

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 8

Nope, should I?  There are a number of uninstallable databases on the selection screen but none has the same 

name as given in the book "AdventureWorks2008". 

Cheers

Dave 

Answer 9

Hi,

Yes, FileStream is required. Have you seen the http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Installer%20Help page? It helps you how to install it.

Anyway, have you managed to check what I worte above? I just used the same installer and got AdventureWorks2008 installed. Alternatively you can download the source of the build and use the instawdb.sql from the Kilimanjaro_RTM\AdventureWorks OLTP 2008 folder.

there is no any problem with the installler, but I agree, MS may use much better naming for the databases.

I hope it helps.

J.

 

---

There are 10 type of people. Those who understand binary and those who do not.

Answer 10

Hi, 

Thanks for the info, I will try this out later and post back here. 

Dave 

Answer 11

The adventureWorks2008, for the book 70-433, can be found in the SQLserver 2008 SR4 with some condition on configuration of the database engine.

Here what to do to install AdventureWorks2008:

First, if you use SQLserver express 2008, make sure you have the "advanced" version and not the "with tool" version.
You can find the "advanced" version at http://www.microsoft.com/download/en/details.aspx?id=1842
In the installation of SQLserver, make sure to check the "Full-text Search" services (the "with tool version" does not have that service)

Configure SQLserver with the prerequisite that has been talk e.g. "filestream" AND also the "full text search"  (http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites)

Download and execute the database installer "SQL server 2008 SR4" (http://msftdbprodsamples.codeplex.com/releases/view/37109)

Tadaaaa!!!! 
SQLserver 2208 SR4 is "the" good database! 

Thanks to everyone!

Answer 12

Hi,

Any update on this please?

Thanks,

J.

---

There are 10 type of people. Those who understand binary and those who do not.
Blog

Answer 13

Hi, 

Followed the link in your post about enabling Filestream, problem is when I right click on the sql instance 

in "sql config manager" I don't have a "Filestream" tab.  See pic

Any ideas? 

 

 

 

Answer 14

Answer 15

Hi,

Please do not try to find it at the protocols. Try at here:

1. Start SQL Server Configuration Manager
2. Navigate to the SQL Services node at the left side and select it.
3. Right side you will see all services related to your SQL Server installation(s). Right click on the SQL Server service and you will find the FILESTREAM tab.

 

I hope it helps.

J.

---

There are 10 type of people. Those who understand binary and those who do not.
My Blog

Answer 16

Hi, 

Thanks for that.  I've now enabled Filestream after checking all the boxes.  

Do I go ahead and run the install adventureworks program, selecting the OLTP database?

Dave 

Answer 17

Thanks, got it all now. 

Enabled Filestream & full text and restored the db from the script.  

Bit of a faff though, why can't MS just allow us to download the backup files as an alternative? 

Answer 18

Hey Naomi,

Could you please tell me where I can get AdventureWorks2008R2 database from? I installed the database samples from http://msftdbprodsamples.codeplex.com/releases/view/55926 but I only get AdventureWorks sample (not AdventureWorks2008R2)

Thanks,

Marco

Answer 19

If you follow the steps in the response marked as the answer & enable filestream (Tilew) you will have the correct database. 

It does seem a lot of messing around to get a sample database though. 

Answer 20

I managed to install the database.

I have deployed the report samples. I am trying to run Employee_Sales_Summary_2008R2.rdl report. It works from Preview inside the "AdventureWorks 2008R2" solution, but when I try to run it from http://localhost:8080/Reports the following error message is displayed:

• An error has occurred during report processing. (rsProcessingAborted)
  • The execution failed for the shared data set 'SalesEmployees2008R2'. (rsDataSetExecutionError)
    • Query execution failed for dataset ''. (rsErrorExecutingCommand)
      • Invalid object name 'Sales.SalesPerson'.

Any ideas how I can make it work?

Thanks,

Marco

Answer 21

Hi,

I believe it is a new question and should be moved to a separated thread.

I would check the datasource settings are pointing to the correct database.

Thanks,

J.

---

There are 10 type of people. Those who understand binary and those who do not.
My Blog