Registering a Firebird Server

Previous  Top  Next

In order to register an Firebird server, you need to fill out the dialog below, reached via the Enterprise Manager and the Register Server button.

 

Register an Firebird Server

 

Database Workbench needs the following information:

Host

Hostname or IP address of the machine where the Firebird server process is running - if you run your Firebird server at a different port, use the following syntax: servername/port

Example: MEDIA/3055

Alias

An user-defined alias name for the hostname - this is only used inside Database Workbench.

Protocol

The network protocol to use when connecting to the server and databases on the server.

Username

The default username for databases.

Password

The password for the username given.

Architecture

The architecture of the Firebird server you're trying to connect to - this is helpful for anything related to the Firebird Services API (Classic doesn't support this).

SYSDBA Password

The SYSDBA password, needed for server-related tasks like adding new users.

Security Database

The complete path of the "ISC4.GDB" or "SECURITY.FDB" database on the server. Note that for the SuperServer architecture, this parameter isn't required.

 

If you click OK, Database Workbench will test the connection - if this succeeds, the server will be registered and added to the Servers node in the Enterprise Manager.

 

To list databases on an Firebird server, you need to Register them. When you register a new server, Database Workbench will ask you if you want to register a database immediately - if you answer Yes, you will be shown the Register Database Wizard.

 

Note:

When registering a "Firebird Embedded" server, Database Workbench will respond with an error saying it cannot connect to the server, asking you to "Register Anyway?" - select "Yes". Next, register databases as you would normally do.