SQL Server 2005 SP2a

 Recommended Download



Source Code AdventureWorksDB.msi
source code, 28053K, uploaded May 7 2007  - 495823 downloads

 Other Available Downloads



Source Code AdventureWorksDBCI.msi
source code, 29177K, uploaded May 7 2007  - 67025 downloads
Source Code AdventureWorksBI.msi
source code, 7393K, uploaded May 7 2007  - 109492 downloads
Source Code AdventureWorksBICI.msi
source code, 16764K, uploaded May 7 2007  - 35546 downloads
Source Code AdventureWorksLT.msi
source code, 2251K, uploaded May 7 2007  - 72483 downloads
Source Code AdventureWorksDB_x64.msi
source code, 28075K, uploaded May 8 2007  - 16340 downloads
Source Code AdventureWorksDBCI_x64.msi
source code, 29177K, uploaded May 8 2007  - 4561 downloads
Source Code AdventureWorksBI_x64.msi
source code, 7393K, uploaded May 8 2007  - 6903 downloads
Source Code AdventureWorksBICI_x64.msi
source code, 9021K, uploaded May 8 2007  - 3466 downloads
Source Code AdventureWorksLT_x64.msi
source code, 2251K, uploaded May 8 2007  - 5348 downloads
Source Code AdventureWorksDB_IA64.msi
source code, 28075K, uploaded May 8 2007  - 2367 downloads
Source Code AdventureWorksDBCI_IA64.msi
source code, 29177K, uploaded May 8 2007  - 1426 downloads
Source Code AdventureWorksBI_IA64.msi
source code, 7409K, uploaded May 8 2007  - 1808 downloads
Source Code AdventureWorksBICI_IA64.msi
source code, 8980K, uploaded May 8 2007  - 1463 downloads
Source Code AdventureWorksLT_IA64.msi
source code, 2251K, uploaded May 8 2007  - 3480 downloads

Release Notes

Sample Databases for Microsoft SQL Server 2005 SP2 licensed with the MS-PL license.

These installers require you to manually attach the database after installation. See the Release Notes for details.

AdventureWorksDB is the Adventure Works Cycles OLTP sample databases.
AdventureWorksBI is the Adventure Works Data Warehouse and Analysis Services database project.
AdventureWorksLT is a very simple sample database based on the Adventure Works Cycles OLTP sample database.

The CI versions of some of the databases use a case-insensitive collation, as does the AdventureWorksLT sample database. The others are case-sensitive.

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

Everything is working perfect. After installing each database, you need to attach them from SSMS to make them visible.
by statcomp on Nov 3 at 2:37 AM 
 
 
 
 
 

I struggled to get this working till I found this explanation...in short...the link below should have been included in the download instructions. http://techpunch.wordpress.com/2008/08/29/sql-server-2008-installing-the-adventureworks-sample-databases/
by marcberenholtz on Oct 16 at 10:58 PM 
 
 
 
 
 

This is the worst shit I've ever seen. I can't believe it. - I try to download of microsoft. - I get a pdf telling me they don't host it anymore, but that Codeplex is hosting it, LOL you really have to let me download a PDF to tell me that ???????????????? So then i go to Codeplex: - I tried 2008 version of this sample and still no .exe file or .mdf, nothing, nowhere, nada ...
by Yakkity on Oct 16 at 3:15 PM 
 
 
 
 
 

Worked perfect for me. Thanks to aeonbluestar for the additional instructions.
by mattanddonnah on Sep 12 at 6:45 PM 
 
 
 
 
 

Easy to download and install. You should read the installation steps to see / change where the files go.
by RappyFood on Sep 7 at 3:46 AM 
 
 
 
 
 

Perfect. Downloaded and installed in less than 2 minutes! If you are having trouble, install to the default directory (Should be "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data", then in SQL Management Studio: 1) Right click on Databases > Attatch. 2) In the dialog, Click Add (should go straight to your SQL Data folder) then select the AdventureWorks.mdf. 3) Profit :D
by aeonbluestar on Jul 24 at 1:17 AM 
 
 
 
 
 

I don't know why people complain about the installation. if they don't know what they are doing, then DON'T do it. The installer JUST creates the folders and files included in the installation. Since this are SQL-Server database files, then go to SQL-Server and attach the newly created files wherever YOU CHOSE to put them (remember you browse the folders to place the files)
by pedropgarces on Jul 15 at 6:07 PM 
 
 
 
 
 

An installer that doesn't install. I guess this is a legal issue, where MS cannot release files unless they're installable. The problem here being that it's not installable. And the result is this non-sensical installer that doesn't install. Nice job. 1 star.
by PandaWood on Jul 8 at 3:30 AM 
 
 
 
 
 

I downloaded & ran AdventureWorksDB.msi which I assume is the main DB (some actual comments sure would be useful there). It ran and... still no database. What do I have to do after running the installer? (actual instructions would really be terrific.) thanks - dave
by DavidThi808 on Jun 24 at 11:30 PM 
 
 
 
 
 

