If you install Symantec Endpoint Protection Manager with a SQL Server database, there are specific configuration requirements for SQL Server.
Before you create the database, Symantec recommends that you install a new instance of SQL Server that conforms to Symantec installation and configuration requirements. You can install a database in an existing instance, but the instance must be configured properly or your database installation fails. For example, if you select a case-sensitive SQL collation, your installation fails.
To maximize the security posture of remote SQL Server communications, place both servers in the same secure subnet.
Table: Required SQL Server configuration settings
If your database is located on a remote server, you must also install SQL Server client components on the computer that runs Symantec Endpoint Protection Manager. SQL Server client components include
BCP.EXE. The version number of the SQL Server client components should be the same as the version number of SQL Server that you use. Refer to your SQL Server documentation for installation instructions.
During the Symantec Endpoint Protection Manager database configuration phase of the installation, you select and enter various database values. Understand the decisions you must make to correctly configure the database.
Table: SQL Server database settings displays the settings that you might need to know before you begin the installation process.
Table: SQL Server database settings