You can install the component technologies in any order. For best results, confirm that each server product or technology is installed correctly before you integrate them

The following list provides a summary of the deployment tasks:

1. Install Reporting Services and Database Engine. If you are installing server software on a production server or if you are using a three-server deployment configuration, plan on choosing the Install but do not configure the server option so that you can control when and how the report server is configured.
   
2. Configure the report server, and verify you have a valid installation.
   
3. Download and install the .NET Framework 3.0 redistributable package.
   
4. Install Windows SharePoint Services or Office SharePoint Server 2007. Plan on choosing the Advanced installation option so that you can specify a remote database server during configuration.
   
5. Run the SharePoint Products and Technologies Configuration Wizard and select the database server.
   
6. Configure the site collection features in Central Administration and open the SharePoint site to verify you have a valid installation.
   
7. Download and install the Reporting Services Add-in for SharePoint Technologies.
   
8. Configure the report server integration features in Central Administration.
   

• Install Reporting Services and the Database Engine on the same computer or on different computers. For more information, see Considerations for Installing Reporting Services.

After Setup is finished, configure the report server for native mode operation to verify that the installation succeeded. Doing so allows you to use Report Manager to verify the installation.

For instructions on how to start the Reporting Services Configuration tool and configure the report server for operation, see Reporting Services Configuration How-to Topics.

1. On a different server that you will use for the instance of the SharePoint product or technology, download the .NET Framework 3.0 redistributable package from the Microsoft Download Center.

2. Run Setup. Setup runs in the background and might take awhile to finish. To check its progress, click the Microsoft .NET Framework 3.0 Installation icon in the notification area of the taskbar.

1. Run Setup.exe from the installation media for Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server .

2. Enter the 25-character product key.

3. Accept the software license agreement.

4. Click Advanced.

   1. On Server Type, click Web Front End
      
   2. The Data Location tab specifies file location for search index files. On Data Location, use the default value or select a computer that has excess disk space.
      
   3. Click Install Now.
      

5. Configure the SharePoint product or technology. The SharePoint Product and Technology Configuration Wizard should start after Setup is finished. If it does not, start it from Administrative Tools.

   1. Click Next on the Welcome screen.
      
   2. Click Yes to restart the services if required.
      
   3. On the Connect to a Server Farm page, click No, I want to create a new server farm, and then click Next.
      
   4. On the Specify Configuration Database Settings page, enter the database server name. If you installed the Database Engine as a default instance, the database server name is the computer name.
      
   5. In User Name and Password, type the credentials of a domain user account that has permission to log on to the computer, a SQL Server database login, and DBCreator permissions on the server. If possible, specify an account that is used only to run this application. Do not type the credentials of a user who will later access the SharePoint site; otherwise, that user might receive access denied errors later when accessing content on the site. Click Next.
      
   6. On the Configure SharePoint Central Administration page, click Next to accept all the defaults. If you know that impersonation and delegation features are enabled for Windows Authentication in your domain, you can select Negotiate (Kerberos) instead. Otherwise, select the default value and click Next.
      
   7. On Completing the SharePoint Products and Technologies Configuration Wizard, click Next to start the configuration using the settings that you specified.
      
   8. Click Finish.
      

1. Click Start, click Administrative Tools, and then click SharePoint 3.0 Central Administration. Follow the checklist in the Administrator's Tasks. For more information about each task, click the link Read the deployment steps and then open the Quick Start Guide. The tasks in the following steps are required.

2. Create a Web application:

   1. Click Create SharePoint Sites.
      
   2. Click Create new Web application.
      
   3. Select Create a new IIS web site (SharePoint - 80) using the default values. This includes using port 80, no host headers, default path, NTLM, and no Anonymous access. Be sure to specify the application pool process account. Choose a domain user account.
      
   4. Click OK.
      

3. Click Create Site Collection on the Application Created page.

   1. Enter a title.
      
   2. Use all default values. When specifying Primary Site Collection Administrator, specify an account that has local administrator permissions.
      
   3. Click OK.
      

4. Open a Command Prompt window and type iisrest /noforce.

5. Click the URL to verify the site.

6. (Optional) In Central Administration, enable diagnostic logging.

