IIS, Windows Server 2022, TLS 1.2

[Kast2k]

Hello!

Unigui 1592.

All settings are set in IISCrypto. All ciphers are enabled, TLS 1.2-1.3 also

 

Project is working on Firedac.

FDPhysMSSQL and FDPhysODBC are placed in MainModule.

 

Connection params:

ODBCAdvanced=Server=localhost;Trusted_Connection=No; Encrypt=yes; TrustServerCertificate=Yes

ODBCVersion=3.8

ODBCDriver=ODBC Driver 17 for SQL Server

RDBMS=MSSQL

DriverID=ODBC

 

Problem:

If application is started as stand-alone then there is no problems with connection to DB.

If i starting it on IIS then very often i receive error "[Firedac][Phys][ODBC][Microsoft][ODBC Driver 17 for SQL Server]Encryption not supported on the client" on FDConnection.Active for every new session created.

 

May be i missed something during server configuration or may be i need to add some components to project?

ODBC Driver version is 17.10.6.1

Thank You.

[Farshad Mohajeri]

Hi,

IIS encryption is not relevant to DB connection between uniGUI app and DB server. IIS encryption is only relevant to browser encryption between browser and the IIS server.

You may need to change pool settings and use LocalSystem as pool identity to resolve this issue.