Problem solving with SQL2008R2: or who put the Anal in R2 best
practise 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
practise - and that has to be good.
The steps are: download and install Power shell 2.0 ( its now
called Windows Management Framework Core)
http://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.
http://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
http://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 practise analyser
http://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:
http://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 (fuly service packed) vista machine to test agains a Local instance of 2008 R2 Express, then you will probably get the following message:
Ok, so I right mouse click and "run as" adminsitrator.
Still no luck.
So i fire up power shell (rt click - run as adminsitrator) and paste an run the scripts in 2 and 3
2. Helpfully tells me all is enabled