1. Stop the SEPM and Symantec Embedded database service.
2. Copy the db, Server Private Key folder, server.xml and keystore.jks
Default locations:
c:\Program Files\Symantec\Symantec Endpoint Protection Manager\db
c:\Program Files\Symantec\Symantec Endpoint Protection Manager\Server Private Key
c:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\conf\server.xml
c:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\keystore.jks
3. Start the SEPM and Symantec Embedded database service.
4. Perform the Data sources ODBC test
Reason : dba password is required to restore the database
Steps:
If the Database is on-line, run appropriate ODBC test for your SEPM and 32/64-bit Operating System:
Verify communication to the embedded (Sybase) database.
Verify that the "Symantec Embedded Database" service is running and that the "dbsrv9.exe" process is listening on TCP port 2638.
Test the ODBC connection.
Click Start> Control Panel
Open Administrator Tools
Double-click Data Sources (ODBC)
Select the System DSN tab
Double-click the SymantecEndpointSecurityDSN and go through the wizard to ensure the following settings:
Name: SymantecEndpointSecurityDSN
Description: <Anything>
Server: Servername\InstanceName (Can be blank as it is localized, otherwise specify default "sem5")
Login ID: dba
Password: <password>
Note: If the "Encrypt password" box on the Login tab is not checked, your password will be stored as plain text in the Windows registry.
Leave the default settings for the remaining items and click Finish
Click Test Data Source, and verify that it states "Success"
Click OK
Verify communication to the Remote (SQL) Database.
Verify that you have specified a named instance during installation and configuration. Example: \\<server name>\<instance name>
Verify SQL Server is running and properly configured.
Verify the network connections between Symantec Endpoint Protection Manager and the SQL database.
Test the ODBC connection.
Click Start> Control Panel
Open Administrator Tools
Double-click Data Sources (ODBC)
Select the System DSN tab
Double-click SymantecEndpointSecurityDSN and go through the wizard to ensure the following settings:
Name: SymantecEndpointSecurityDSN
Description: <Anything>
Server: Servername\InstanceName (Only enter the server name or IP address if using the default instance)
Login ID: sa
Password: <password>
Leave the defaults for the rest of the items and click Finish
Click Test Data Source on the next page and ensure it states "Success"
Click OK
For 64bit ODBC communication follow the link below.
http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008021900094548