AdventureWorks 2008R2 SR1

Rating:        Based on 112 ratings
Reviewed:  91 reviews
Downloads: 0
Released: Nov 17 2010
Updated: Apr 24 2012 by akiwhit
Dev status: Stable

Available Downloads

There are no downloads associated with this release.

Release Notes

Alternative AdventureWorks2008R2 database

Because of issues related to the AdventureWorks 2008 R2 SR1 installer, as an alternative to the SR1 installer, you can download the AdventureWorks2008R2 database, or scripts, from AdventureWorks2008R2 without filestream. This is a database only download that you will need to attach. More information about attaching the database is at Readme for Adventure Works Sample Databases.

Please give us your feedback in the samples forum! (Yes, even the complaints. We do try to respond to them.)

Reviews for this release

     
thanksgiving，good
by aresyh on Today at 4:37 PM
     
excellent!
by mehmetali on Today at 7:47 AM
     
i like this project.
by shinang on Tue at 6:37 AM
     
anikor like this project
by anikor on Tue at 2:48 AM
     
learn the report
by liuhaierok on Mon at 1:23 PM
     
He was struggling for precise information on how to download the sample database. I would like to share the link from where you can find the AdventureWorks for SQL Server 2008 R2 Recently we moved from Newtonsoft.Json 3.5 to 4.0 version. We noticed that we were getting Could not load file or assembly 'Newtonsoft.Json, Version=3.5.0.0.. while working with Twitter authentication which we were usinga
by trongchiitspk on Sat at 12:59 PM
     
Very like Very like Very like Very like
by pingzy on May 10 at 12:43 AM
     
i love you, you love me too.
by tomzou on May 9 at 2:22 PM
     
very like.for testing
by hijason88 on May 8 at 7:14 AM
     
Very like Very like Very like Very like
by fumingming on May 6 at 12:17 PM
     
for testing
by digtallin on May 6 at 11:16 AM
     
dshnthsfhbsdhfdh fdhgfdhnf
by sql_k on May 3 at 8:28 AM
     
I like 70 porcent
by SaraFerran on Apr 30 at 8:54 AM
     
nasıl indirildiği hakkında bir fikrim yok. Bu nasıl indiriliyor ki böyle. Dikkatlice de bakıyorum ama ben mi göremiyorum şu anda indirilemez diyor hem de indirme yapılabilir diyor nasıl iş bende mi bir sorun var...
by orhangazi on Apr 29 at 10:46 PM
     
This DOES suck. Did not install. It should come with SQL Server. So lame.
by smbaxter1265 on Apr 23 at 2:07 PM
     
This sucks. Doesnt install. This should just be part of sql server install
by arunsun on Apr 14 at 5:39 AM
     
