Install Baseline Configuration Analyzer - SQL-FineBuild/Common GitHub Wiki
| Previous Install KB2549864 | Manual Install | Install Report Viewer Next |
|---|
FineBuild can install and configure the Microsoft Baseline Configuration Analyzer (MBCA) as part of the SQL Server install process. If you do not want to include Baseline Configuration Analyzer in your FineBuild install, then do not download it.
Baseline Configuration Analyzer is written by Microsoft. It was chosen to be included in FineBuild because it is required by the SQL Server Best Practice Analyzer.
Support for Baseline Configuration Analyzer has ended, and it should not be installed for SQL2014 and above.
| Item | Location |
|---|---|
| Baseline Configuration Analyzer home page | There is no home page for the Baseline Configuration Analyzer |
| Baseline Configuration Analyzer download (X64) | https://download.microsoft.com/download/A/6/E/A6E303A4-D4BA-4423-BAB1-495582C67F64/MBCA_Setup64_Win8.msi |
| Baseline Configuration Analyzer download (X86) | https://download.microsoft.com/download/A/6/E/A6E303A4-D4BA-4423-BAB1-495582C67F64/MBCA_Setup32_Win8.msi |
| Baseline Configuration Analyzer Tutorial | https://www.enhansoft.com/using-microsoft-baseline-configuration-analyzer-2-0/ |
FineBuild Baseline Configuration Analyzer Install
Automated silent installation of Baseline Configuration Analyzer is performed by Process Id 4AD and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupMBCA: | N/A | N/A | |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2017 | /SetupMBCA: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2016 | /SetupMBCA: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2014 | /SetupMBCA: | N/A | N/A | N/A |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2012 | /SetupMBCA | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008R2 | /SetupMBCA: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008 | /SetupMBCA: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2005 | /SetupMBCA: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes |
FineBuild also uses the following parameters to help install MBCA:
| Parameter | Default Value | Description |
|---|---|---|
| /MBCAX86msi: | MBCA_Setup32.msi | Name of MBCA install file for 32-bit servers |
| /MBCAX64msi: | MBCA_Setup64.msi | Name of MBCA install file for 64-bit servers |
If you Install SQL Best Practice Analyzer, then Baseline Configuration Analyzer will always be installed.
MBCA can also be installed by adding the following parameters at run time:
/SetupMBCA:Yes
/SetupSQLTools:Yes
The FineBuild install for Baseline Configuration Analyzer includes the following:
Manual Baseline Configuration Analyzer Install
The following steps show what you would have to do to install Baseline Configuration Analyzer manually. FineBuild does all of this work for you automatically.
Install Baseline Configuration Analyzer
-
Navigate to the Additional Components folder and double-click on the following:
Platform Module X86 System MBCA_Setup32.msi X64 System MBCA_Setup64.msi 
-
The Welcome screen is displayed
Click Next to continue
-
Accept the License Agreement
Click Next to continue
-
Accept the defaults for install location
Click Next to continue
-
Setup is ready to begin installation
Click Install to continue
-
Wait while the MBCA install is running
-
Setup has installed the Baseline Configuration Analyzer successfully
Click Finish to end
Copyright FineBuild Team © 2012 - 2021. License and Acknowledgements
| Previous Install KB2549864 | Top | Install Report Viewer Next |
|---|