How to: Detect Version Information (Reporting Services)

SQL Server Setup

Reporting Services consists of multiple applications, tools, and components. If you install or upgrade components in a single operation, all parts of an installation will be the same version. However, if you run multiple instances side-by-side, configure server components to run on different computers, or publish items to a central server, you might encounter version compatibility errors if you try to use client tools from one version with a report server that is a different version. Such errors are most likely to occur during publish operations or if you try to use the Reporting Services Configuration tool to connect to a report server from a previous release.

This topic can help you identify version or edition information so that you can determine whether to upgrade a component or use a different installation of a client or server instance. For more information about upgrading, see Upgrade (Reporting Services).

Version compatibility errors are unlikely to occur for report server database connections. The report server can automatically upgrade a report server database to which it is connected, thereby eliminating a major cause of the database version mismatch error that sometimes occurred in earlier versions. However, you might encounter an error in a scale-out deployment if you have not upgraded all of the nodes.

Report server version and edition information is most easily viewed in the Report Server Status page of the Reporting Services Configuration tool. However, if you cannot connect to the report server because of version incompatibility errors, you can use the alternate steps provided later in this topic.

Note:
You can retrieve version information programmatically. To retrieve server version information, use ServerInfoHeaderValue. To retrieve the database version, use GetDatabaseVersionDisplayName Method (WMI).

To find version information for Reporting Services Configuration tool

  • Start the Reporting Services Configuration tool. On the Report Server Status page, view the Product Version value and compare it to the Version Information table below in this topic.

To find version and edition information for a report server instance

  1. Open the Report Server service trace log file in a text editor. The file name is ReportServerService_<timestamp>.log and it is located in the \Reporting Services\ReportServer\logfiles folder.

  2. Report Server version information is in <Product> at the top of the file.

  3. Edition information for the report server can be found in the INFO statements further down in the file:

    • Reporting Services starting SKU shows the edition of the report server instance.

An alternative approach for viewing report server version information is to type the report server URL in the Address bar of a browser window. Version information can be found at the bottom of the page in this format: <release >:<buildnumber>. If the release is 10, you are connected to a SQL Server 2008 report server instance.

To find edition information for a database instance that hosts report server databases

  1. Open the Report Server service trace log file in a text editor. The file name is ReportServerService_<timestamp>.log and it is located in the \Reporting Services\ReportServer\logfiles folder.

  2. Edition information for the database server that hosts report server database can be found in the INFO statements further down in the file:

    • Catalog SQL Server Edition shows the edition of the database server that hosts the report server database.

Version information is not available in log files, tools, or through the programmatic interfaces. Use the table at the end of this topic to obtain version information for the report server database.

To find version for Report Designer and Model Designer

  1. Start Business Intelligence Development Studio, click Help, and then click About Visual Studio.

  2. In the list of installed products, click Reporting Services. The version information appears in the product details section of the dialog box.

To find version for Report Manager or Report Builder

  • In SQL Server 2008, Report Manager runs in the Report Server service. If you know the version of the Report Serve service, you also know the version of Report Manager. However, if you point a Report Manager instance to a different Report Service instance, it is possible that the version of Report Manager and the report server could be out of sync. To verify the version of Report Manager, right-click a Web page in Report Manager and use the View Source command to view the HTML. The version information is embedded in the underlying HTML.

  • To find version information for Report Builder, start Report Builder and click About Report Builder on the Help menu.

Version Information

The following table provides a list of the version numbers for the report server and report server database released to date:

Release Report server Report server database

SQL Server 2008

10.n.nnnn.nn

n/a

SQL Server 2005 Reporting Services Service Pack 2 (SP2)

9.0.3042.00

C.0.8.45

SQL Server 2005 Express Edition with Advanced Services

9.0.3042.00

C.0.8.45

SQL Server 2005 Reporting Services Service Pack 1 (SP1)

9.0.2049.00

C.0.8.43

SQL Server 2005 Reporting Services

9.0.1399.01

C.0.8.40

SQL Server 2000 Reporting Services Service Pack 2 (SP2)

8.00.1038

C.0.6.54

SQL Server 2000 Reporting Services Service Pack 1 (SP1)

8.00.0878

C.0.6.51

SQL Server 2000 Reporting Services

8.00.0743

C.0.6.43

See Also

Concepts

Upgrading a Report Server Database

Other Resources

Tutorial: How to Locate and Start Reporting Services Tools
Upgrade (Reporting Services)
Reporting Services Components and Tools