This project is read-only.


Error 1722 installing AdventureWorks Sample DB on a named instance of SQL2008


I tried to install the AdventureWorks Sample database on a named instance of SQL2008 and receive the following errors in the Application error log.
Event Type: Error
Event Category: (2)
Event ID: 948
Date: 11/26/2007
Time: 5:38:51 PM
The database 'AdventureWorks' cannot be opened because it is version 639. This server supports version 612 and earlier. A downgrade path is not supported.
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 11722
Date: 11/26/2007
Time: 5:38:55 PM
Product: Microsoft SQL Server 2008 AdventureWorksDB -- Error 1722.There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action InstallDatabase, location: C:\Program Files\, command: "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD" -S (local) -E -d master -Q "CREATE DATABASE AdventureWorks ON (name = 'AdventureWorks_Data', filename = 'C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks_Data.mdf'), (name = 'AdventureWorks_Log', filename = 'C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks_Log.ldf') FOR ATTACH;"
It looks like the installer is trying to attach the sample database to the default instance instead of the named instance. During the installation process I selected the named instance - see the attached sql_install_error.jpg.

file attachments

Closed Aug 12, 2008 at 10:10 PM by ReedMe
Corrected with the RTM release.


bonniefe wrote Dec 7, 2007 at 6:30 PM

Thanks for the report. There is a new installer available for SQL Server 2008 November 2007 CTP which should install correctly in this situation. Please try it out and let me know if it resolves this issue. Thanks!

CLuna wrote Dec 22, 2007 at 6:09 PM

I'm having the exact problem as well. Is there a fix for this?
I also tried to manually attach the DB and got the same error

wrote Aug 12, 2008 at 10:10 PM

wrote Feb 22, 2013 at 3:06 AM

wrote May 16, 2013 at 1:41 PM