Problem solving with SQL2008R2: or who put the Anal in R2 best
practice analyser?
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)
https://www.microsoft.com/downloads/details.aspx?FamilyId=f2fa1227-9a34-4e29-aa03-62f5c00e16f2&displaylang=en
You may be prompted for an update on Vista:
The Windows Management Framework BITS package provides updated
management functionality for IT Professionals.
https://www.microsoft.com/downloads/details.aspx?FamilyID=d7ae9660-bb13-4f0c-816b-85de3980ec1b&displaylang=en&Hash=bT%2bM0D5bmCtAsBdCdyuVotjBveBjfO%2bEw%2fy3nnAnr53M3oDmlTDZocV1wxhHc5eqLjQ%2bzaHNaq5WTk9AtetwdA%3d%3d
You can then install Microsoft Baseline Configuration Analyzer
2.0
https://www.microsoft.com/downloads/details.aspx?FamilyID=1B6E9026-F505-403E-84C3-A5DEA704EC67&displaylang=en
Which then allows you to install (sorry download because there is
a known issue here) the R2 best practice analyser
https://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591
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:
https://blogs.msdn.com/b/psssql/archive/2010/06/21/known-issues-installing-sql-2008-r2-bpa-relating-to-remoting.aspx
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