Symantec Endpoint Protection Installation and Administration Guide

Portugues Chinese (Simplified) Czech Deutsch Español Français Italian Japanese Korean Polish Russian Chinese (Traditional) English

Verifying the management server connection with the database

The management server and the database may not communicate properly. You should verify that the database runs and then test the connection between the server and the database.
Verifying the database connection
Database type
Perform these steps
Microsoft SQL Server Express database (as of 14.3 RU1)
  • Verify that the SQL Server Express service runs and that the sqlserver.exe process listens to TCP port 2638.
  • Test the ODBC connection.
Embedded Sybase database (14.3 MP1 and earlier)
  • Verify that the Symantec Embedded Database service runs and that the dbsrv9.exe process listens to TCP port 2638.
  • Test the ODBC connection.
Remote Microsoft SQL Server database
  • Verify that you have specified a named instance when you installed and configured Symantec Endpoint Protection Manager.
  • Verify that SQL Server runs and is properly configured.
  • Verify that the network connection between management server and the SQL database is correct.
  • Test the ODBC connection.
To verify communication with the Microsoft SQL Server Express database
  1. On the
    Start
     menu, expand
    Microsoft SQL Server 2017
     and click
    SQL Server 2017 Configuration Manager
    .
  2. In the
    SQL Server Configuration Manager
     dialog box, expand
    SQL Server Network Configuration
    , and select the
    Protocols for SQLEXPRESS
     instance.
    The
    TCP/IP
     field should be set to
    Enabled
    .
  3. Right-click
    TCP/IP
    , and then click
    Properties
    .
  4. On the IP Addresses tab, scroll down to the
    IPAll
     category; the
    TCP Port
     field displays the port number, 2638 by default.
To verify communication with the embedded database
  1. On the management server computer, click
    Start > Control Panel > Administrative Tools
    .
  2. In the
    Administrative Tool
    s dialog box, double-click
    Data Sources (ODBC)
    .
  3. In the
    ODBC Data Source Administrator
     dialog box, click
    System DSN
    .
  4. On the
    System DSN
     tab, double-click
    SymantecEndpointSecurityDSN
    .
  5. On the
    ODBC
     tab, verify that the Data source name drop-down list is
    SymantecEndpointSecurityDSN
     and type an optional description.
  6. Click
    Login
    .
  7. On the
    Login
     tab, in the
    User ID
     text box, type
    dba
    .
  8. In the
    Password
     text box, type the password for the database.
    This password is the one that you entered for the database when you installed the management server.
  9. Click
    Database
    .
  10. On the
    Database
     tab, in the
    Server name
     text box, type:
    \\
    servername
    \
    instancename
    If you use the English version of
    Symantec Endpoint Protection Manager
    , type the default,
    sem5
    . Otherwise, leave the Server name text box blank.
  11. On the
    ODBC
     tab, click
    Test Connection
     and verify that it succeeds.
  12. Click
    OK
    .
  13. Click
    OK
    .
To verify communication to the Microsoft SQL Server database:
  1. On the management server computer, click
    Start > Control Panel > Administrative Tools
    .
  2. In the
    Administrative Tools
     dialog box, double-click
    Data Sources (ODBC)
    .
  3. In the
    ODBC Data Source Administrator
     dialog box, click
    System DSN
    .
  4. On the
    System DSN
     tab, double-click
    SymantecEndpointSecurityDSN
    .
  5. In the
    Server
     drop-down list, verify that the correct server and instance is selected.
  6. Click
    Next
    .
  7. For Login ID, type
    sa
    .
  8. In the
    Password
     text box, type the password for the database.
    This password is the one that you entered for the database when you installed the management server.
  9. Click
    Next
     and make sure that
    sem5
     is selected for the default database.
  10. Click
    Next
    .
  11. Click
    Finish
    .
  12. Click
    Test Data Source
     and look for the result that states:
    TESTS COMPLETED SUCCESSFULLY!