Check which SP is installed for RS 2005?

• cpyne

  Mr or Mrs. 500

  Points: 572

  More actions

  February 28, 2007 at 9:51 am

  #194353

  Hi,

  Does anyone know how to confirm what service pack is installed for Reporting Services 2005, (not SQL itself)? We're going through a checklist for evaluating servers and need to verify the patch level of RS as well as SQL. Any ideas?

  Thanks

  Charlie

• JeremyE

  SSCoach

  Points: 16212

  More actions

  March 1, 2007 at 2:33 pm

  #692720

  Check the version of ReportingServicesService.exe. It is located: Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin

  SP1 - 9.0.2153

  SP2 - 9.0.3042

  RTM - 9.0.1399

• tknoobOLD

  Ten Centuries

  Points: 1183

  More actions

  March 1, 2007 at 4:30 pm

  #692734

  Actually, SP1 is 9.0.2047.

  9.0.2153 is SP1 + K918222 Hotfix.