[Firebird-net-provider] [FB-Tracker] Created: (DNET-941) Windows Trusted Authentication (Win_Sspi) exception on Client PC when Firebird Server is version 3.0.5

[Luciano M. (JIRA) <tr...@fi...>]

Windows Trusted Authentication (Win_Sspi) exception on Client PC when Firebird Server is version 3.0.5
------------------------------------------------------------------------------------------------------

                 Key: DNET-941
                 URL: http://tracker.firebirdsql.org/browse/DNET-941
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 7.5.0.0
         Environment: Windows 10 Pro Version 1909
Firebird 3.0.5
            Reporter: Luciano Mendes
            Assignee: Jiri Cincura
         Attachments: LOGIN_ERROR.png

ACTUAL RESULT:
Windows Trusted Authentication (Win_Sspi) exception on Client PC when Firebird Server is version 3.0.5 (See LOGIN_ERROR.png picture attached):
- 335544382 - Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long

EXPECTED RESULT:
No Windows Trusted Authentication (Win_Sspi) exception should be happen on Client PC when Firebird Server is version 3.0.5

STEPS TO REPRODUCE THE ISSUE:
- Try to connect a Firebird 3.0.5 Database Server from a client PC using Windows Trusted Authentication (Win_Sspi)

IMPORTANT NOTES:
- This issue does NOT happen when Firebird server version is 2.5.9;
- If the .NET application (FirebirdSql.Data.FirebirdClient 7.5.0) is installed on the same PC where Firebird 3.0.5 is installed (Server), the .NET application can authenticate via Windows Trusted Authentication (Win_Sspi) without any issue;
- The issue is only reproducible if the .NET application is installed on a client PC;
- The .NET application authentication via user/password (Srp) works perfectly on both the server PC and the client PC;
- The Windows Trusted Authentication (Win_Sspi) using the native Firebird 3.0.5 (fbclient.dll - FlameRobin) library is working perfectly on both the server PC and the client PC;
- The issue is the same described in the following Firebird FAQ: http://www.firebirdfaq.org/faq320/

ENVIRONMENT SETUP
===firebird.conf===
#SETUP 
AuthClient = Legacy_Auth, Srp, Win_Sspi 
AuthServer = Legacy_Auth, Srp, Win_Sspi 
ServerMode = Super 
UserManager = Legacy_UserManager, Srp 
WireCrypt = Enabled 
#PERFORMANCE 
DefaultDbCachePages = 30K 
FileSystemCacheThreshold = 2M 
LockHashSlots = 30011 
LockMemSize = 15M 
RemoteServicePort = 3050 
TempBlockSize = 2M 
TempCacheLimit = 3000M 
#SECURITY 
DatabaseAccess = None 
SecurityDatabase = $(dir_secDb)/security3.fdb
=============================

Database Page Size: 8192

=== ADO.NET Connection String ===
var fbConnectionStringBuilder = new FbConnectionStringBuilder
            {
                Pooling = true,
                ServerType = FbServerType.Default,
                DataSource = Properties.Settings.Default.Server,
                Database = Properties.Settings.Default.Database,
                Charset = "WIN1252",
                Role = "RDB$ADMIN"
            };
================

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira