Subject New Firebird 3.0.4 install can't attach, sysdba & password rejected?
Author Chris LeFebvre

I’ve been developing a Firebird database and application in Delphi for many years; I’m currently using Firebird 3.0.3.32900 on my development server. I’m trying to get it to work on a Windows 10 tablet (to test how well it would work) and I’ve installed firebird  server and the program and put the database on the tablet. My problem is that I can’t attach to the server either with database workbench 5.4.4 or my program which uses the latest FireDAC found in Rad Studio 10.2 update 3.

 

When I attempt to connect to the server I get the message “Username and password are not defined”, when I installed the server I did select the option to allow legacy authentication since I’m not sure that FireDac currently supports the newer authentication that is available in Firebird 3. On the tablet I was able to connect to the database using isql: “isql C:\Firebird\<database>.gdb –u sysdba –p <My password>” so I’m kind of stumped as to why neither my application nor Database Workbench can attach to the database using the correct username and password when legacy authentication has been enabled (I did check the firebird.conf to confirm that).

 

Any idea’s what the problem is? Some kind of client library issue?