Connecting and configuring Firebird 4 on Windows Server 2016 DC using DBeaver
- For the connection to the server, you should know the IP address of the VM. You can find it in the personal account of Azure. (You need to select the virtual machine from the list. By clicking the item “Overview”, your IP is displayed in the line “Public IP Address”).
- To work, you must open TCP port 3050 in the network properties in the Azure firewall.
- To connect to the virtual machine, run the “Remote Desktop Connection” shortcut “Win + R”. In the window that appears, enter “mstsc” and click “OK”.
- In the window that appears, enter the virtual machine’s IP and click “Connect”.
- In the window that appears, enter your username and password and click “OK”.
- Check the box and click “Yes”.
- Open and save the password from the password file on the VM desktop
- Go to the page for downloading DBeaver – Download
- Download the software distribution convenient for you, Windows 64 bit installer for example.
- Run the downloaded file and finish the installation process
- Start the DBeaver
- Click on the button to establish the new connection
- In the list that appeared, find and select “Firebird”, then click the “Next” button
- Enter your VM IP in the Host field (1). In the Path field (2) specify the path to the database located on the VM. For example: C:\Program Files\Firebird\Firebird_4_0\examples\empbuild\employee.fdb
Leave the Username field with sysdba, set the password (3) from step 7 and click Finish (4). It is strongly recommended to change the password, after connecting to the database.
- While connecting, the window with the driver files installation may appear. Click “Download”, then the connection to the database will be continued.
- Your Firebird is ready