Symantec Endpoint Protection: How to change the database password to a non complex password for use with the Management Server Reconfiguration Wizard

Article:TECH103774  |  Created: 2008-01-18  |  Updated: 2010-08-13  |  Article URL http://www.symantec.com/docs/TECH103774
Article Type
Technical Solution


Environment

Issue



How to change the database password to a non complex password for use with the Management Server Reconfiguration Wizard

Symptoms
While running the Management Server Configuration Wizard, you are not able to enter the password.


 


Cause



If special characters are used in the password, the wizard will not allow it to be entered.


Solution



The embedded database password can be changed by using the tool "dbisqlc.exe", provided by Sybase.

This tool is stored in the following default location:

C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32\

To change the embedded database password, follow the steps below:

    1. Click on Start > Run.
    2. Type services.msc
    3. Click Ok.
    4. Verify that the "Symantec Embedded Database Service" is running.
    5. Stop the "Symantec Endpoint Protection Manager Service."
    6. Exit the Services window.
    7. Browse to:
      C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32\
    8. Double-click on dbisqlc.exe to launch the application.
    9. Click the Login tab.
    10. Type DBA as the username and enter the current complex password.
    11. Under choose an ODBC data source select 'Data source name' and select SymantecEndpointSecurityDSN.
    12. Click on the Database tab.
    13. Enter the path to the database in the field labeled "Database file:" The default path is:
      C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db
    14. Click Ok to log into the embedded database.
    15. In the "Command" input box, type:
      GRANT CONNECT TO DBA IDENTIFIED BY "<New Password>"
    16. Click Execute. The password should now be changed.
    17. Exit the application.

After changing the password, it is necessary to run the Management Server Configuration Wizard, then restart the IIS and SEPM services.


References
Title: 'Things to consider when supplying usernames and passwords during the install of the Symantec Endpoint Protection Manager'

Document ID: 2008100219215248


Technical Information
The special characters `!@$^&*()-{}[]\\<;>,? ' are not allowed in the database password.


 



Legacy ID



2008011823355248


Article URL http://www.symantec.com/docs/TECH103774


Terms of use for this information are found in Legal Notices