Thursday, April 05, 2007
Various Ways to Determine if Reporting Services Is Using SP2
How to Find Out the Build Number for SQL Server Reporting Services
How do you find out if Reporting Services has Service Pack 2 installed? It's actually not easy!
You can look certainly at the SQL Server 2005 instance and determine whether it has SPx installed rather easily in the SQL Server Management Studio. One way is to connect to the SQL instance in the Object Explorer. The Object Explorer will show you the build number (such as 9.00.3042, .3043, .3050, .3152, etc. You can also easily see the build number of Integration Services in SSMS by connecting the Object Explorer to your Integration Services instance in the same way. But what about Reporting Services? It does *not* show you the build information...
There are lots of reason we need to know this information. You do know (or should know) that you can install SQL Server 2005 SP1/Sp2 without installing the service pack for Reporting Services, right? You could also have installed Reporting Services after installing SQL Server 2005 with a Service Pack and now you need to apply the SP to SSRS. So how can we figure out whether or not SSRS is up to SP2 (or SP whatever)?
The most logical and straight-forward way to determine whether your Report Server is using RTM, SP1, SP2, etc, is to look at the file version of ReportingServicesService.exe. On my server, this is installed in C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\ and it may be for you as well. Simply right click on the file and choose "Properties". Click the "Version" tab and look at the "File Version". The various file versions and what they mean are listed below:
* 9.0.3042.0 or later - Service Pack 2
* 9.0.2047.0 - Service Pack 1
* 9.0.1399.0 - RTM
There are other visual indicators as well. If SP2 is installed, you will see a file named "rsreportserversp2update.config" in the root of your \ReportServer\ app. You'll also see a ReportService2006.asmx installed (as opposed to just having ReportService2005.asmx).
If you'll pop on over to your \ReportManager\ app and look in the "bin" directory, you can also view the File Version of the various .dlls. If they are dated February, 2007 or later then your Report Manager is at least on Service Pack 2.
Of course, you can always look in the logs, right? Mine are here: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\. You will also see the file versions listed in the logs:
* Microsoft SQL Server Reporting Services Version 9.00.1399.00
* Microsoft SQL Server Reporting Services Version 9.00.2047.00
* Microsoft SQL Server Reporting Services Version 9.00.3042.00
Do you know of other ways to view the SSRS version/build number that I haven't listed? Please let me know :)
How do you find out if Reporting Services has Service Pack 2 installed? It's actually not easy!
You can look certainly at the SQL Server 2005 instance and determine whether it has SPx installed rather easily in the SQL Server Management Studio. One way is to connect to the SQL instance in the Object Explorer. The Object Explorer will show you the build number (such as 9.00.3042, .3043, .3050, .3152, etc. You can also easily see the build number of Integration Services in SSMS by connecting the Object Explorer to your Integration Services instance in the same way. But what about Reporting Services? It does *not* show you the build information...
There are lots of reason we need to know this information. You do know (or should know) that you can install SQL Server 2005 SP1/Sp2 without installing the service pack for Reporting Services, right? You could also have installed Reporting Services after installing SQL Server 2005 with a Service Pack and now you need to apply the SP to SSRS. So how can we figure out whether or not SSRS is up to SP2 (or SP whatever)?
The most logical and straight-forward way to determine whether your Report Server is using RTM, SP1, SP2, etc, is to look at the file version of ReportingServicesService.exe. On my server, this is installed in C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\ and it may be for you as well. Simply right click on the file and choose "Properties". Click the "Version" tab and look at the "File Version". The various file versions and what they mean are listed below:
* 9.0.3042.0 or later - Service Pack 2
* 9.0.2047.0 - Service Pack 1
* 9.0.1399.0 - RTM
There are other visual indicators as well. If SP2 is installed, you will see a file named "rsreportserversp2update.config" in the root of your \ReportServer\ app. You'll also see a ReportService2006.asmx installed (as opposed to just having ReportService2005.asmx).
If you'll pop on over to your \ReportManager\ app and look in the "bin" directory, you can also view the File Version of the various .dlls. If they are dated February, 2007 or later then your Report Manager is at least on Service Pack 2.
Of course, you can always look in the logs, right? Mine are here: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\. You will also see the file versions listed in the logs:
* Microsoft SQL Server Reporting Services Version 9.00.1399.00
* Microsoft SQL Server Reporting Services Version 9.00.2047.00
* Microsoft SQL Server Reporting Services Version 9.00.3042.00
Do you know of other ways to view the SSRS version/build number that I haven't listed? Please let me know :)
Labels: Reporting Services, SSRS
