SQL SERVER prDirect+auWindows

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ivanp74
Posts: 2
Joined: Thu 18 May 2017 15:42

SQL SERVER prDirect+auWindows

Post by ivanp74 » Thu 18 May 2017 16:12

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!

ertank
Posts: 172
Joined: Wed 13 Jan 2016 16:00

Re: SQL SERVER prDirect+auWindows

Post by ertank » Thu 18 May 2017 20:49

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.

ivanp74
Posts: 2
Joined: Thu 18 May 2017 15:42

Re: SQL SERVER prDirect+auWindows

Post by ivanp74 » Thu 18 May 2017 20:58

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.

ertank
Posts: 172
Joined: Wed 13 Jan 2016 16:00

Re: SQL SERVER prDirect+auWindows

Post by ertank » Thu 18 May 2017 21:41

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

Code: Select all

Authentication: auWindows
Provider: prDirect
Connection cannot be established and error message indicated by OP is displayed.

There is no problem if provider is set to prNativeClient.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: SQL SERVER prDirect+auWindows

Post by azyk » Fri 19 May 2017 07:39

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.

ertank
Posts: 172
Joined: Wed 13 Jan 2016 16:00

Re: SQL SERVER prDirect+auWindows

Post by ertank » Fri 19 May 2017 08:48

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

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: SQL SERVER prDirect+auWindows

Post by azyk » Fri 19 May 2017 11:02

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

Post Reply