1. Install and configure a SharePoint Web front end on the report server computer. For instructions, see How to: Install a SharePoint Web Front-end on a Report Server Computer.

   1. A browser window will open to Central Administration on the primary server, allowing you to verify that the server farm configuration succeeded.
      

2. Configure the report server for integration:

   1. Start the Reporting Services Configuration tool and connect to the report server instance. For instructions, see How to: Start Reporting Services Configuration.
      
   2. In the navigation pane, click Service Account. Verify that it is using a domain user account. If it is not, configure it to use one.
      
   3. In the navigation pane, click Database.
      

      Note:
      If you are using a remote Database Engine instance, see How to: Create a Report Server Database for SharePoint Integrated Mode (Reporting Services Configuration) for more information.

   4. Click Change Database.
      
   5. Select Create a new database.
      
   6. Click Next.
      
   7. Specify the instance of the Database Engine that will host the database.
      
   8. Click Test Connection to verify that you can connect to it.
      
   9. Click Next.
      
   10. In Database Name, type a name for the new database (for example, reportserverSharepointMode).
       
   11. Select SharePoint Integrated Mode.
       
   12. Click Next.
       
   13. Specify credentials that the report server uses to connect to the report server database.
       
   14. Click Next.
       
   15. Click Next.
       
   16. Click Finish.
       
   17. Configure the unattended execution account and any other settings that you want to change. The values for the Report Server virtual directory should still be valid. However, Report Manager will no longer be available now that you have configured the report server to use a SharePoint integrated mode database (the tab for the Report Manager virtual directory should be shaded).
       

1. Click Microsoft SQL Server 200 to open the download page on the Microsoft Web site.

   Important:
   You must be a SharePoint Web farm administrator and Site Collection Administrator to install the Reporting Services Add-in.

2. Choose which language to install.

3. In Files to Download, click Download to install either the 32-bit or 64-bit version of the Reporting Services Add-in.

4. Click Save to save the file to a location on your computer.

5. Open Windows Explorer and browse to the folder where the file is located.

6. Double-click SharePointRS.msi to begin installation. For instructions, see How to: Install or Uninstall the Reporting Services Add-in.

7. Get the latest version of the readme file for the Reporting Services Add-in to review late-breaking changes and known issues. On the download page on the Microsoft Web site, in Files to Download, click Download to open the readme_rsaddin.htm file, and then save the file to your computer.

1. Click Start, click Administrative Tools, and then click SharePoint 3.0 Central Administration.

   Important:
   To complete the following steps, you must be a member of the SharePoint Farm Administrator group and a Site Collection administrator.

2. Click Application Management. You should see a new section named Reporting Services. This section has links to pages used to specify integration settings. If you do not see this section, you must activate the report server integration feature. For more information, see How to: Activate the Report Server Feature in SharePoint Central Administration.

   At a minimum, you must set the report server URL, select an authentication mode, and grant report server access to the SharePoint databases. For more information, see How to: Configure Report Server Integration in SharePoint Central Administration.

3. Close Central Administration.

You will get an error if the Reporting Services services are running under built-in accounts. If you already configured the services to use domain user accounts, restart the services to clear out old connection information (assuming that there are existing connections in the current session). For more information about service account configuration, see Configuring the Report Server Service Account.

After you install all the components and configure the settings for connecting server components, you must assign permissions, add content types, and add report server items to a SharePoint library.

To finish the deployment tasks for server integration

When you upload reports, make sure that the data source properties for the report are correct. The data source must have a valid connection string to an external data source. The credential type must be valid for your network topology. Specifically, if Kerberos authentication is not enabled for your domain, you cannot use the Windows integrated security credential type. Instead, you should specify stored credentials. After you verify the data source properties are correct, you can click the report name to open the report. The report will open in the Report Viewer Web Part automatically.

If the report does not open, check permissions on the report and the data source properties that define a connection to the external data source. On a site or farm, SharePoint permissions are used to control access to reports, report models, shared data sources, and the Report Builder tool used to create ad hoc reports. If these items are not visible to users, you should verify that permissions are set correctly.

A report server that runs in SharePoint integrated mode cannot be managed through Report Manager. For a complete list of supported and unsupported features, see Features Supported by Reporting Services in SharePoint Integrated Mode.

Tasks

Concepts

Other Resources