Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 703
  • Last Modified:

SQL 2008 sample database.

I'm working on a self study book by Microsoft about SQL server 2008, not 2008R2. I can't seem to find the sample databases AdventureWorks2008*.msi, and AdventureWorksDW2008*.msi. All Microsoft has to offer is the R2 versions. Does anyone in the EE community have a good source for these files? Also, what does the "*" in the file name stand for? Is it a wild card meaning that the R2 databases would work as well, or is it referring to 32 vs. 64 bit? Please enlighten.

Thanks as always,
JPertchik
0
jpertchik
Asked:
jpertchik
  • 6
  • 4
1 Solution
 
cyberkiwiCommented:
If you go to  http://sqlserversamples.codeplex.com/

You will see links for R2, 2008 and 2005.
0
 
cyberkiwiCommented:
In particular  http://msftdbprodsamples.codeplex.com/releases/view/37109

Re the *, I believe it refers to the different versions of AdventureWorks, some have additional data for Business Intelligence (reporting) development etc
0
 
jpertchikAuthor Commented:
I tried to install SQL Server 2008 SR4  and it was not sucessful
0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
cyberkiwiCommented:
> it was not sucessful

What sort of error did you encounter?
0
 
jpertchikAuthor Commented:
give me a minute, i'll get a screen capture
0
 
jpertchikAuthor Commented:
Here is the error message that i got. I am running SQL 2008 Developer on Windows 7 pro 64bit
errormsg.JPG
0
 
jpertchikAuthor Commented:
What does this error mean?
0
 
khairilCommented:
Hi,

Make sure you SQL Server (MSSQLSERVER) service is running, you check and run that from Service Applet (under Administrative Tools).

BTW is that only instance of SQL Server in your computer?
0
 
cyberkiwiCommented:
http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Databases

It is one of many common install issues with Adventureworks.  This site says

a) The account used for the install must be a member of the Windows local Administrators group (as documented)
b) The account must be a sysadmin in SQL Server
c) The account must be enabled in SQL Server
d) The account must be an administrator in SSAS (if you are installing the AS version of the DB)

Are you after a particular variant of AdventureWorks or will the lightest one (LT) do?  I could possibly find you a zipped MDF/LDF that you can just attach.
0
 
jpertchikAuthor Commented:
It appears as if the account i'm installing from is a domain\username account, not local. Do i need to logoin to Windows locally?

Also...

This might do the trick:
"Are you after a particular variant of AdventureWorks or will the lightest one (LT) do?  I could possibly find you a zipped MDF/LDF that you can just attach."

I am trying to do the exercises in a book, so avariant might or might not do the trick. I'm certainly willing to try.

Thanks,
JPertchik
0
 
jpertchikAuthor Commented:
I reinstalled SQL and got a copy of the files, expanded, signed in as "sa" and ws ujp and going.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now