asked on 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.
Thanks as always,
JPertchik
Thanks as always,
JPertchik
Microsoft SQL Server 2008Microsoft SQL ServerSSAS
Last Comment
jpertchik
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
Re the *, I believe it refers to the different versions of AdventureWorks, some have additional data for Business Intelligence (reporting) development etc
ASKER
I tried to install SQL Server 2008 SR4 and it was not sucessful
> it was not sucessful
What sort of error did you encounter?
What sort of error did you encounter?
ASKER
give me a minute, i'll get a screen capture
ASKER
Here is the error message that i got. I am running SQL 2008 Developer on Windows 7 pro 64bit
errormsg.JPG
errormsg.JPG
ASKER
What does this error mean?
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?
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?
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.
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.
ASKER
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
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
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You will see links for R2, 2008 and 2005.