CodePlex Home
Register | Sign In | CodePlex Home

Installing Sample Databases

Note: By default Windows Server 2008 security is configured to prevent the download of these installers. Changing this security configuration is not recommended on production servers. Please see Windows Server documentation for information on how to change these settings.

To install all the sample databases for SQL Server 2008 perform the following steps:
  1. Ensure all prerequisites are met. See Database Prerequisites for detailed prerequisite instructions. Note that database installation will not complete unless all prerequisites are met.
  2. Using the object explorer in SSMS delete any earlier version of the AdventureWorks sample databases you may have installed.
  3. Using the file explorer ensure all .MDF and .LDF files have been deleted from the data directory for all sample databases in the instance you will be installing the new sample databases. For the default instance, the path to the data directory for OLTP, LT, and DW sample databases is typically C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA.
  4. Navigate to http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx and respond to all the dialogs presented by the installer as detailed below.

CodePlexDownloadPage.jpg
Click one of the Windows Installer (.msi) links in the highlighted area of the samples database download page based on the architecture of the machine which will be running the installer.


Dialog1.jpg
Click the Run button for the File Download - Security Warning dialog


Dialog2.jpg
Click the Run button for the Internet Explorer - Security Warning dialog


Dialog3.jpg
Click the Next button on the Welcome page of the installer.


Dialog4.jpg
Click the license agreement check box, then click the Next button.


Dialog5.jpg
Click the Next button of the Custom Setup dialog.


Dialog6.jpg
Use the pull down selector to choose the instance to install the sample database in. Be sure to read all the content in this dialog. Then press the Next button.


Dialog7.jpg
Click the Install button on the Ready to install dialog.


Dialog8UAC.jpg
This dialog will appear to indicate installation progress. On Vista, a User Access Control dialog may appear asking for administrator permission. Be sure to grant permission in this dialog if it appears. When the installation is complete, click the Finish button.
Last edited Jul 2 at 12:43 AM by bonniefe, version 9
Comments
Meister1867 Jan 24 at 1:31 AM 
As with many people, we receive an error message about installing the DB due to Full-Text Search not being enabled. How can this be enabled? I've been searching to see if there's a site to explain how to do this, but it seems like nothing works. I should mention I'm using SQL Express 2008.

Doobs Jan 27 at 5:09 PM 
I saw this message after my recent install of Enterprise Edition. The way I solved it was to go into Administrative Tools\Services, and set the "SQL Full-text Filter Daemon Launcher" service to start automatically. This was disabled after the installation completed, and is needed to run Full Text Searching. Hope that helps!

d1m0s Mar 19 at 2:27 PM 
I had no errors or other messages during installation. The problem was that the installer did not create AdventureWorksDW2008 database. Thus I had torun instawdwdb.sql manually.

lparkerjr Apr 14 at 4:49 PM 
I received the same error as Meister1867. I am also using SQL Express 2008. Doobs' solution did not work for me, because I have no "SQL Full-text Filter Daemon Launcher" service . Any other solutions?

rdmorris Apr 21 at 5:30 PM 
Had the same problem as d1m0s - ran the msi, no errors reported. However no Adventureworks db created either. Attempting to run instawdwdb.sql script manually gave lots of errors.
Any suggestions?

MBhutta Apr 22 at 6:38 PM 
I had errors messages during installation and did not let me complete the installation. Error "PrepInstance() cannot proceed because the selected instance was not running and could not be started successfully" Please Help Thanks.

jackinthegreen May 7 at 2:47 PM 
To get the Full Text Search feature in express 2008, you need the Microsoft® SQL Server® 2008 Express with Advanced Services http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336 , then just follow Doobs instuctions.

I also see no DB after the install, though,like d1m0s. Guess I'll run that script

