your user name and password are not defined. ask your database administrator to setup a firebird login

[James Folly]

Hi

I have an application made in vb.net with firebird 3.0.1 engine runs in windows 10. When i want to run same application on another pc first i install firebird 3.0.1 and receive following error with username sysdba password masterkey

your user name and password are not defined. ask your database administrator to setup a firebird login

Why do I receive that error when trying to open the database programmatically when I can open the same database with the same credentials in FlameRobin?

would you please guide me how to resolve this issue.

Thanks & regard

James

[Mark Rotteveel]

On 04-07-2021 12:14, James Folly wrote:
> I have an application made in vb.net with firebird 3.0.1 engine runs in
> windows 10. When i want to run same application on another pc first i
> install firebird 3.0.1 and receive following error with username sysdba
> password masterkey

> *
> *
> *your user name and password are not defined. ask your database
> administrator to setup a firebird login*

>
> Why do I receive that error when trying to open the database
> programmatically when I can open the same database with the same
> credentials in FlameRobin?
>
> would you please guide me how to resolve this issue.

Recent versions of FirebirdSql.Data.FirebirdClient only support the Srp
authentication protocol when connecting to Firebird 3.0 and higher. This
means you need two things:
1. Your Firebird server must have Srp listed in the AuthServer property
in firebird.conf
2. Your user must be created using the Srp user manager.

Likely you never created SYSDBA with the Srp user manager (or if you
created one, it has a different password than masterkey).

In FlameRobin, use:
CREATE USER SYSDBA PASSWORD 'masterkey' USING PLUGIN SRP

As an aside, you should really not be using Firebird 3.0.1. The current
latest release is Firebird 3.0.7.

Mark
--
Mark Rotteveel

[Dimitry Sibiryakov]

04.07.2021 12:14, James Folly wrote:
> Why do I receive that error when trying to open the database programmatically when I can
> open the same database with the same credentials in FlameRobin?

Option 1: Different server.
Option 2: Different auth plugin.
Option 3: Mistype in credentials.

--
WBR, SD.

[James Folly]

Hi Mark

You are right password is different than masterkey and we don't know what was the exact password.

can we change password?

[Mark Rotteveel]

On 04-07-2021 12:38, James Folly wrote:
> Hi Mark
> You are right password is different than masterkey and we don't know
> what was the exact password.
> can we change password?

Yes, you can use ALTER USER, see
https://www.firebirdsql.org/file/documentation/html/en/refdocs/fblangref30/firebird-30-language-reference.html#fblangref30-security-user-alter

Mark
--
Mark Rotteveel