How do I find/install AdventureWorks 2008 (non-R2) on SQL 2008 (non-R2) Developer Edition on x86 under Windows 7/64?

Question

Greetings!

I have a need to install the AdventureWorks database on a Microsoft SQLServer 2008 (*not R2*) Developer Edition (x86), which is running as a 32-bit process under WOW within 64-bit Windows 7.

• The stock AdventureWorks2008 database (Refresh 4) will not install, as FILESTREAMing is required, but not supported for SQL 2008 Developer (x86) when running as a 32-bit WOW process.
• The "revised" Adventureworks "non FILESTREAM" version will not install as it reports that it will only install on a "version 661" or later version, whereas the version it reports for my installation is, I believe, 655 - and I suspect that's merely a different way of stating the difference between SQL 2008 and SQL 2008 R2.
• Moving to the 64-bit SQL Developer edition is not an option at this time, as I am supporting code that will be hosted in a 32-bit environment for at least the reasonable near future.
• The other versions I've seen appear to be tailored for SQL 2008 R2, and I am using SQL 2008 (no R2).

Surely there is a version of the sample databases suitable for my setup...even a link to just the mdf's and log file??

Thanks,

David

 

 

Answer 1

http://sqlserversamples.codeplex.com/

http://blogs.msdn.com/b/bonniefe/archive/2008/08/07/sql-server-2008-samples-are-here.aspx 

Answer 2

Where is this database located? I have downloaded all samples from codebase, but I'm still unable to find the database named "AdventureWorks2008R2".

 

I have found

1) adventureworks

2) adventureworksDW2008

3) adventureworksDW2008R2

 

BUT NO ADVENTUREWORKS2008R2.   WHERE IS THIS ONE FOUND?

Answer 3

Hi Blue,

http://msftdbprodsamples.codeplex.com/releases/view/37109#DownloadId=96448

Above link provides 

AdventureWorks2008_SR4.exe

Its a self extractor and will install all sample databases.

If you are looking for R2 databases try below link.

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

After executing extractor find below path(if it did not install dbs automatically)

C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008 OLTP

"instawdb.sql" You can execute this script manually to deploy Adv2008 Database.

If you are facing any errors fallow below link to fix them 

http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites%20for%20SQL%20Server%202008R2

Hope You got the idea 

---

Sivaprasad.L Together We can Achieve

Answer 4

Hi

While I'm running the exe mentioned above..getting the following error please help me out in resolving it..

 

---

Sree