How to: Configure SharePoint Integration on a Standalone Server
New: 15 September 2007
One of the deployment scenarios for running Reporting Services in SharePoint integrated mode is to install all server components and application databases on a single, standalone server. This configuration is useful if you want to learn how the technologies work together, or you are developing a custom application and want the simplicity of having all services on a single computer. The following illustration shows the components you must install.
Before you begin installing components, be sure to do the following:
- Review the introduction to deployment configurations so that you are familiar with the components that you are about to install. For more information, click Deployment Configurations for Reporting Services in SharePoint Integrated Mode.
- Review the configuration overview topic for best practice recommendations on service account configuration and to learn more about the configuration steps. For more information, click Configuring Reporting Services for SharePoint 3.0 Integration.
- Review the hardware and software requirements that apply to all deployment scenarios that include Reporting Services in SharePoint integrated mode. For more information, click Requirements for Running Reporting Services in SharePoint Integrated Mode.
- Review the remaining items in this section to learn about additional requirements that apply to a standalone server configuration.
Database Considerations for Standalone Server Configuration
Both Reporting Services and SharePoint products and technologies use SQL Server relational databases to store application data. Reporting Services requires an instance of the Database Engine in a compatible edition. SharePoint products and technologies can use an existing database server if you provide one. If you do not, the Setup program will install SQL Server Embedded Edition as an internal component and use it for the application databases. Because you are already installing the Database Engine for Reporting Services, you might consider using that same instance for the SharePoint application databases as well.
However, if you allow Setup to install and use SQL Server Embedded Edition, you can significantly reduce the number of installation and configuration steps. If you have sufficient disk space, you should use the Embedded Edition that SharePoint provides.
If you do not want multiple instances of SQL Server on your computer, you can use the Database Engine for the SharePoint configuration and content databases. To do so, you must choose the Advanced installation option when installing a SharePoint product or technology.
The report server instance cannot use the Embedded Edition for its database. However, the Embedded Edition instance that is installed by the SharePoint product or technology can exist side-by-side other Database Engine editions that you might also install. For more information about edition requirements for the report server database, see Creating a Report Server Database.
Default Port and Web Site Considerations for Standalone Server Configuration
Installing the report server and the instance of the SharePoint product or technology on the same computer requires that you assign a unique port number to each Web application. If you choose the Basic installation option or use default settings when installing the SharePoint product or technology, the SharePoint Products and Technology Configuration Wizard will use the default Web site and assign port 80 to the top-level site when configuring the SharePoint Web application. If you want to use the default Web site for a report server, you must choose a different port for the default Web site and then start the Web site.
You can install the component technologies in any order, but for best results you should install Reporting Services first and verify that you have a valid installation before you install the SharePoint product or technology.
To save steps, you should install both Reporting Services and the Database Engine at the same time. Because you are installing the Database Engine and Reporting Services together, you will most likely have the option of installing Reporting Services in the default configuration, where virtual directories, service accounts, and report server databases are configured automatically during installation.
The following list provides a summary of the deployment tasks:
- Install Reporting Services and Database Engine. If possible, choose the Install the default configuration option when installing Reporting Services.
- Configure the report server if it is not configured already, and verify you have a valid installation.
- Apply SQL Server 2005 SP2.
- Download and install the Microsoft .NET Framework 3.0 redistributable package.
- Install Windows SharePoint Services or Office SharePoint Server 2007. If possible, choose the Advanced installation option.
- Run the SharePoint Products and Technologies Configuration Wizard and then open the SharePoint site to verify you have a valid installation.
- Download and install the Reporting Services Add-in for SharePoint Technologies.
- Configure the report server integration features in Central Administration.
To install Reporting Services and the Database Engine
- Install Reporting Services and the Database Engine on the same computer. For more information, see How to: Install Reporting Services on a Single Computer.
After Setup is finished, you can verify that installation succeeded by opening Report Manager. You can open Report Manager by entering http://localhost/reports in the URL address of a browser window.
Later, after you configure a report server for SharePoint integrated mode, Report Manager will no longer be available. However, because the report server is running in native mode at this point, you can use Report Manager to verify the installation.
If you did not install the default configuration, you can open the Reporting Services Configuration tool to configure the report server for operation. For instructions, see Reporting Services Configuration How-to Topics.
To apply SQL Server 2005 Service Pack 2
Download and install SQL Server 2005 SP2. For more information, see How to obtain the latest SQL Server 2005 Service Pack on the Microsoft Web site.
You can apply SP2 over a configured or unconfigured Reporting Services installation.
You can accept all the default values for the SP2 installation.
Be sure that both the Database Engine (MSSQLSERVER) and Reporting Services (<servername>\ReportServer) instances are selected for the SP2 upgrade.
To download and install .NET Framework 3.0 Redistributable Package
Download the .NET Framework 3.0 from the Microsoft Download Center.
Run Setup. Setup runs in the background and might take a while to complete. To check its progress, click the Microsoft .NET Framework 3.0 Installation icon in the notification area of the taskbar.
To install and Configure Windows SharePoint Services or Office SharePoint Server
Run Setup.exe from the installation media.
Enter the 25-character product key.
Accept the software license agreement.
This option provides the fewest installation steps. It immediately installs the software using all default values. It also automates the configuration steps for setting up Central Administration and the default SharePoint site.
If you want to use an existing Database Engine instance, you must click Advanced instead. When you choose this option, Setup provides the Complete installation option that you can use to specify which database server to use. Be aware that choosing the Advanced installation option increases the complexity of the configuration steps you must perform later. For more information about how to specify and configure an Advanced installation, follow the "To install a SharePoint product or technology" procedure in How to: Configure SharePoint Integration on Multiple Servers. When you finish the Advanced installation and configuration steps in the multi-server deployment topic, return to this topic, edit the port assignment and continue with the remaining tasks.
In the Finished page, verify that the check box is selected for Run the SharePoint Products and Technologies Configuration Wizard.
After Setup closes, the SharePoint Products and Technologies Configuration Wizard runs. Because you chose the Basic installation option, configuration tasks run in the background and you can click Finish when the configuration tasks are complete.
Verify that installation succeeded. By default, a SharePoint site will open in a browser window after the configuration tasks are complete. This step verifies the installation and configuration process.
By default, SharePoint Products and Technologies Configuration Wizard assigns port 80 to the SharePoint Web application, which will cause the report server to become unavailable. As a result, you must now modify report server configuration settings to use a different port and you must start the default Web site.
To edit the Port Assignment for the Default Web Site
Start IIS Manager. Click Start, click Administrative Tools, and then click Internet Information Services.
Right-click Properties on the Default Web Site.
Specify a different port. By default, a SharePoint Web application uses port 80. To run the report server on the same computer under the default Web site, select a different unused port (for example, 8080).
Start the Default Web site. By default, this site is stopped when you create and configure the site collection for the SharePoint Web application. You must restart this site to access the report server. To do this, right-click Default Web Site, and then click Start.
Open a browser window and type a URL that includes the port (for example, http://example-server-name:8080/reportserver) to verify that the report server is working.
If you used the default Web site configured for a specific port, use a text editor to edit the RSReportServer.config file to add the port to the UrlRoot configuration setting (for example, http://example-server-name:8080/reportserver). Reporting Services uses the UrlRoot configuration setting to construct links in e-mail messages that resolve to reports that are processed on a report server. For more information about this file, see RSReportServer Configuration File.
To create a Report Server Database for SharePoint Integrated Mode
Start the Reporting Services Configuration tool and connect to the report server instance. For instructions, see How to: Start Reporting Services Configuration.
In the navigation pane, click Database Setup.
In Server Mode, click Change.
Click Yes to confirm that you want to create a new report server database that supports SharePoint integrated mode operations.
In Database Name, type a name for the new database (for example, reportserverSharepointMode).
Verify that the check box Create a report server database in SharePoint integrated mode is selected.
Click OK to create the database.
Click Apply to automatically configure the remaining connection settings. You will be prompted to connect to the instance of the Database Engine to complete this step. Click OK to confirm the connection. For more information, see How to: Create a Report Server Database for SharePoint Integrated Mode (Reporting Services Configuration).
If you are working with a new installation of Reporting Services, you should also configure the unattended report processing account if you want to support unattended report execution. Optionally, configure the report server for e-mail delivery. For more information, see Configuring an Account for Unattended Report Processing and Configuring a Report Server for E-Mail Delivery.
To download and Install Reporting Services Add-in for SharePoint Technologies
Click Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint Technologies to go to the download page on the Microsoft Web site.
You must be a SharePoint Web farm administrator and Site Collection Administrator to install the Reporting Services Add-in.
Choose which language to install.
In Files to Download, click Download to install either the 32-bit or 64-bit version of the Reporting Services Add-in.
Click Save to save the file to a location on your computer.
Open Windows Explorer and browse to the folder where the file is located.
Double-click SharePointRS.msi to begin installation. For more information, see How to: Install the Reporting Services Add-in.
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.
To configure Report Server Integration
Click Start, click Administrative Tools, and then click SharePoint 3.0 Central Administration.
You must be a SharePoint Web farm administrator and Site Collection Administrator to install the Reporting Services Add-in.
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 the Report Server Integration Feature in SharePoint Central Administration.
Close Central Administration.
Verify integration by starting the Reporting Services Configuration tool and opening the SharePoint Integration page to view server status. You should see a link that you can click to start SharePoint Central Administration.
You can also verify an installation by opening a browser window to the report server. The URL should be similar to http://example-server-name:8080/reportserver. This URL is to the proxy endpoint. After you add report server items to a SharePoint library, you can open a browser window to this URL to view items on the site.
Finally, you should be able to open the SharePoint Web application and upload reports and other documents to a SharePoint library.
After you install all of 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:
- Open the SharePoint Web application. By default, the URL is http://<your-server-name>.
- Set permissions to grant user access to the SharePoint site. Security is required, but if you want to inherit existing permissions, you do not have to set permissions on specific items. For more information, see Managing Permissions and Security for Report Server Items on a SharePoint Site or How to: Set Permissions for Report Server Items on a SharePoint Site.
- Add Reporting Services content types if you want to create new shared data sources, report models, and Report Builder reports. For more information, see How to: Add Report Server Content Types to a Library (SharePoint Integrated Mode).
- Create shared data sources to use with reports and models. For more information, see How to: Create and Manage Shared Data Sources (SharePoint Integrated Mode).
- Create shared schedules to use with subscriptions or unattended report processing. For more information, see How to: Create and Manage Shared Schedules (SharePoint Integrated Mode).
- Publish report definition files (.rdl), data source files (.rds), and report model files (.smdl) to a SharePoint library. You can also use the Upload command in a SharePoint library to upload .rdl and .smdl files, but not .rds files. Depending on your permissions, you can also create reports in Report Builder and save them to a library. If the reports include references to shared data sources or external files, you must update the references. For more information, see Deploying Reports, Models, and Shared Data Sources to a SharePoint Site and How to: Upload Documents to a SharePoint Library (SharePoint Integrated Mode).
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 or SQL Server Management Studio. For a complete list of supported and unsupported features, see Features Supported by Reporting Services in SharePoint Integration Mode.
Requirements for Running Reporting Services in SharePoint Integrated Mode
Deployment Configurations for Reporting Services in SharePoint Integrated Mode
Deployment Modes for Reporting Services
Configuring Reporting Services for SharePoint 3.0 Integration
Reporting Services and SharePoint Technology Integration