You receive a "Sample database 'Adventureworks' already exists in SQL instance specified" error message when you use Add or Remove Programs to install the AdventureworksDW Sample Data Warehouse sample database in SQL Server 2005 (921902)


The information in this article 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
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • 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 "Applies to" section.
Modification Type:MajorLast Reviewed:7/21/2006
Keywords:kbtshoot kbExpertiseAdvanced kbsql2005setup kbprb KB921902 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.