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:
Alias |
An user-defined alias name for the server - this is only used inside Database Workbench. |
Folder |
An Enterprise Manager folder for grouping your server registrations. |
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 or servername/remoteservicename (if you configured a service name, you have to use that instead of the port). Example: MYSERVER/3055 or MYSERVER/FB15 |
Protocol |
The network protocol to use when connecting to the server and databases on the server. |
Client library |
Database Workbench will use the first "fbclient.dll" that it can find (in the Windows path), if it cannot find it, it will try to use "gds32.dll". If you have multiple versions of Firebird, you may be required to select the correct client library here. |
Username |
The default username used for connecting to database, this can be overridden when you register a database. |
Password |
The password for the username given. |
SYSDBA Password |
The SYSDBA password, needed for server-related tasks like adding new users. |
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.
Authentication method
Firebird 2.1 and up optionally supports "Windows Authentication", it can accept connections based on your Windows username and password. If you select this authentication method, all username and password information in this dialog will be ignored.
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. It is recommended to develop with a full server and deploy with "Firebird Embedded".