Install SQL client components for Endpoint Protection Manager

Products

• Endpoint Protection

Issue/Introduction

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)

Environment

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.

Resolution

For SQL Server 2016 (RTM, SP1,SP2), SQL Server 2017, SQL Server 2019

1. On the SEPM create a folder called SQL Client tools. i.e. c:\SQL Client tools
2. Open Web browser and go to the following URLs and select your language and click download the required components listed below

• ODBC Driver 17.x for SQL server -Windows, Linux, & macOS: https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15#version-17** 
  • <Language>\X64\msodbcsql.msi -- ODBC Driver for SQL Server
• Microsoft command line utilities 15.0.x for SQL server (x64): https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver15
  • <Language>\X64\MsSQLCmdLnUtils.msi

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

Additional information:

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 17.10.5.1 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