Devart Forums

On tUniconnection.connect I get error "Windows Authentication supported only under Windows" in my app and even on Delphi's IDE when only setting:

provider name=SQL Server
options.provider=prDirect
options.authentication=auWindows
server=to my server

It works fine setting options.provider to prAuto
Tried to trace the cause but td7protocoluni.pas is obfuscated.

Need to make direct connection work!

Hello,

I always use prDirect with Authentication set to auServer which I believe is default for TUniConnection.

What OS are you having problems? Error messages feels like you are using something but Windows as an OS.

Windows 10.
Delphi 7.
I just upgraded to latest latest UniDac 7.
It was running fine with UniDac 5.3.

Please test with auWindows instead of auServer. The error happens only using auWindows, hence the error message.

Confirming that I receive same error message.

-Delphi 10.2 Tokyo target is Win32
-UniDAC 7.0.2 (which includes PostgreSQL login fix)
-SQL Server 2012 Express 64bit
-Windows 10 64bit

if UniConnection.SpecificOptions set to Connection cannot be established and error message indicated by OP is displayed.

There is no problem if provider is set to prNativeClient.

Currently, Windows authentication for SQL Server in the Direct mode is not supported, therefore you get the error message 'Windows Authentication supported only under Windows'. We will consider the possibility of its support in the future.

Hello,

OP indicates that it was running with early versions of UniDAC. Namely version 5.3
Can we say that somewhere between this old release and current release this specific feature's support is dropped?

Thanks & regards,
-Ertan

UniDAC 5.3 did not still have the Direct mode for SQL Server because it was implemented later, in UniDAC 6.0.1 25-Nov-14. You can find more details about this in the revision history: https://www.devart.com/unidac/revision_history.html