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.
Database type | Perform these steps |
---|---|
Microsoft SQL Server Express database (as of 14.3 RU1) |
|
Embedded Sybase database (14.3 MP1 and earlier) |
|
Remote Microsoft SQL Server database |
|
To verify communication with the Microsoft SQL Server Express database:
- On theStartmenu, expandMicrosoft SQL Server 2017and clickSQL Server 2017 Configuration Manager.
- In theSQL Server Configuration Managerdialog box, expandSQL Server Network Configuration, and select theProtocols for SQLEXPRESSinstance.TheTCP/IPfield should be set toEnabled.
- Right-clickTCP/IP, and then clickProperties.
- On the IP Addresses tab, scroll down to theIPAllcategory; theTCP Portfield displays the port number, 2638 by default.
To verify communication with the embedded database:
- On the management server computer, clickStart > Control Panel > Administrative Tools.
- In theAdministrative Tools dialog box, double-clickData Sources (ODBC).
- In theODBC Data Source Administratordialog box, clickSystem DSN.
- On theSystem DSNtab, double-clickSymantecEndpointSecurityDSN.
- On theODBCtab, verify that the Data source name drop-down list isSymantecEndpointSecurityDSNand type an optional description.
- ClickLogin.
- On theLogintab, in theUser IDtext box, typedba.
- In thePasswordtext box, type the password for the database.This password is the one that you entered for the database when you installed the management server.
- ClickDatabase.
- On theDatabasetab, in theServer nametext box, type:\\servername\instancenameIf you use the English version ofSymantec Endpoint Protection Manager, type the default,sem5. Otherwise, leave the Server name text box blank.
- On theODBCtab, clickTest Connectionand verify that it succeeds.
- ClickOK.
- ClickOK.
To verify communication to the Microsoft SQL Server database:
- On the management server computer, clickStart > Control Panel > Administrative Tools.
- In theAdministrative Toolsdialog box, double-clickData Sources (ODBC).
- In theODBC Data Source Administratordialog box, clickSystem DSN.
- On theSystem DSNtab, double-clickSymantecEndpointSecurityDSN.
- In theServerdrop-down list, verify that the correct server and instance is selected.
- ClickNext.
- For Login ID, typesa.
- In thePasswordtext box, type the password for the database.This password is the one that you entered for the database when you installed the management server.
- ClickNextand make sure thatsem5is selected for the default database.
- ClickNext.
- ClickFinish.
- ClickTest Data Sourceand look for the result that states:TESTS COMPLETED SUCCESSFULLY!