SQL Server 2005 SP2a

Rating:        Based on 50 ratings
Reviewed:  44 reviews
Downloads: 1318844
Released: May 7, 2007
Updated: Mar 17, 2009 by ReedMe
Dev status: Stable Help Icon

Recommended Download

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

Other Available Downloads

Source Code AdventureWorksDBCI.msi
source code, 29177K, uploaded May 7, 2007 - 94334 downloads
Source Code AdventureWorksBI.msi
source code, 7393K, uploaded May 7, 2007 - 156805 downloads
Source Code AdventureWorksBICI.msi
source code, 16764K, uploaded May 7, 2007 - 46206 downloads
Source Code AdventureWorksLT.msi
source code, 2251K, uploaded May 7, 2007 - 98150 downloads
Source Code AdventureWorksDB_x64.msi
source code, 28075K, uploaded May 8, 2007 - 35862 downloads
Source Code AdventureWorksDBCI_x64.msi
source code, 29177K, uploaded May 8, 2007 - 9196 downloads
Source Code AdventureWorksBI_x64.msi
source code, 7393K, uploaded May 8, 2007 - 14034 downloads
Source Code AdventureWorksBICI_x64.msi
source code, 9021K, uploaded May 8, 2007 - 6450 downloads
Source Code AdventureWorksLT_x64.msi
source code, 2251K, uploaded May 8, 2007 - 12030 downloads
Source Code AdventureWorksDB_IA64.msi
source code, 28075K, uploaded May 8, 2007 - 4219 downloads
Source Code AdventureWorksDBCI_IA64.msi
source code, 29177K, uploaded May 8, 2007 - 2586 downloads
Source Code AdventureWorksBI_IA64.msi
source code, 7409K, uploaded May 8, 2007 - 3287 downloads
Source Code AdventureWorksBICI_IA64.msi
source code, 8980K, uploaded May 8, 2007 - 2662 downloads
Source Code AdventureWorksLT_IA64.msi
source code, 2251K, uploaded May 8, 2007 - 6146 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

Precious repository, compatible with my Software (SQL Express 2008 R2). Nevertheless, before reconfiguring my machine, I developed with a version of Adventure Workshops that had labels for products and product categories in several languages. I tried two databases here, and neither was the one I used. Either there is a description somewhere, or I have to download all proposed databases and have a look in each. Shall have a look in the forums.
by Gloops on Feb 22, 2014 at 2:30 PM
Excellent work Easy to download and to install
by egamesu on Oct 24, 2012 at 1:05 AM
Please note that some msi versions do NOT contain the .LDF file and then prevent a database attach in SQL Server...
by admdc01 on Apr 2, 2012 at 12:18 PM
This worked for me after all: Download, Run & Install in default directory (\Microsoft SQL Server\MSSQL.1\MSSQL\Data), Open SQL Server Management Studio -> Connect to server (local computer) -> Right-click on Databases on the Object Explorer Window -> Attach... -> Add... This should point you directly to the directory where the databases have been installed. You DO need the BI.msi for the DB.msi.
by fratzola on Mar 12, 2012 at 6:13 PM
To those of us with SQL experience the concept of having to attach a database makes perfect sense. Reality is that sample DBs are often used by those with less experience. Wld be handy if the x64 msi extracted the relevant files rather than checking processor. I have no perms to run an msi on my dev box but I can attach a DB. And the msi won't run on my PC cos it's x32. Grrr!
by krispykitchen on Nov 17, 2010 at 1:53 AM
As mentioned by Tejaswinidp below, Please download AdventureWorksBI.msi for AdventureWorksDW. Thanks for the download.
by ChetanSolur on Sep 30, 2010 at 5:38 AM
All those who say they've had problems aren't doing it right or looking hard enough for the answers. Yes it was amiss of Codeplex / Microsoft not to give instructions and yes it was very annoying to have to download a pdf to get the codeplex link, but there's enough comments on here to get you started. Download, install, attach, get to work. Easy peasy.
by theboyholty on Aug 26, 2010 at 8:58 AM
Key to the success is attaching AdventureWorks_data.mdf to SQL Server Express 2005. Thanks to aeonbluestar, I could register AdventureWoorks, only after I followed instructions posted by aeonbluestar.
by yhlee007 on Jul 24, 2010 at 9:39 PM
download, execute, attach - it is simple - though it would be nice to have a short readme file for those who don't know the steps
by gdunlop on Apr 6, 2010 at 4:31 PM
Excellent downloads. For AdventureWorksDW database download AdventureWorksBI.msi
by tejaswinidp on Mar 25, 2010 at 11:54 AM
I will note that I had to click the AdventureWorksDB.msi three separate times before I got the dialog asking to save the file. Maybe the ActiveX control isn't working as expected, which would explain why so many people are having issues? But once I did get the msi file, it was very straightforward from there.
by TitoBob on Feb 16, 2010 at 11:24 PM
It hardly took 5 mins to download, install and attach the AdventureWorks_Data.mdf file to my database.
by mehtavipulk on Feb 11, 2010 at 7:43 AM
I was trying to install AdventureWorksDB.msi, but it doesn't work, nothing is installed on the directories, I tried other directory and nothing again, I don't know what happen. And the directory had all permissions so everyone could write. Next I tried other installer AdventureWorksDBCI.msi this works and I can attach this database to my sqlexpress. This was a painful experience...
by vickuaeh on Jan 9, 2010 at 6:40 PM
Everything is working perfect. After installing each database, you need to attach them from SSMS to make them visible.
by statcomp on Nov 3, 2009 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, 2009 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, 2009 at 3:15 PM
Worked perfect for me. Thanks to aeonbluestar for the additional instructions.
by mattanddonnah on Sep 12, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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, 2009 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