Error: "Connection Rejected by remote interface" using Firebird 3 in . Net

Question

I have an application in Asp.net, which currently uses Firebird 2.5.1 and works normally. I’m testing the 3.0 Release Candidate for soon migrate the version, but does not open the connection, occurs the following error:

"Connection Rejected by remote interface".

Testing in a Delphi application worked normally, but Visual Studio does not work.

I wonder if it can be the Provider for . net that has not yet been updated to the new version, or if it could be something wrong that I’m making.

Answer 1

Short answer: reinstall the Firebird server by checking the option to enable legacy auth, or change the server configuration (in Firebird.conf), changing the line

#AuthServer = Srp

for

AuthServer = Legacy_Auth, Srp, Win_Sspi

Long answer: ADO Provider para . net (Firebirdsql.Data.Firebirdclient.dll, v4.10.0.0) still does not support the new standard Firebird authentication model (SRP), so the server must be configured to support the legacy authentication model.

Most Delphi applications use fbclient (or gds32.dll) to connect to the server, and as the installation of Firebird 3.0 distributes an fbclient that already implements the new authentication model, applications that use fbclient will not have this problem.

---

If other login errors appear after this solution, that answer covers the whole problem and the complete solution, much better than I did above (I only found the answer after solving :-| )

Answer 2

I managed to solve my:

Connection Rejected by remote interface

Changing the GDS32.DLL in system32 folder, it may be that the file has been corrupted, something of the kind. It is running normally now, I managed to open the seat in IB and my system returned run.

Answer 3

Open the Firebird.conf file and modify the following parameters:

WireCrypt = Disabled
AuthServer = Legacy_Auth, Srp, Win_Sspi
AuthClient = Legacy_Auth, Srp, Win_Sspi

For Windows there are different options there. Just look at the comments of Authserver/Authclient.

Then restart the Firebird or the machine.