Project

General

Profile

Actions
Copy link

Task #2711

closed

Support 'Windows authentication' in the wizard for the SQL Server database table

Added by Alena Peterová almost 4 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
High
Assignee:
Vít Švanda
Category:
Wizard
Target version:
11.2.0
Start date:
03/05/2021
Due date:
% Done:

100%

Estimated time:
8.00 h
Owner:

Description

We need to use more connection properties, when connecting to the SQL Server under a domain user using Windows Authentication.
These properties have to be written in the JDBC URL, but currently, there is no way to do it in the wizard.

I needed these: integratedSecurity=true;authenticationScheme=NTLM;domain=somedomain.tld.
Description: https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-2017
Note: The user wasn't created locally in the DB => SQL Server Authentication didn't work. IdM isn't installed on Windows => NativeAuthentication couldn't be used. So NTLM and we had to use standard Database table connector.

Actions
Copy link

Also available in: Atom PDF