The Symantec Endpoint Protection Manager (SEPM) requires the following Microsoft SQL components:
• Microsoft ODBC Driver for SQL Server
• Microsoft Command line utilities for SQL Server (bcp.exe & SQLCMD)
SEPM that connects to Remote SQL database.
NOTE: This KB article doesn't apply to SEPM with Express SQL (Embedded DB), since the SEPM installer takes care of installing all needed components for SEPM to connect to its DB.
Once all the files have been downloaded, open Windows Explorer and navigate to the folder you created in step 1. i.e. c:\SQL Client tools
Double Click msodbcsql.msi -- ODBC Driver for SQL Server to install the ODBC drivers. When the install finishes, double click MsSQLCmdLnUtils.msi to install Microsoft Command line utilities for SQL Server
Once these have been installed, you can now install the Symantec Endpoint Protection Manager
Starting with SQL server 2014 Bcp.exe is now located in C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\<version>\Tools\Binn. When installing the SEPM you may receive the error "SQL Server Client tools must be installed on your server". If you run into this message, click OK and then click browse and browse to the location of Bcp.exe.
**Please note that at the time of writing this is version 184.108.40.206 which covers CVE-2023-29356.
ODBC driver 18.x is NOT supported by Microsoft with SQL command line 15.x - https://github.com/MicrosoftDocs/sql-docs/issues/9188
As of this writing Microsoft only supports ODBC 17.x with the 15.x SQL command line tools