This did not install for me either on Windows 7 Enterprise edition. But I found a work around: download universal extractor (uniExtract http://legroom.net/software/uniextract) and extract the sample csvs, sql scripts etc. from the .exe manually. Works perfectly that way.
by 8bitme on Apr 2 at 2:43 PM
     
The adventure works database and DW database and also the SSAS projects are very well made but where is the sample SSIS package that does the ETL from AW database to AW DW database? That would make it a perfect sample set to me.
by DennisMul on Mar 28 at 1:18 PM
     
Simply cannot get the Sample databases to install. 2008 R2 SP1 on Windows 7 Professional (64 bit). I did find the adventureworks.mdf for the OLTP and attached it successfully however, I was really going for the DataWarehouse components. I would really like a way to bypass the installer.
by medamo on Mar 15 at 7:53 PM
     
SQL Server 2012 databases are very simple to attach, and the BI project is simple to build and deploy.
by andrewwhitten on Mar 14 at 7:57 AM
     
Worked like a charm; matter of seconds to install. Just copied the install script and modified the path and that was it. Applied to to the 64 bit environment.
by wdwcodeplex on Mar 12 at 4:19 PM
     
Dreadful... Needlessly complicated. Should be distributed with SQL Server Setup anyway. Single machine with one instance of SQLExpress. AW setup could not find my instance. Finally turned on TCP/IP, NamedPipes, and SQL Browser (all defaulted to disabled...) Then AW Setup saw my instance. Could not get full text search enabled (not available as a feature on my downloaded installation).... Hideous
by DundeeDevl on Feb 22 at 5:53 PM
     
Cannot attach. 661/655 problem mentioned by others. Is there something I'm doing wrong?
by RGOConnor on Feb 17 at 2:40 PM
     
Installed with no issues on Windows 7 x64 with named instance. Nice work!
by NingBing on Feb 11 at 5:07 AM
     
Installed well on Windows 7 64-bit
by MarkTab on Feb 10 at 8:28 PM
     
1. Win 7+SQL Server 2008-download 'AdventureWorks 2008R2 SR1' default location. 2. Copy and paste in 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA' and extract here. 3. 'Attach' AdventureWorks2008 database through SQL Server 2008 RS 4. Also check FILE STREAM is enabled. It was initially challenging to download AdventureWorks2008 db onto Win 7, perseverance prevailed.
by deepthiy on Feb 5 at 6:31 AM
     
Please fix. There is no AdventureWorks2008R2 database in the installation. The database is necessary for AdventureWorks2008R2 Sample Reports project.
by bkejser on Feb 5 at 12:37 AM
     
yes~It ready good use
by weiham on Jan 31 at 8:02 AM
     
Worked perfectly for me with SQL Server 2008 R2 Express. I'm running Windows 7 Home Premium on a HP Pavilion p7-1174.
by ProfessorMetal on Jan 20 at 5:10 AM
     
Doesn't install on Denali.
by Bill_Ross on Jan 9 at 3:55 PM
     
Installer worked perfectly on my Win 7 Home Premium with SQL Server 2008 R2 Express.
by gby on Jan 4 at 9:25 PM
     
There is no AdventureWorks2008R2 database in this installation. This database is necessary for AdventureWorks2008R2 Sample Reports project. Where I can find this database?
by vbeths on Dec 13 2011 at 9:15 AM
     
Unable to download the file
by ajjeys on Dec 11 2011 at 8:06 AM
     
Does not work with the online tutorials. Tables in the online tutorials completely different than the AdventureWorks2008Re sample database. One star for easy down load on 64bit window7 on laptop. Finally got the right databas - AdventureWorks, but now i get error on sp.BusinessEntityID. I added one more star. I'll add one more when I figure out query error,
by Ron_2012 on Dec 10 2011 at 11:57 PM
     
Just for study
by Lvtie1987 on Nov 24 2011 at 2:25 AM
     
Excellent. The installer (SR1 version) worked without any problems. Windows 7 Home Premium Laptop.
by Emiro on Nov 21 2011 at 10:55 AM
     
Excellent. Quick download. Installer worked fine, SSAS samples optional and also easy to install after running main program.
by Kluke63 on Nov 17 2011 at 2:09 PM
     
The installer worked for me. I'd rather not have the OLAP rolled into it but other then that it worked fine.
by ArtOfSQL on Nov 16 2011 at 9:37 PM
     
This is not a proper downloadable. The exe(AdventureWorks2008R2_SR1.exe) which is downloading is some scrap. Can you please correct the downloadable? My rating will definitely change for this once we have this working.
by snsrinivasan on Nov 4 2011 at 3:06 PM
     
in Windows XP SP3 ,just downloads 2 bytes of exe which gives error when I execute. Stuck with it now. please resolve the download issue ASAP
by sjegadison on Nov 2 2011 at 10:59 AM
     
not working, tried many times but it just downloads 2 bytes of exe which gives error when I execute. is it not available anymore?
by mranjank on Nov 1 2011 at 5:20 PM
     
The database 'AdventureWorks2008R2' cannot be opened because it is version 661. This server supports version 662 and earlier. A downgrade path is not supported. I would think that 661 is included when it says 662 and earlier. Nice.
by dave456578 on Oct 20 2011 at 5:22 PM
     
Try 'Run as Administrator' to run under 64-bit Windows. Otherwise, the setup fails.
by JefferyP2100 on Oct 4 2011 at 6:56 PM
     
Very good, 3Q for your share.
by zfm850722 on Sep 8 2011 at 7:37 AM
     
Installation provided helpful tips and went as expected. Env: Win7 x64, Default Instance.
by tdracz on Aug 29 2011 at 10:31 PM
     
The documentation of the samples doesn't match the table names and design provided in the databases. i.e. AdventureWorks2008R2 database doesn't exist, however AdventureWorks exists, and so on... It is quite painfull to use this release to follow the tutorials.
by vhinzu on Aug 29 2011 at 3:15 PM
     
It installed just fine but doesn't have the tables for the SSRS tutorials for SQL2008R2. Microsoft desperately needs to remove the cheap labor from its documentation department. It's just not working out. Now going over to the forums to try and figure out what to use.
by baybear2004 on Aug 26 2011 at 4:20 PM
     
Installed mine on SQL 2008 Standard no problemo.......
by msimango on Aug 24 2011 at 10:34 AM
     
The same problem like been mentioned by someone on 2nd Aug - for 64 bit platform setup button is disabled. I have managed myself to install it. 1 I extract the archve and found that executable inside the archve doesn't want to run on 64 bit platform. 2 I went to the folder with reqired database and fount *.sql file 3 I have modified the parameters :setvar 4 run script in SQLCMD mode
by gretchkosiy on Aug 17 2011 at 1:52 AM
     
i like the sample ,because of it's beautiful report and database schema.
by breathhard on Aug 13 2011 at 5:16 PM
     
I have two instances(default + named) on SQL Server 2008 R2 on Win 7 64bit. The install button is disabled for both instances.
by anildwa on Aug 2 2011 at 8:15 AM
     
averagely good
by xelio789 on Jul 30 2011 at 12:30 PM
     
Essential download for demos and producing samples. Installation straight forward and no issues on Windows Server 2008 R2/SQL Server 2008 R2.
by SamadKhan on Jul 2 2011 at 3:02 PM
     
handsome guy
by hp1920 on Jun 22 2011 at 2:33 PM
     
I had no problems at all. Installed in 4+ minutes. I must point out, though, that when I installed SQL Server 2008 R2, I selected Full Text Search and FILESTREAM, and added another instance (to keep the play and the work separate). So when I attempted the samples installation everything was ready to go. I suggest to those with problems to check the server installation or re-install.
by Anaristos on Jun 12 2011 at 5:18 PM
     
Install not success. A fatal error occurred during installation. Details: Failed object initialization (ISupportlnitializeEndlnit). An exception occurred in SMO while trying to manage a service. Error at object DatabaseSelection’ in markup file Databaselnstaller;component/ databaseselection.xaml Line 78 Position 3.
by saknarak on May 31 2011 at 3:55 AM
     
Mine installed without a problem on my Vista System. If you have a problem installing, then resolve it, since that is going to be your job anyway, if your are a MCDBA. Do not be deceived, Oracle has the same kind of issues too. TC
by webreviews on May 29 2011 at 4:54 PM
     
It is a five because it worked like a charm on first installation. No hurdles or anything..just went through!!!
by husseinsamwel on May 23 2011 at 7:59 AM
     
zuberztaha
by zuberztaha2010 on May 12 2011 at 12:29 PM
     
Wow. Who knew.... the download file must be put in the 'C:\Program Files\Microsoft SQL Server\MSSQL10_50."named instance(i.e. SQLEXPRESS)" folder before you try to install it. Otherwise, you get the dreaded "Failed object initialization (ISupportInitialize.EndInit). An exception occurred while executing a Transact-SQL statement or batch. Error at object ‘DatabaseSelection’ in markupfile" message
by mascott on May 10 2011 at 7:58 PM
     
There appears to be no installer for SQL Server 2008 Developer Edition/x86. The FILESTREAM option under the R4 release is mandatory, but not supported for 2K8 Dev/x86 when running under WOW (as I am). The AdvWorks "no FILESTREAM" version indicates it must run against a later version of the database than the one I have. Is it really this complicated to install the demo database?
by OklahomaDave on Apr 12 2011 at 6:13 PM
     
As a newbe to MS SQL server I appreciate the sample databases and scripts. I’m presently having issues connecting with Crystal Reports & SAP. Can anyone provide a reference to get me going fast?
by CJHisthebest01 on Mar 30 2011 at 3:35 AM
     
i very want to get this ths
by tippoint on Mar 7 2011 at 6:03 AM
     
It worked. Is it not possible to automate the prerequisite-checking?
by GreatBittern on Feb 24 2011 at 3:03 PM
     
OKed ededede
by fjimenez on Feb 24 2011 at 1:55 PM
     
Didn't work for my default instance. Many thanks to HilaryCotter for the suggestion provided in her rating above. That got me access to the tables and I could proceed from there. This 30 min project took 3 hours. This release needs work.
by MarioAnz on Feb 21 2011 at 2:15 PM
     
Worked a treat, as a newbie I am very relieved. Well done.
by alnis on Feb 20 2011 at 3:32 AM
     
I have SQL Server 2008, R2 on Windows Server 2008, standard, R2. I used individual domain accounts to run the services. Before installing the sample databases I made sure (checked and double check) that the individual domain accounts had the correct access. The last step was to install the sample AdventureWorks. The instructions for the sample db were perfect, worked perfectly the first time.
by VSCoder60 on Feb 5 2011 at 5:45 PM
     
installed a treat. lost a star because it required me to make the "tools" folder first.
by mickyd on Feb 4 2011 at 2:06 AM
     
Installed without a hitch, and the steps to configure my database for this install were clear and concise, thanks!
by briansboyd on Jan 7 2011 at 9:41 PM
     
Installed without a problem.
by afulmer on Jan 2 2011 at 3:15 AM
     
It worked well without any problem.
by gavesh on Dec 30 2010 at 1:00 AM
     
Installed without any problems :)
by petrzima on Dec 10 2010 at 10:13 AM
     
