SQL Server: Installing BIDS 2008R2 (Developer Edition)

After inserting the CD and running the Setup.exe the following User Account Control (UAC) dialog will appear;

SQL Server 2008 R2 UAC Dialog

Click "Yes".

The SQL Server Installation Center dialog will now appear;

SQL Server Installation Center

Click on "Installation" on the left (highlighted above);

SQL Server Installation Center (Installation Page)

Click "New installation or add features to an existing installation" (the top option on the right);

SQL Server 2008 R2 Setup

The installation program will run some tests to make sure your system can run the software. I'm installing onto Windows 7 Enterprise (32-bit). If there any any issues you'll need to resolve them before it will allow you to continue. Click "OK";

SQL Server 2008 R2: Product Key Dialog

After entering your product key click "Next";

SQL Server 2008 R2: License Terms

Click on the "I accept the license terms" checkbox (after reading it of course!) and then click "Next";

SQL Server 2008 R2: Setup Support Files

Click "Install" (if the installation of Setup Support Files fails with 1605 or 1608 error message then you may be interested in this post here - thank you Sage!);

SQL Server 2008 R2: Setup Support Rules

Click "Next";

SQL Server 2008 R2: Setup Role

Click "Next";

SQL Server 2008 R2: Feature Selection

Select "Business Intelligence Development Studio" (I've also chosen the Client/ Management Tools as they're often quite useful as well). Click "Next";

SQL Server 2008 R2: Installation Rules

Click "Next";

SQL Server 2008 R2: Disk Space Requirements

Click "Next";

SQL Server 2008 R2: Error Reporting

Click "Next";

SQL Server 2008 R2: Installation Configuration Rules

Click "Next";

SQL Server 2008 R2: Ready to Install

Click "Install";

SQL Server 2008 R2: Installation Progress

Wait for the installation to complete (takes about 10 minutes);

SQL Server 2008 R2:Complete

Click "Close".

You can now find SQL Server Business Intelligence Development Studio on your start menu;

SQL Server Business Intelligence Development Studio

NOTE: One of the fantastic anomalies with BIDS is that unless you have Integration Services installed locally you don't seem to actually do deploy to a remote server from within BIDS - you need to deploy to the file system and then use management studio to deploy to the server.

Also unless you install Integration Services *locally* you won't be able to test the deployed package on your system.