Chapter 2. Set Up and Configuration

Follow the instructions that ship with SQL Server to install Reporting Services in your environment. The examples in this book assume that the SQL Server installation is on a local computer with the default configuration. The examples also assume that the login account has administrative permissions on the local computer.

Use SQL Server Configuration Managera tool used to manage services associated with SQL Serverto ensure that SQL Server and SQL Reporting Services services are running. Start Configuration Manager by selecting All Programs Microsoft SQL Server 2005 Configuration Tools SQL Server Configuration Manager from the Start menu. Select the SQL Server 2005 services Node in the left pane to view the state of each SQL Server 2005 Service as shown in the following figure.

Figure 2-1. SQL Server Configuration Manager

Ensure that Reporting Services are configured properly. To do so, start Reporting Services Configuration Manager by selecting All Programs Microsoft SQL Server 2005 Configuration Tools Reporting Services Configuration from the Start menu. The Reporting Services Configuration Manager Figure 2-2. Reporting Services Configuration Manager

Ensure that none of the items in the left pane are marked Not configured. Items marked Optional configuration or Recommended configuration don't need to be configured. Consult SQL Server Books Online for help using Configuration Manager.

Once you've checked that Reporting Services is correctly deployed, you can deploy the sample reports. Follow these steps to extract, compile, and deploy sample reports to the report server:

1. Run the wizard that extracts the SQL Server samples (including reports) by selecting All Programs Microsoft SQL Server 2005 Documentation and Tutorials Samples Microsoft SQL Server 2005 Samples from the Start menu.

   NOTE

   Business Intelligence Development Studio is a Microsoft Visual Studio 2005 tool that includes project types that are specific to SQL Server 2005. Business Intelligence Studio is the main tool used to develop Analysis Services, Integration Services, and Reporting Services projectsit supplies templates, designers, tools, and wizards specific to each project type.

   If you install Visual Studio 2005, the Business Intelligence Development Studio project types will be added to Visual Studio 2005. Launching Business Intelligence Development Studio will launch Visual Studio 2005.

2. Open Business Intelligence Development Studio by selecting All Programs Microsoft SQL Server 2005 SQL Server Business Intelligence Development Studio from the Start menu.

3. Open Project/Solution from the main menu to display the C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report Samples\AdventureWorks Sample Reports\AdventureWorks Sample Reports.sln.

4. Change the active configuration of the project from Debug to Production by setting the drop-down list on the Standard toolbar as shown in the following figure.

   Figure 2-3. Standard Toolbar

   

5. Compile the reports and publish them to the report server by selecting Build Deploy AdventureWorks Sample Reports from the main menu.