[GH-ISSUE #732] Autentication bug using ntlm authenticationScheme in sqlserver driver #189

New issue

Closed

opened 2026-03-07 20:45:53 +03:00 by kerem · 2 comments

kerem commented

2026-03-07 20:45:53 +03:00

Owner

Originally created by @btarazonaj on GitHub (Mar 28, 2022).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/732

Describe the bug
When i try to authenticate with NTLM, it expects pass the password under the "password" field on the request, but the server sends the password under the field "userPassword" and it shows this error:

com.microsoft.sqlserver.jdbc.SQLServerException: "User" (or "UserName") and "Password" connection properties must be specified for NTLM authentication.

If i specify in the driver properties manually fields "User" and "Password" it works and i can connect but the field Password in the driver properties appears in plain text... :((
Anyway the login window appears when you try to connect and it is useless because the driver properties configuration overwrites it.

Driver Properties changes:
authenticationScheme: "ntlm"
integratedSecurity: "true"

Desktop (please complete the following information):

OS: Docker
Version 22.0.1

Originally created by @btarazonaj on GitHub (Mar 28, 2022). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/732 **Describe the bug** When i try to authenticate with NTLM, it expects pass the password under the "password" field on the request, but the server sends the password under the field "userPassword" and it shows this error: com.microsoft.sqlserver.jdbc.SQLServerException: "User" (or "UserName") and "**Password**" connection properties must be specified for NTLM authentication. ![imagen](https://user-images.githubusercontent.com/102534877/160428451-65f78fec-85f1-458e-b88e-c3ddaedacd8d.png) ![imagen](https://user-images.githubusercontent.com/102534877/160428652-56532bac-dc54-4c7b-973a-7bca847272d5.png) If i specify in the driver properties manually fields "User" and "Password" it works and i can connect but the field Password in the driver properties appears in plain text... :(( Anyway the login window appears when you try to connect and it is useless because the driver properties configuration overwrites it. **Driver Properties changes:** authenticationScheme: "ntlm" integratedSecurity: "true" **Desktop (please complete the following information):** - OS: Docker - Version 22.0.1

kerem

2026-03-07 20:45:53 +03:00

closed this issue
added the
x:sql server

xf:connection
labels

kerem commented

2026-03-07 20:45:54 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (Mar 30, 2022):

We are going to add support of diiferent authentication models for SQL Server. NTLM auth will work after that.
Here is similar ticket.

@kseniiaguzeeva commented on GitHub (Mar 30, 2022): We are going to add support of diiferent authentication models for SQL Server. NTLM auth will work after that. Here is [similar ticket](https://github.com/dbeaver/cloudbeaver/issues/392).

kerem commented

2026-03-07 20:45:54 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (Jun 1, 2022):

NTLM authentication is added for SQL Server. Could you please just select it in the Connection dialog and enter your credentials?

@kseniiaguzeeva commented on GitHub (Jun 1, 2022): NTLM authentication is added for SQL Server. Could you please just select it in the Connection dialog and enter your credentials? ![Screenshot 2022-06-01 at 10 53 01](https://user-images.githubusercontent.com/51405061/171355262-4e08fca2-37b5-4f0b-9210-80ee710eda12.png)