To verify communication with the embedded database

1. On the management server, 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. 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 SQL database

1. On the management server, 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!