December 1, 2008 at 11:29 am
I tried to load AdventureWorksDB.msi downloaded from the CodePlex website for SS2005. It did not finish but hung up. I deleted the databases from Management Sudio and then went into Add/Remove programs removed Samples. Now when I try to re-run the AdventureWorksDB.msi I get the following message.
"Another version of this product is already installed. Installation of this version cannot continue. to configure or remove the existing version of this product, use Add/Remove Programs on the Control Panel."
Any ideas how I can get AventureWorks restored.
I am using SQL Server 2005 Developer 9.0.3073
December 1, 2008 at 11:37 am
I assume it's not listed in sys.databases at all?
I might look to remove anything from the registry that references it. Not sure what's there, but dig around under HKLM/Software/Microsoft/Microsoft SQL Server and see if there's a set of keys.
December 1, 2008 at 12:14 pm
I'm guessing you've already tried a reboot? If not, perhaps there is something leftover from the initial install that was hung up pending a reboot.
You have no idea how many times a mcafee patch has left something boot pending (when it didn't ask for a reboot) that had me scratching my head as to why something else wouldn't install...
-Luke.
December 1, 2008 at 2:28 pm
I did check sys.databases and no AdventureWorks databases are listed.
Also, I did reboot Windows. I am going to reboot again just in case.....
I did a search for AdventureWorks in the Registry and found it in many areas:
My Computer\HKEY_CLASSES_ROOT\Installer\Features\
My Computer\HKEY_CURRENT_USER\Software\Microsoft\Installer\Featuers\
My Computer\HKEY_CURRENT_USER\Software\Microsoft\Installer\Products\
My Computer\HKEY_CURRENT_USER\Software\Microsoft\Installer\Products\ \SourceList
My Computer\HKEY_CURRENT_USER\Software\Microsoft\Installer\Products\ \SourceList\Net
My Computer\HKEY_CURRENT_USER\Software\Microsoft\Search Assistant\ACMru\5603
My Computer\HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0
My Computer\HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\ProjectMRUList
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Featuers\
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Uninstall Info\
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\Folders
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\
....and many more
I'm not sure if I remove any of these I will hose up Windows?
December 2, 2008 at 6:18 am
If this is on a Dev workstation Win XP or Vista, you could use System restore to restore back to before you attempted to install adventureworks.msi. windows should have automatically created a checkpoint. Rolling back to that point should be fairly straightforward and is much easier than trying to manually delete all of those registry keys.
-Luke.
December 2, 2008 at 6:35 am
Thanks for everyone's help on this, I really appreciate your time!
I am running this (SQL Server 2005 Developer) on my company workstation (not enough hardware available to run it elsewhere). I can't afford to hose up my workstation and yet I really need to load AdventureWorksDB, AdventureWorksDW, etc. for testing a certain scenario (moving Analysis Servcies and Reporting Services to a temporary local server from an off site server).
I am worried about deleting too much in the windows registry and hosing up the PC. I am not sure what I can and can not delete out of the registry safely. Do you think its the entries under the Installer area or the features area or both?
December 2, 2008 at 8:24 am
I would skip the MSI installation, and find the scripts (along with lots of CSV's) to manually create the AdventureWorks 2005 DB
I don't know why MS makes it so difficult to install a Sample DB, I can't even find the DB scripts now
Maybe you can find the .bak of the AdventureWorks in the Samples directory, and just restore it
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
http://msdn.microsoft.com/en-us/library/ms143758(SQL.90).aspx
December 2, 2008 at 9:48 am
Pinged the guy in charge of samples. We'll see if he responds.
Jerry has a decent idea. Just attach the databases. I think I did that for 2008.
December 2, 2008 at 9:59 am
Can I get just the databases for SQL 2005? I thought I only saw .msi files to download for 2005?
If I attach the data warehouse (AdventureWorksDW) will Analysis Services work then?
Again, thanks for the responses.
December 2, 2008 at 11:00 am
Through a miracle of modern science I noticed some instructions on the CodePlex website on how to load AdventureWorks through the Add/Remove Programs. I took a shot and tried following those instructions and it worked! I now have the samples and databases back on my PC! I am one happy camper!!
Thanks to everyone for your suggestions! I really appreciate your time you gave to me.
December 3, 2008 at 1:02 pm
Hey, Steve, next time tickle the work email address and I'm more likely to see it in a timely fashion.
😀
Looks like George got everything squared away before I caught up on email. If anybody else needs/wants something specific, just reply and I'll help out as best I can.
December 3, 2008 at 4:03 pm
Hey, I figured you'd check the personal one before work on vacation 😀
December 3, 2008 at 4:51 pm
Fortunately, working is more restful than vacationing via an airline which shall remain nameless. It only took a mechanical failure, three different planes and an additional 24 hours stranded in Yakima of all places (after the third plane ran out of gas) to get home from Texas. Heh. I was surprised to learn that they actually have 5 gates @ the Yakima airport, although none of them have jetways. Walking across a runway to get to the plane was an experience that I haven't had since I quit skydiving in 2005. Ah, the memories! For the record, I only use personal email for things I don't want BillG to read.
😎
December 4, 2008 at 8:33 am
Just to add, I did this trying to use for 70-431 exam
Downloaded the AdventureDB.msi (28MB) from CodePlex
ran the install, specificy a location, and it simply creates/extracts the MDF and LDF (didn't install nor attach it for me)
AdventureWorks_Data.mdf (176MB)
AdventureWorks_Log.ldf (2MB)
I just attached them in SSMS, voila!
December 4, 2008 at 8:43 am
I finally did get the AdventureWorks.mdf and AdventureWorksDW.mdf installed. Now I am having problems loading the solution (AdventrueWorks Analysis Services Project\Standard) for Analysis Services. It is giving me trouble with the OLE DB connection. SQL 2005 is not my default it is a version of SQL 2000 that is the default. I know this is kind of a new subject so I'm not sure if I should start a new post?
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply