Search This Blog

August 30, 2007

Error 1721: Installing AdventureWorksDB 2008 is not working

Today I went to the following website to download the AdventureWorksDB databases. I wanted to attach it to my SQL Server 2005 in my windows XP with SP2. Finally it was not working for me.

http://www.codeplex.com/MSFTDBProdSamples

When I installed, it had the following error.

Error 1721. There is a program with this windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: InstallDatabase, location:..\AdventureWorks_log.ldf) FOR ATTACH;”


After the install, the sample files were really under C:\Program Files\Microsoft SQL Server\100. They were not useful because when I opened SQL Server 2005 and tried to attach it, it didn’t work. There is nothing to do with windows installer package. It proves the latest AdventureWorksDB is only for SQL Server 2008.

If you really want to use it in SQL Server 2005, just download AdventureWorksDB of SQL Server 2005 as follows:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

You can finish your task.

2 comments:

Anonymous said...

Thanks man!

I was searching for a solution to this problem, and your article really helped me! ;)

Thank you very much!!!

Ray Lin said...

My pleasure. :)