Skip to content

Install Access Based Enumeration

EdVassie edited this page Dec 23, 2020 · 3 revisions
Previous Install SSDT Manual Install Install Extended Events Manager Next

FineBuild can install and configure Windows Access Based Enumeration (ABE) as part of the SQL Server install process. If you do not want to include Access Based Enumeration in your FineBuild install, then do not download it.

Access Based Enumeration is written by Microsoft. It was chosen to be included in FineBuild because it prevents users who do not have access to the server from discovering information about shares and other details for the server. Access-based enumeration should be activated for all SQL Server machines.

Access-based enumeration was introduced as an optional component in Windows Server 2003 SP1 and can also be installed on Windows 2008. It is a standard part of Windows 2008 R2 and above, but it still needs to be configured.

Item Link
Access Based Enumeration home page https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/dd772681(v=ws.10)
Access Based Enumeration download https://web.archive.org/web/20100108150724/http://www.microsoft.com/downloads/details.aspx?FamilyID=04a563d9-78d9-4342-a485-b030ac442084&displaylang=en
The x86 download must be named: ABEUIx86.msi. The x64 download must be named: ABEUIx64.msi
Access Based Enumeration tutorial http://techgenix.com/implementing-access-based-enumeration-windows-server-2003/

Security Compliance

Access Based Enumeration helps to reduce the surface area of the host server. If you setup Security Compliance then Access Based Enumeration will always be implemented.

FineBuild Access Based Enumeration Install

Automated silent installation of Access Based Enumeration is performed by Process Id 4TA and is controlled by the parameters below:

SQL Version Parameter FULL Build WORKSTATION Build CLIENT Build
SQL2019 /SetupABE: Yes Yes Yes
SQL2017 /SetupABE: Yes Yes Yes
SQL2016 /SetupABE: Yes Yes Yes
SQL2014 /SetupABE: Yes Yes Yes
SQL2012 /SetupABE: Yes Yes Yes
SQL2008R2 /SetupABE: Yes Yes Yes
SQL2008 /SetupABE: Yes Yes Yes
SQL2005 /SetupABE: Yes Yes Yes

In order to maintain compatibility with older versions of SQL FineBuild, the parameter /InstABE: can also be used.

FineBuild also uses the following parameters to help install Access Based Enumeration:

Parameter Platform Default Value Description
/ABEX86msi: 32-bit ABEUIx86.msi Name of Access Based Enumeration install file
/ABEX64msi: 64-bit ABEUIx64.msi Name of Access Based Enumeration install file

Access Based Enumeration cannot be installed on a Windows Core operating system.

The FineBuild install for Access Based Enumeration includes the following:

Top


Manual Access Based Enumeration Install

The following steps show what you would have to do to install Access Based Enumeration manually. FineBuild does all of this work for you automatically.

Install Access Based Enumeration

  1. Navigate to the Additional Components folder and double-click on the relevant file:

    OS File
    32-bit systems ABEUIx86.msi
    64-bit systems ABEUIx64.msi

    Explorer

  2. The Welcome screen is displayed

    Click Next to continue

    Welcome

  3. Accept the license agreement

    Click Next to continue

    License

  4. Use the default installation folder

    Select the option to install for Everyone, then click Next to continue

    Location

  5. Select the option to Enable Access-based enumeration on all existing folders

    Click Next to continue

    Enumeration

  6. Confirm the installation parameters

    Click Next to continue

    Ready

  7. The installation is complete

    Click Close to exit

    Complete

Configure ABE

This section describes how to configure Access-Based Enumeration to protect files and folders on the server from discovery by unauthorized users.

  1. To configure Access-based enumeration, click on CmdHere.bat

    Type the following command and press Enter

    ABECMD /enable /all
    

    Enable

  2. The following message should be displayed:

    Confirm

Copyright FineBuild Team © 2011 - 2020. License and Acknowledgements

Previous Install SSDT Top Install Extended Events Manager 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
Clone this wiki locally