In order to use SQL2012BPA in Windows 8.1 we require Microsoft Baseline Analyzer 2.0. However even after installing that and SQL2012BPA we cannot do it. Because module does not show up MBA. Try following steps to get SQL2012BPA working on Windows 8.1.
- Install Microsoft Baseline Analyzer 2.0.
- Install SQL Server 2012 BPA.
- Copy the SQL2012BPA folder from C:\windows\system32\bestpractices\v1.0\Models\ to C:\ProgramData\Microsoft\Microsoft Baseline Configuration Analyzer 2\Models\
- Start Microsoft Baseline Analyzer 2.0.
- Select the SQL2012BPA module.
- Start analysis.