Microsoft KB Archive/921902

= You receive a &quot;Sample database 'Adventureworks' already exists in SQL instance specified&quot; error message when you use Add or Remove Programs to install the AdventureworksDW Sample Data Warehouse sample database in SQL Server 2005 =

Article ID: 921902

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Standard X64 Edition

-



SYMPTOMS
Consider the following scenario on a computer that has Microsoft SQL Server 2005 installed:
 * During the SQL Server installation, the Adventureworks Sample OLTP sample database was installed, but the AdventureworksDW Sample Data Warehouse sample database was not installed.
 * You try to install the AdventureworksDW Sample Data Warehouse sample database by using the Add or Remove Programs Control Panel item.
 * During the AdventureworksDW Sample Data Warehouse sample database installation, you select Will be installed on local hard drive in the Feature Selection dialog box. Then, you perform the following additional operations:
 * You select Entire feature will be unavailable for the Adventureworks Sample OLTP sample database that has been installed on the computer.
 * You then select Will be installed on local hard drive for the Adventureworks Sample OLTP sample database.

When you try to install the sample database and attach it to an existing instance, you receive the following error message:

Sample database 'Adventureworks' already exists in SQL instance specified



CAUSE
This issue occurs because the Setup program validates both the sample databases if you perform the additional operations. The validation for the AdventureworksDW Sample Data Warehouse sample database fails because the database already exists.



RESOLUTION
To resolve this issue, run the Setup program again, but do not perform the additional operations.

Note You can install the sample database without attaching the database to the instance of SQL Server 2005. Then, you can attach the database manually. In this case, you do not have to run the Setup program again.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbtshoot kbprb kbexpertiseadvanced kbsql2005setup KB921902

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.