Installing the Reporting Services Add-in

New: 12 December 2006

The Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint Technologies is a Web download that you can install on a server that has an instance of a SharePoint product or technology. It provides a set of features that enable you to run a report server within a larger deployment of Microsoft Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

Features include a Report Viewer Web Part, a proxy endpoint, and application pages so that you can create, view, and manage reports, report models, and other report server content on a SharePoint site.

You must be a SharePoint farm administrator to install the Reporting Services Add-in.

Preparing to Install

Installing the Reporting Services Add-in is one of many steps that are necessary for integrating a report server with an instance of a SharePoint product or technology. For more information about the complete set of steps, see Configuring Reporting Services for SharePoint 3.0 Integration. The order of steps for configuring the servers is important. For best results, be sure that you do them in order.

To prepare to install the Reporting Services Add-in:

  1. Verify that you have two server installations - a report server and a SharePoint server - that meet the requirements for integrated operations. For more information, see Requirements for Running Reporting Services in SharePoint Integrated Mode.
  2. Download the Reporting Services Add-in to a server that has an instance of the SharePoint product or technology. You can download the Reporting Services Add-in from the Microsoft Download Center.
  3. If you are integrating a SharePoint farm with a report server deployment, copy or download the Reporting Services Add-in to each computer in the farm that has a Web server front-end.

Installing the Reporting Services Add-in on a Standalone Server

  1. Run SharepointRS.msi on a computer that has the Web front-end for a deployment of the SharePoint product or technology that you want to configure for report server integration.
    Setup does not provide options for customizing an installation. Setup uses the existing folder structure of the current deployment when adding new files. Setup first verifies whether Windows SharePoint Services 3.0 is installed. Then Setup copies the application files to the new folder.
    Setup installs the Reporting Services Add-in in all supported languages. There is no language-specific Setup program. Application files for all supported languages are installed when you run Setup.
    Setup does not configure the server for integration with Reporting Services. You must configure integration after Setup is complete.
    You can run Setup using the Installation Wizard, from the command line, or in files-only mode. For instructions, see How to: Install the Reporting Services Add-in.
  2. After Setup is finished, go to Administrator Tools and click SharePoint 3.0 Central Administration.
  3. Click Application Management. You should see a new section named Reporting Services. This section has links to pages used to specify integration settings. For instructions on how to specify the settings, see How to: Configure the Report Server Integration Feature in SharePoint Central Administration.

Installing the Reporting Services Add-in on Virtual Servers in a SharePoint Farm

A deployment of Reporting Services integrates with a deployment of a SharePoint product or technology at the farm level. If you have multiple SharePoint Web applications in a farm configuration, you must install the Reporting Services Add-in on each computer that has a Web front-end. After you have installed the add-in on all computers, start Central Administration to configure report server integration for all the servers in the farm.

Setup Log Files

When Setup runs, it logs information to a log file in the %temp% folder for the user who is installed the Reporting Services Add-in The file name is RS_SP_<number>.log. Each error in the log starts with the string "SSRSCustomActionError".

Supported Languages

The Reporting Services Add-in supports the languages in the following list. Application pages that you use on a SharePoint site to view and manage report server items, and errors and warnings that appear on those pages, are available in the supported languages. Messages that originate from the report server and reports that you design in Report Designer are available only in the languages supported by SQL Server 2005.

Report Builder supports the same languages as the Reporting Services Add-in. If you want to create a report that contains titles and labels in a language that is not supported by SQL Server 2005 and Report Designer, you can use Report Builder instead. For example, if you are using the Czech language version of a SharePoint product or technology and you want to create a report that uses Czech titles and labels, start Report Builder from a SharePoint site and create your report.

When you download the Reporting Services Add-in, you must choose a language. The Report Viewer Web Part (ReportViewer.dwp) will be available only in the language that you choose. The application pages and messages will be available in all supported languages, regardless of the language you select on the Download page.

LCID Language Name Culture Name Supported in SQL Server 2005

1028

Chinese (Traditional)

zh-tw

Yes

1029

Czech

cs-cz

No

1030

Danish

da-dk

No

1031

German

de-de

Yes

1032

Greek

el-gr

No

1033

English

En-us

Yes (default language)

1035

Finnish

fi-fi

No

1036

French

fr-fr

Yes

1038

Hungarian

hu-hu

No

1040

Italian

it-it

Yes

1041

Japanese

ja-jp

Yes

1042

Korean

ko-kr

Yes

1043

Dutch

nl-nl

No

1044

Norwegian (Bokmal)

nb-no

No

1045

Polish

pl-pl

No

1046

Portuguese (Brazil)

pt-br

No

1049

Russian

ru-ru

Yes (in SP2)

1053

Swedish

sv-se

No

1055

Turkish

tr-tr

No

2052

Chinese (Simplified)

zh-cn

Yes

2070

Portuguese (European)

pt-pt

No

3082

Spanish

es-es

Yes

See Also

Tasks

How to: Install the Reporting Services Add-in
How to: Uninstall the Reporting Services Add-in
How to: Install a SharePoint Web Front-End on a Report Server Computer

Other Resources

Deployment Modes for Reporting Services
Requirements for Running Reporting Services in SharePoint Integrated Mode
Configuring Reporting Services for SharePoint 3.0 Integration
Security Overview for Reporting Services in SharePoint Integration Mode
Managing Permissions and Security for Report Server Items on a SharePoint Site

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

15 September 2007

New content:
  • Supported Languages