Zalakain May 7 at 6:50 PM 
Hi there, yep in my case the installer failed too. Instead of running "instawdwdb.sql" you can also run CreateAdventureWorks.cmd which will do the job fine. It should be located at C:\Program Files\Microsoft SQL Server\100 (W7 in my case, Vista should be the same) then launch it passing the following params: 1. the Id of your DB (ex. PC1\SQLEXPRESS); 2. the path to the insta*.sql folder (ex. "C:\Program Files\Microsoft SQL Server\100\Tools\Samples\"); 3. and the location where the .mdf files should be created (ex. "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\").
HTH!

snowdon May 8 at 8:03 AM 
Hi, I think it would be wise to note at the top of the installation instructions, that it you're running the Express version, as I think is the case with many people downloading these databases, that you need Advances Services. Or, make a "lighter" version of the install, which doesn't require these services.

just_a_guy Jun 1 at 4:03 PM 
Hi, I think another option for Microsoft to consider is removing the option for "Tool"
for SQL Express 2008. The "Tools" option does not come with Full-text-indexing.
That is the version I downloaded and installed. I read that Full-text_indexing is now the
default configuration for SQL Server. This is probably why the TUTORIAL sample database
is looking for Full-text-indexing. To prevent hours of research by other persons, the Tools
option should just be deleted (or at least explain on the Tools option that the Sample database will not function and recommend using the "Advanced" option if you expect to use the sample database).

Just a thought.

bonniefe Jul 2 at 12:44 AM 
We've now added detailed instructions for configuring the prerequisites for the sample databases. Hopefully this addresses some of the concerns raised in these comments.

ChrisJ Jul 9 at 6:43 PM 
Received "An unhandled win32 exception occurred in SQLCMD.exe[2320]" (a few times). The install said it was successful, but the databases were not created.

AKCodeRat Jul 18 at 12:00 AM 
The AdventureWorks20008 database did not install with this package. When I download the zip files and try to install it I get the following error.
*** Creating Database
Msg 5120, Level 16, State 106, Line 2
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents". Operating system error -2147024891: "0x80070005(Access is denied.)".
** An error was encountered during execution of batch. Exiting.

FileStream is enabled, as well as, full text index.

Anyone have any ideas that could help me out?
Thanks

adamcl Aug 24 at 3:19 PM 
I've been working my way through the Analysis Services tutorial which usd the AdventureWorks DB. At the start of lesson 4 it requires you to open the lesson 4 tutorial.sln in: C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\Tutorials\Lesson4 Start. It says if this file does not exist, you should install the samples found on codeplex. I cannot find the actual tutorial samples anywhere on this site, only the generic AdventureWorks installer. After reinstalling the .msi several times as well as downloading the .zip, I cannot find these these tutorial samples. During the .msi installation I made sure the Samples option was definitly enabled. Can anyone help me with this issue?

lcknarr Sep 20 at 3:23 AM 
I am learning SQL Server 2008 and have been trying to download the Express version all day. I have just done a download for the 3rd time today. Before I tried this latest version I removed everything, including the Web Platform Installer and cleaned up the registry.

I am able to connect to the system tables in the Management Studio, but I cannot download the Adventureworks database. I keep getting the error “full-text search” missing even though I downloaded the “runtime with advanced services” version that say it comes with “full-text search”. I have tried the suggestions on the AdventureWorks download site, but nothing has worked.

What do I need to do to get this set up correctly? I had SQL Server 2005 – from a CD – and had no problems. I really don’t want to go back to that version.

paul60135 Oct 8 at 11:23 PM 
I have found a solution, keep my project in Oracle

mcastel Oct 14 at 7:29 PM 
Executed SQL2008.AdventureWorks_All_Databases.x64.msi on SQL Server 2008 x64 Developer Edition. Install was quick and simple without any issues. Thanks.

Bodica Oct 21 at 10:18 AM 
I installed SQL 2008 Standard on Windows XP Professional SP3 on my laptop. I can't install the SQL2008.AdventureWorks_All_databases.x86.msi - when I choose the default instance MSSQLSERVER(Engine) the NEXT button doesn't activate. Can anyone help me how to fix it? All prerequisites are fulfilled:Full text search,Filestream enabled,Full-text filter Daemon Lancher running.

trcoley Oct 24 at 3:20 AM 
I have SQL Server 2008 x64, apparently an Express edition, so I cannot use these samples.
Can you update the prerequisites instructions to describe how to "upgrade" to Express with Advanced Services without destroying my current development environment?

nachid Oct 31 at 6:47 PM 
What someone should do when he gets an error message saying
"The setup wizard ended prematurely because of error"
Why on the hell this is so difficult?
Updating...
© 2006-2009 Microsoft | About CodePlex | Privacy Statement | Terms of Use | Code of Conduct | Advertise With Us | Version 2009.10.27.15987