• Home  |
  • Blog  |
  • 2010  |
  • 9  |
  • 1  |
  • Microsoft Baseline Analyser and other errors

Microsoft Baseline Analyser and other errors

Posted Wednesday Wednesday, September 1, 2010 by Ian Pettman

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:

 

Baseline Analyser

 

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

If you found this information useful, please share it!

0 comments for “Microsoft Baseline Analyser and other errors”

    Comments are closed for this post

Contact Information

To find out more about Ava solutions you can contact us in a number of ways:
Follow Us...