Submitted by: vinogradniy (vinogradniy)

Duplicates DNET615

To configure a database to map the RDB$ADMIN role to administrators automatically on a Windows server that is configured to enable trusted user authentication, the SYSDBA logs in to any database.

Windows trusted user authentication is no longer available by default!
By default, the Authentication parameter in firebird.confis configured as native. It must be explicitly configured to either trusted or mixed to enable trusted user authentication.

See: http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-prvlgs

Expression not supported in FbBatchExecution : "ALTER ROLE RDB$ADMIN SET AUTO ADMIN MAPPING".

FirebirdSql.Data.FirebirdClient.dll version 2.6.0.0.

Stack trace fragment:
{{{

The type
of the SQL statement could not be determinated.
System.Exception: The type of the SQL statement could not be determinated.
at FirebirdSql.Data.Isql.FbBatchExecution.GetStatementType(String sqlStatement) in C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\Isql\FbBatchExec
ution.cs:line 800
at FirebirdSql.Data.Isql.FbBatchExecution.Execute(Boolean autoCommit) in C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\Isql\FbBatchExecution.cs:line 178

}}}

Best regards,
Eugeniy Vinogradniy.