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!