ARE YOU SERIOUS - - first, several errors installing 2008r2 (MOF error, WMI bull, instances switching, NOW there are glitches trying to get even the simple examples loaded for a presentation on why we need to move from Oracle - - TWO solid wasted days trying to get a fresh machine off of the ground - - get it together guys, you have plenty of time and bucks on your hands - - shameful PERIOD...
by turbothis on Dec 10 2010 at 3:04 AM
     
There was an error in the install package when there was only a single instance of SQL Server. This has been fixed. Folks that received the error message "No valid sql server instances are accessible for installation" should try the install again. Gail Erickson [MSFT] SQL Server Documentation Team
by Gaile on Dec 6 2010 at 8:46 PM
     
No problems at all,.... Just unzipped and installed them without any problems. Do you guys have the right SQL server edition?
by BryanVanRijn on Dec 3 2010 at 2:25 PM
     
These samples install and work like charm and I'm sure no one would have any issues if first have READ and DONE the "Database Prerequisites for SQL Server 2008R2" http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites%20for%20SQL%20Server%202008R2 Just one service needs to be set to Automatic, and then start it. And FILESTREAM to be enabled as described. Wish u success!
by skarakolev on Dec 3 2010 at 11:04 AM
     
This doesn't work. When is someone at Microsoft going to notice? None of the earlier suggestions work for me.
by rjback on Dec 2 2010 at 2:06 PM
     
Doesn't work. To get it to work after you get the error go to a command prompt and change directories to cd %temp% then do this dir /od You should find a directory which looks something like this: WZSE0.TMP go inside that directory and type explorer . Then you will see all the folders. Copy these folders to a known location on your hard drive (I use C:\temp). Open up SSMS run instawdb.sql
by HilaryCotter on Dec 2 2010 at 11:54 AM
     
Honestly, this defective install is a stupid waste of time. It does not work on a default installation. I ended up having to compile the examples manually from the script files because I don't know how to create a new instance (nor do I want one). I presume that this is intended for beginners??? Why wasn't it actually tested in a default environment???
by GlenT on Nov 30 2010 at 10:01 PM
     
Yep. it needed one more instance to work. Was trying to figure out for couple weeks now. Glad that smart people figured out what is the work around. Once pass that install issue, things seems to be in order. Can not give better rating if the taking off is so tough.
by another_coder on Nov 30 2010 at 4:22 PM
     
For the others who are trying to install this: It does not seem to work on an install to the default instance. You need to create a new instance (e.g. MYSQLSERVER) then run the sample data on the new instance and it'll work fine. That's what i did and it is working. Give it a try. G'luck.
by cr8zymike on Nov 30 2010 at 12:54 PM
     
Same problem: "No valid SQL Server instances are accessible for installation". Fresh installation of Win7, SQL Server 2008, all prerequisites met. Ended up installing 2008 SR4. Please fix!
by leahcimp on Nov 28 2010 at 11:07 AM
     
I had the same "no valid SQL Server instances are accessible" error. I installed a 2nd DB instance (was going to anyway) and when I re-ran setup being able to toggle between the instances did the trick. Switched to my 2nd instance, then back to default (where I want the sample DB) and it gave me the option to select components to install. Windows 7 x64 install.
by iwkid on Nov 24 2010 at 2:06 PM
     
same install problem No valid SQL Server instances are accessible for installation. If instances are available the problem could be due to SMO issues. This is a default installation on Windows 2008 R2 Enterprise server, everything is 64bit. SQL 2008 R2 Enterprise 64bit, complete install. Please fix.
by wickedHangover on Nov 24 2010 at 1:25 PM
     
In fact I now know nothing about it
by xiashiwendao on Nov 24 2010 at 5:11 AM
     
Message from Install:"No valid SQL Server instances are accessible for installation. If instances are available the problem could be due to SMO issues." The install in the tools directory was run - same message(sam program) but the install program dropdown shows the 3 SQL instances running on the laptop and the SQL2008R2 is the one it shows - how can it say no instances when it runs. (XP SP3)
by MarkMitchell on Nov 22 2010 at 2:38 PM
     
Same error on Win7 64bit SQL 2008R2 fresh install
by Joshka on Nov 22 2010 at 2:04 AM
     
same issue - I got around this issue by creating an Instance on : C:\Program Files\Microsoft SQL Server. Installer does appear to find Instances in this "default" location.
by amrit on Nov 20 2010 at 3:59 PM
     
Same issue... no instance found... Thank you for fixing
by UtilisaCP on Nov 19 2010 at 9:22 AM
     
Attempted to install multiple times: Fresh setup of Windows 2008R2 and then SQL 2008R2. I am getting message that no instance found - tried 4 times. Setup copies files to directory, but because instance not found - no DBs are created. Then installed 2008 SR4 samples - worked no problem for first attempt. Please fix this setup.
by vidas_m on Nov 18 2010 at 11:06 PM