1.1

Locate the installation media. You can use a CD or DVD, but it is more usual to use the files on the shared drive.

You can use the same SQL Server™ installation media whether you are installing 32-bit or 64-bit – you can choose which one will be installed.

1.2

Log on to the server as an account with Local Administrator privileges. 

If you are using Terminal Services (Remote Desktop) then it is best to use mstsc/console to start this since you are more likely to be able to reboot the server successfully if necessary.

1.3

To begin the installation, browse the installation folder and run setup.exe from the root.  Click on OK and follow the steps to install .Net if you see the message below – you will probably have to reboot and start again afterwards.

If .Net does not install automatically then you can download DotNet 3.5 from Microsoft website and then install it manually.

Rerun the setup program, and it will start by installing the updated installer.  Restart the computer if prompted, and run setup again.

1.4

The first screen is the SQL Server Installation Center.  Click on System Configuration Checker – The System Configuration Checker is now scanning your computer for conditions that may cause possible installation problems.  Correct any errors that are identified before continuing.

A warning does not necessarily prevent installation from continuing. Click in the Message column for more detailed information on actions that do not have a green success icon beside them. 

If the IIS Feature Requirement has an error or warning, you must be sure that IIS is configured correctly.

1.5

In the navigation pane, click Installation and then choose New installation or add features to an existing installation.

Security Warnings window will appear, click Run to continue.

More Setup Support Rules will now run, once completed click OK to continue.

1.6

In the Product Key window, enter the Product license key (if required), and click Next to continue.

1.7

In the License Terms window, tick the box I accept the license terms and then click Next to continue.

You must accept the license agreement before you can continue the installation of SQL Server™.

Send feature usage data to Microsoft option is optional.

1.8

Setup Support Files window will now appear.

In the Setup Support Files window, click on Install to install setup support files and then click on OK to continue.

1.9

Again some more Setup Support Rules will now run, once completed click Next to continue.

1.10

In the Setup Role window, select the SQL Server Feature Installation and then click on Next to continue.

1.11

In the Feature Selection window, select the Reporting Services; then click on Next to continue.

1.12

Now setup will run some more Installation Rules.

Once completed, click Next to continue.

1.13

In the Instance Configuration window, select a Default or Named Instance for your installation.

• Select Default Instance to install Reporting Services on your default instance of SQL server, and click on Next to continue.

• Select Named Instance and enter the instance name to install Reporting Services to another instance of SQL server, and click on Next to continue.

1.14

In the Disk Space Requirements window, review the disk space summary for the SQL Server Reporting Services feature;

Click on Next to continue.

1.15

In the Server Configuration window, Enter the account name, password, and domain for your SSRS service account. 

Click on Next to continue.

1.16

In the Reporting Services Configuration window, There will only once choice available i.e. Install, but do not configure the report server which is selected by default.

Click on Next to continue.

1.17

In the Error Reporting window, select the required error and usage report settings. 

Click on Next to continue.

1.18

Now setup will run some more Installation Configuration Rules

Once completed, click Next to continue.

1.19

In the Ready to Install window, review the installation summary screen, taking particular note of any actions ensuing from the installation.

Click on Install to start the installation.

1.20

The Installation Progress window appears, allowing you to view the status of the installation. The installation process will take some time to complete.

Click on Next after the installation is completed successfully.

1.21

When the installation is complete, click on Next.  Click on the link to review the installation log if appropriate, and then click on Close.

1.22

Apply the latest service pack for SQL Server™ 2008 R2.  At the time of writing, this was Service Pack 1.

2.1

To configure Reporting Services, start Report Server Configuration Manager.

(Start > All Programs > Microsoft SQL Server 2008 R2> Configuration Tools > Reporting Services Configuration Manager)

2.2

Log on to the server as an account with Local Administrator privileges. 

If you are using Terminal Services (Remote Desktop) then it is best to use mstsc/console to start this since you are more likely to be able to reboot the server successfully if necessary.

2.3

Enter the name of a server and select an instance to connect to in the Reporting Services Configuration Connection window. Click Connect.

If you installed Reporting Services on a Web server where SQL Server isn’t installed, connect to the reporting server and not the SQL server.

2.4

The Report Server Status page displays status information about the instance that you’ve selected.

If Reporting Services isn’t running, click the Start button in the Report Server Status page.

2.5

Since we specified the service account during setup, the details should be present and correct in Service Account page. 

2.6

In the navigation pane, click Web Service URL to open Web Service URL page. Default values for the web service are already entered for you. Click on Apply to accept these settings.

2.7

In the navigation pane, click Database to open the Report Server Database page. Use the Report Server Database Configuration Wizard to enter the details of the server that the database will reside on. 

2.8

In the navigation pane, click Report Manager URL to open the Report Manager URL page.

Default values for Report Manager are already entered for you. Click on Apply to accept these settings.

2.9

In the navigation pane, click E-mail Settings to open the E-mail Settings page.

Enter the SMTP details and click on Apply to accept changes.

2.10

In the navigation pane, click Execution Account to open the Execution Account page. Specify account and password.

Click on Apply to confirm action.

You only need to configure an execution account in the following circumstances:

• When the report server connects to a data source that does not require credentials. Examples of data sources that might not require credentials include XML documents and some client-side database applications.

• When the report server connects to another server to retrieve external image files or other resources that are referenced in a report.

You will not normally need to set up one of these accounts; if you do, follow the procedures on the following web page:

http://msdn.microsoft.com/en-us/library/ms181156.aspx

3.1

Report Manager is installed during setup on the same computer as the report server. You should verify you installation by connecting to the Report Manager.

In a browser window, type http://localhost/reports

(http://<computer name>/Reports<instance name>) this is the virtual directory for Report Manager. Use Report Manager to create a new folder or upload a file to test whether definitions are passed back to the report server database. If these operations are successful, the connection is functional.

If Site Settings is not available, you do not have permission to access site settings.

3.2

Click on Site Settings.

3.3

In the navigation pane, click Security to open the Security Settings page.

3.4

Click New Role Assignment. Type <DBA’s Group Name> in textbox next to new user or group name and select System Administrator checkbox in role definitions section.

Click OK to apply.

3.5

Remove BUILTIN\Administrators group from the site by selecting the group and then click Delete button. Click Home to return to Home page.

3.6

Click the Folder Settings >> Click New Role Assignment to open the New Role Assignment page. Type <DBA’s Group Name> in textbox next to new user or group name and select Content Manager checkbox in role definitions section.

Click OK to apply.

Don’t forget to remove BUILTIN\Administrator group.