Problem solving with SQL2008R2: or who put the Anal in R2 best
There is a new kid on the block and it's called SQL 2008 R2 Best practices analyser. Even by Microsoft standards the install is somewhat fraught. Do they ever test these installs? However the end result should be automatic testing of your installs for best practice - and that has to be good.
The steps are: download and install Power shell 2.0 ( its now called Windows Management Framework Core)
You may be prompted for an update on Vista:
The Windows Management Framework BITS package provides updated management functionality for IT Professionals.
You can then install Microsoft Baseline Configuration Analyzer 2.0
Which then allows you to install (sorry download because there is a known issue here) the R2 best practice analyser
You will almost certainly hit a "there is a problem with this windows installer..."
The work round is to run the installer from the command line as described here:
You will then find the shortcut in startmenu / programs
If like me you are running this on a local (fully service packed) vista machine to test against a Local instance of 2008 R2 Express, then you will probably get the following message:
Ok, so I right mouse click and "run as" administrator.
Still no luck.
So I fire up power shell (right click - run as adminsitrator) and paste an run the scripts in 2 and 3
2. Helpfully tells me all is enabled