Aug 16, 2011
tom

MSSSQL: SSRS, SSAS, SSIS edition

Question

How can I know which edition of SSRS, SSAS and SSIS service is installed on a server?
Finding database edition is easy but how to find edition for other SQL services?

Any help please?

Thanks in advance.

Answer

To find out edition of SSRS, go to:

C:Program FilesMicrosoft SQL Server90Setup BootstrapLog on the server which has SSRS

Open the Summary.txt file.
Look for the log file for Product : Microsoft SQL Server 2005 Reporting Services.

In the SSRS log file, search for keyword “edition”

Related posts:

  1. SSRS 2008 R2 with SQL Server 2008 (non R2) ReportServer databases
  2. Questions about MySQL Community Edition (The free Edition)
  3. Can you upgrade SQL Server 2008 SP2 Standard Edition to 2008 R2 Developer Edition?
  4. When integrating SQL Server Reporting Services with SharePoint, does SharePoint have to be installed on the database server that hosts SSRS?
  5. SQL Server Trial Edition to Full Edition

Leave a comment