Hello -
I recently received a new laptop at work, and, for security purposes, the laptop and my credentials are in a different AD tree than my SQL Server. My laptop is under USDA.net, and the SQL Server is in the tree for the University where our offices are located.
I've set up a Windows credential that seems to work, as I can connect my laptop to the SQL Server using SSMS, and I successfully set up a DataSource in ODBC using the 'ODBC Driver 18 for SQL Server'. I just have to make sure that the 'Trust Server Certificate' box is checked.
However, when I place & test an TFDConnection to my SQL Server in Delphi, I'm receiving the message:
The system cannot contact a domain controller to service the authentication request. Please try again later.
To mimic the 'Trust Server Certificate' setting, I've added TrustServerCertificate=yes to the ODBCAdvanced setting in the FireDAC Connection Editor. [I get a '...certificate chain not trusted...' error when I omit that].
The connection seems to work for everything except FireDAC, and I'm at a loss as to what to do next. Any ideas?