Thursday, December 31, 2009

How to determine what version of SQL 2008 (RTM or SP1) and features have been installed?

As we all know OpsMgr R2 (and with KB971541 installed on OpsMgr SP1), SQL 2008 with SP1 is supported.
image

But how to determine the version and installed features of the installed SQL 2008 instance(s)?  From many people I do get this question. So why not write a blog posting about it?

Let’s start.

With SQL 2008 life has been made very easy. With a few steps one can not only see the version of SQL 2008 but also the instances, features, language, editions and whether or not it is clustered!

  1. Go to Start > All Programs > Microsoft SQL Server > Configuration Tools > SQL Server Installation Center (64-bit)
    image  

  2. Go to Tools > Installed SQL Server features discovery report
    image

  3. A report in html-format is generated and automatically opened in IE:
    image

  4. With KB article KB321185 one can see whether SQL 2008 is on SP1 level:
    image

No comments: