How to update configuration for Symantec Endpoint Protection Manager 14.X to use a different port for embedded database

Products

• Endpoint Protection

Issue/Introduction

When installing the Symantec Endpoint Protection Manager (SEPM) 14.X (14.0 - 14.3 MP1) with the embedded database, there is another program that already uses port 2638 which requires SEPM and OS configuration to be updated to enable communications. 

Environment

Symantec Endpoint Protection Manager 14.0 - 14.3 MP1 with included embedded database

Resolution

The Symantec Endpoint Protection Manager(SEPM) can use a custom port for the embedded database by using the following steps.

1. From the Services Panel (Start->Run..->services.msc) stop the Symantec Endpoint Protection Manager, Symantec Endpoint Protection Manager Webserver, and Symantec Embedded Database services.
2. Open the registry. (Start->Run..->regedit)
3. Browse to HKEY_LOCAL_MACHINE\system\currentcontrolset\services\SQLANYs_sem5\parameters
4. Double-click on Parameters DWORD Value and change the 2638 value at the end of the string to a port you have determined to be free (such as 2639)
5. Open C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\conf\Catalina\localhost\ROOT.xml (default location) with Notepad.
6. Find "port=2638" and change it to the new port you will be using
7. Open C:\Program Files\Symantec\Symantec Endpoint Protection Manager\bin\ODBCUTIL.properties (default location) with Notepad.
8. Find "DB_DEFAULT_PORT_EMBEDDED=2638" and change it to the new port you will be using
9. Now start the Symantec Embedded Database from services.msc
10. Go to Start > Administrative Tools > Data Sources(ODBC), Click on the 'System DSN' tab, then double click SymantecEndpointSecurityDSN. On the Network tab, in the TCP/IP field change the port number to the new port. Verify the information is correct on the Login and Database tabs, then on the ODBC tab click 'Test Connection'
    PLEASE NOTE: For 64bit Servers the 'System DSN' tab may be empty, if this is the case browse to C:\Windows\SysWOW64\odbcad32 to launch Data Sources(ODBC). The 'System DSN' tab should now have the correct entry.
11. Now start the Symantec Endpoint Protection Manager Webserver then Symantec Endpoint Protection Manager from Services. (Start->Run..->services.msc)
12. Verify everything is now working by logging into the Symantec Endpoint Protection Manager.