Helpful instructions that Microsoft won't tell you: Download the file to the temp directory of your choice. Right click on the file and select 'Install'. When the error comes up saying it can't find the file and requesting the location of Adv...[1].msi, then copy the msi file, rename to the requested file, and pick the file in the browse dialog.
by LanceRoberts on Jun 15 at 7:44 PM 
 
 
 
 
 

It will help if you briefly explain what is in each downloads. I was visiting your "readme" and other links trying to make sense of these stuff and I got highly disappointed. The information you supply are ambiguous,inaccurate and badly organized; no wonder your low rating in despite the high technical expertise of your site.
by frankqrjobs on Jun 10 at 3:01 AM 
 
 
 
 
 

Downloaded and installed like a charm. Also had the readonly problem, but then just detached the mdf/ldf's, set the permissions to give myself full control and attached it again.
by lenocin on May 29 at 9:16 AM 
 
 
 
 
 

I am annoyed by it. I have agreed to terms then saved to a specific location - but when the download is done - there's no file there. I also tried running it. download finished - and nothing happens. I am soooooooo pissed off
by nightroll on Apr 29 at 9:55 AM 
 
 
 
 
 

thanx God ! i succeed at last in attaching AdventureWorks data base ...but things should be more elaborated in codeplex keeping in view the beginner like me....to day i wasted my whole day in learning little thing ...like to install and attaching database to sql mgnt studio express..... any way this is great site i always admire and love.
by s_codeplex on Mar 24 at 6:39 PM 
 
 
 
 
 

I was trying to download all day. Everytime, it stops at 3% and nothing happens after that. I tried from a different machine with same results.
by msami on Feb 23 at 6:49 PM 
 
 
 
 
 

Well, there's no problem at all during I install it, and attaching it to my own database, with acceptable downloading speed. The downloading speed were... about 200kb/sec. JFI, in case of eastern Asia.
by mcpdragon on Jan 21 at 2:59 AM 
 
 
 
 
 

Well, no resume download and ~30 Kbps rate from Brazil. It took a little bit, but fortunately, I had no timeout. After that, everything was good. Opened management studio, manually attach the database and presto!! Thanks. PS: For the lazy people, RTFM before judge Codeplex and Microsoft work.
by baracat on Jan 14 at 1:51 PM 
 
 
 
 
 

Excellent! I downloaded three type of database files (.MSI 32 bit) - downloaded fast as I use broadband, and installation worked well. Though installation only extract the database file into default data folder for SQL Server 2005 and then user needs to attach it using Studio Manager. It worked for me with no issue at all.
by sbarkat on Jan 14 at 12:12 PM 
 
 
 
 
 

If you're having trouble downloading, try using Internet Explorer. I was using Firefox and it would just hang...
by ozmosis on Jan 13 at 7:09 AM 
 
 
 
 
 

I followed your instructions and there is no Adventure database to connect to. Most frustrating. How hard would it be to write a complete set of instructions? Not everyone that uses your services is a teck geek. Write things in English - no "if your setup is different" crap. Two hours of my time wasted.
by BruceAE on Jan 2 at 6:23 PM 
 
 
 
 
 

Sucked mightily (yea verily!). Timeouts--no download. Nada.
by rowlandg on Dec 28 2008 at 9:56 PM 
 
 
 
 
 

The downloads work swell for me. What would we do without these samples, eh?
by aspiringgeek on Dec 28 2008 at 9:16 PM 
 
 
 
 
 

Could not download, waiting forever....
by angenent on Dec 28 2008 at 3:58 PM 
 
 
 
 
 

Sorry to say but I had a terrible experience. Clicked to download AdventureworksLT and after clicking on 'I Agree' nothing happens - just a busy cursor for ever!!
by AlokJoshi on Dec 25 2008 at 4:00 AM 
 
 
 
 
 

The installer for AdventureWorks*_x64.msi suggests the folder "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" instead of "c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data", where my SQL Server 2005 is installed and does not attach the databases (this step has to be done manually). I also find it weird that the AdventureWorksLT was set to Read-Only after I attached it.
by rsocol on Nov 16 2008 at 7:49 AM 
 
 
 
 
 

the links do not work...i must guess that this is a terribly slow download that leads to timeout....waited for hours and nothing happened!
by Ganastas on Nov 12 2008 at 12:08 PM 
 
 
 
 
 

It seems okay to me. I had no problem. Thanks!
by glove on Oct 21 2008 at 11:00 PM 
 
 
 
 
 

a really poor downloading experience for me!
by clearday on Oct 16 2008 at 2:15 PM 
 
 
 
 
 

The LT sample is especially nice. As an idea for future endeavors, how about a reprise of the good old Northwind, just for kick?
by mkamoski on Aug 25 2008 at 5:54 PM 
 
 
 
 
 

Easy? How about a checkbox to select multiple downloads, or a package with multiple downloads included? This is a pain for multi-platform, multi-application developers like myself.
by jenisys on Aug 20 2008 at 5:46 PM 
 
 
 
 
 

Excellent work Easy to download and to install A real pleasure to use the AdventureWorks database
by PapyNormand on Aug 6 2008 at 7:13 PM 
Updating...
© 2006-2009 Microsoft | About CodePlex | Privacy Statement | Terms of Use | Code of Conduct | Advertise With Us | Version 2009.10.27.15987