Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ewomack
Starting Member
33 Posts |
 Posted - 2010-08-15 : 10:04:56
|
| Trying to complete a book that relies on a sample database that no longer seems to exist has driven my skull to near fracturing point. I'm simply trying to download the AdventureWorks2008 database from Microsoft's codeplex site. When the file finishes downloading, I have all of the other databases (DW, DW2008, LT, LT2008 and the original "AdventureWorks") but AdventureWorks2008 just evades installation. A few blog posts exist that suggest changing filestream to 2, but this has changed nothing. Has anyone else run into this brick wall? I'm more than half way through a great book that relies on "AdventureWorks2008" and so far the original "AdventureWorks" has sufficed, but the current chapter suddenly came to a halt. Ugh.Thank you!Ed Womackwww.getmilked.com |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-15 : 10:44:27
|
| Check the service account that SQL Server runs under. If it's NETWORK SERVICE you have to change it to LOCAL SYSTEM. There is documentation somewhere that it won't install under the NETWORK SERVICE account. |
 |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-08-31 : 09:04:49
|
| Microsoft transmogrified what was a simple process of retrieving the SQL Server sample database, from formerly a bak file that one would easily unzip and restore, into a massive nightmare for legions of IT workers looking to expand their horizons via self study and training.Microsoft seems to have a history of doing this sort of thing. Adding fuel to the fire is Microsof is indifferent.______________________________________________Talk sense to a fool and he calls you foolish. |
|
|
|
ewomack
Starting Member
33 Posts |
Posted - 2010-09-09 : 10:17:27
|
| Thanks for the replies. I did finally figure this out; it had to do with a few settings in SQL server itself. I ended up following, more or less, the steps on this site:[url]http://www.bidn.com/blogs/timmurphy/ssas/519/missing-adventureworks2008-found[/url]Ed Womackwww.getmilked.com |
|
|
|
|
|
|
Missing AdventureWorks2008 DB?