-
Notifications
You must be signed in to change notification settings - Fork 10
Install Baseline Configuration Analyzer
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/ |
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:
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.
-
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 |
---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP