AdventureWorks Datenbanken nachinstallieren

Eigentlich sollte man die Samples ja gleich mit installieren, aber vergisst man halt auch mal.
Und dann mal versuchen das wieder zu ändern – so geht’s:

1. From Add or Remove Programs, select Microsoft SQL Server 2005 and click Change. Follow the steps in the Microsoft SQL Server 2005 Maintenance wizard.

2. From Component Selection, select Workstation Components and then click Next.

3. From Welcome to the SQL Server Installation Wizard, click Next.

4. From System Configuration Check, click Next.

5. From Change or Remove Instance, click Change Installed Components.

6. From Feature Selection, expand the Documentation, Samples, and Sample Databases node.

7. Select Sample Code and Applications.

8. Expand Sample Databases and then select the sample databases to be installed. Click Next.

9. To install and attach the sample databases, from Sample Databases Setup, select Install and attach sample databases, and then click Next.
The database files are created and stored in the folder <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Data. The database is attached and ready for use.

10. To install the sample database files without attaching, from Sample Databases Setup, select Install sample databases without attaching, and then click Next.
The AdventureWorks database files are created in the folder <drive>:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP. AdventureWorksDW files are created in the <drive>:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Data Warehouse folder. You must attach the database before you can use it. For more information, see Detaching and Attaching Databases.

11. Select the instance of SQL Server on which to install the sample databases and samples.

12. Complete the steps in the wizard.

13. To complete the installation of the samples, after setup, perform one of the following steps:

a. From the Start menu, click All Programs, click Microsoft SQL Server 2005, click Documentation and Tutorials, click Samples, and then click Microsoft SQL Server 2005 Samples.

b. Alternatively, using Windows Explorer, navigate to <drive>:\Program Files\Microsoft SQL Server\90\Tools\Samples\ and double-click SqlServerSamples.msi to launch the installer.