On 26-3-2018 14:29, liviuslivius liviuslivius@...
[firebird-support] wrote:

> I see that i need only to put win_sspi as plugin but it does not work
> either. I have restarted FB server after change. I also have created mapping
>
> CREATE GLOBAL MAPPING TRUSTED_AUTH USING PLUGIN WIN_SSPI FROM ANY USER
> TO USER
>
> On the server i have both Firebird 2.5 and 3 running. FB 2.5 can connect
> by Wndows trusted auth but fb3 cannot.
> It always tell me "your user name and password are not defined.."
> All tests done by isql from fb2.5 or fb3
>
> My firebird.conf settings are:
> Auth_Server = Srp
> AuthClient = Srp, Win_Sspi, Legacy_Auth
> User_Manager = Srp
>
>
> What more should i do to support windows auth?

You need to change the configuration of `AuthServer` (note the spelling,
no underscore(!)) to `AuthServer = Srp, Win_Sspi`.

The `AuthClient` configuration only governs fbclient (for fbclients that
read that specific firebird.conf), and client connections from Firebird
server to another (or the same) server (eg remote EXECUTE STATEMENT).

Mark
--
Mark Rotteveel