HomeSupport KBAdvanced (Technical)How can I set the Firebird SYSDBA password?

1.7. How can I set the Firebird SYSDBA password?

How to change the Firebird SYSDBA password:

-Note: the file paths listed below may differ for your installation. Confirm the location of the Firebird installation on your server before beginning.

  1. Close the software if it is open (ensure no one is connected to the database)
  2. Log into server which is running the Firebird database
  3. Backup the C:\Program Files\Firebird\security2.fdb file (it contains the original login information)
  4. Open command prompt
  5. Type CD \
  6. [Press Enter]
  7. Type CD "Program Files"
  8. Press Enter
  9. Type CD Firebird
  10. [Press Enter]
  11. Type CD bin
  12. [Press Enter]
  13. Type gsec -user SYSDBA -password masterkey -modify sysdba -pw newpassword
    (Where "newpassword" is the new password you want to set)
    (Note: only the first 8 characters of the password are used)
  14. [Press Enter]

Then set the password to connect from the client:

  1. Open the software - it may take longer to open as it attempts to connect.
  2. A message will appear indicating that it cannot connect - click Ok.
  3. Select the Advanced tab on the database connection form and type the new password in the password box.
  4. Test the connection and save the changes.
  5. Repeat the steps 1-4 to set the new password on each client which connects to the remote database.

Knowledge Tags

This page was: Helpful | Not Helpful