Identify Reporting Services Version and Edition

While trying to identify the reporting services edition installed on a server today, I found quite a few ways to identify both the edition and version of reporting services.  And now they are listed below from various news group threads for your reading pleasure.

The version of an installed reporting services service can be found easily at the bottom of the page when you browse to http://servername/reportserver.

servername/ReportServer – /

      Friday, October 13, 2013                      <dir> Horror Reports

Microsoft SQL Server Reporting Services Version 9.00.3054.00 

For the edition, you can check the system registry.  The location of the value is different for each SSRS 2000 and 2005.  For SSRS 2000 the value is located at HKLMSOFTWAREMicrosoftMicrosoft  SQL Server80Reporting ServicesProductCode.  For SSRS 2005 the value is under HKLMSOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.#SetupProductCode.

The SSRS 2000 editions are as follows:

Standard: {B19FEFE7-069D-4FC4-8FDF-19661EAB6CE4}

Enterprise: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}

Developer: {2879CA50-1599-4F4B-B9EC-1110C1094C16}

Evaluation: {7C93251A-BFB4-4EB8-A57C-81B875BB12E4}

I searched high for the SSRS 2005 values, I gave up on searching low for these since I could have installed SSRS 2005 for each edition and obtained the values but I’m not doing that today.  Maybe tomorrow.

Also, you can check by going to Control Panel –> Add/Remove Programs –> Select Microsoft SQL Server Report Services and click on the "Click here 
for support information" link.

Or, for the programmer in every DBA:

ReportingService2005 rs = new ReportingService2005(); 
rs.Credentials = System.Net.CredentialCache.DefaultCredentials; 
rs.ServerInfoHeaderValue = new ServerInfoHeader(); 
rs.ListChildren("/", false); 
Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerVersion); 
Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerEdition); 
Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerVersionNumber);

Hopefully this helps someone find this information with a little less research than I had to go through.  Oh, and I might have time to blog for a change and even if I don’t I plan to make the time.

2 thoughts on “Identify Reporting Services Version and Edition

  1. Thanks for the article. I’m using 2008 R2, and I couldn’t locate the registry entries you mentioned, but I think I may have found the equivalent for 2008 R2. It might be HKLM SOFTWARE Microsoft Microsoft SQL Server MSRS10_50.MSSQLSERVER Setup. The keys are called Edition and Edition Type. I assume MSRS is Microsoft Reporting Services.

    Like

Comments are closed.