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!
SQL SERVER prDirect+auWindows
Re: SQL SERVER prDirect+auWindows
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.
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.
Re: SQL SERVER prDirect+auWindows
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.
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.
Re: SQL SERVER prDirect+auWindows
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.
-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
Code: Select all
Authentication: auWindows
Provider: prDirect
There is no problem if provider is set to prNativeClient.
Re: SQL SERVER prDirect+auWindows
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.
Re: SQL SERVER prDirect+auWindows
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
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
Re: SQL SERVER prDirect+auWindows
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