[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 699
  • 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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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