find out which version of SQL 2005 is installed

• eyal sacharov

  Say Hey Kid

  Points: 672

  More actions

  August 21, 2006 at 1:48 am

  #169404

  Hi,

  I've written a software that uses Reporting Services. I've also created a Windows Installer for it - and added a launch condition that checks that indeed Reporting Services is installed on the target machine.

  No problem finding out the version if SQL 2000 RS is used - I search for the registry key with the version number. HOWEVER, SQL 2005 is a tough cookie - i've seen numerous variations as to where this registry key is located in the registry. Moreover, i read some Microsoft guy basically saying: "for SQL Server 2005, don't count on the registry location as we can and will chnage them". So I don't want to base my search on that.

  Any suggestions as to how I can find out if RS is installed as a launch condition (meaning, either a file search or a registry search?

  THANKS!

• barsuk

  SSChampion

  Points: 12280

  More actions

  August 22, 2006 at 4:27 pm

  #656247

  Would it be of any help to you?:

  http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx