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á about 3 years ago. Updated over 2 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
 #1

Updated by Alena Peterová almost 3 years ago

  • Priority changed from Normal to High

This would be nice to solve, because we meet SQL Server databases as a HR system quite often.

Actions
Copy link
 #2

Updated by Vít Švanda almost 3 years ago

  • Target version set to 11.2.0
Actions
Copy link
 #3

Updated by Vít Švanda almost 3 years ago

  • Estimated time set to 8.00 h
Actions
Copy link
 #4

Updated by Vít Švanda almost 3 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #5

Updated by Vít Švanda almost 3 years ago

  • Subject changed from Support connection properties in the wizard for the SQL Server database table to Support 'Windows authentication' in the wizard for the SQL Server database table
Actions
Copy link
 #6

Updated by Vít Švanda almost 3 years ago

  • % Done changed from 0 to 70
Actions
Copy link
 #7

Updated by Vít Švanda almost 3 years ago

  • Status changed from In Progress to Needs feedback
  • Assignee changed from Vít Švanda to Ondrej Husník
  • % Done changed from 70 to 90

Implemented. MS-SQL wizard now supported Windows authentication -> using logged windows user.

Wizard also supports:
  • NTLM protocol (I was not able tested it),
  • skip CRT server check,
  • use Domain and Instance name.

I implemented test too.

Documentatio is here: https://wiki.czechidm.com/devel/documentation/wizards/table#ms-sql_server_wizard
Commit: https://github.com/bcvsolutions/CzechIdMng/commit/dbc6ad36cfb79fd1aca033a2906939abe31a7b1a

Tip for testing:
<!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc -->
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>9.2.1.jre11</version>
</dependency>

Actions
Copy link
 #8

Updated by Vít Švanda over 2 years ago

  • Assignee changed from Ondrej Husník to Radek Tomiška
Actions
Copy link
 #9

Updated by Radek Tomiška over 2 years ago

  • Status changed from Needs feedback to In Progress
  • Assignee changed from Radek Tomiška to Vít Švanda

I did test and code review, it works, awesome, thx!

I found just one minor issue - filled database, table and key column input value is lost, when authentization method (or trust server certificate, ntlm) is changed.

Actions
Copy link
 #10

Updated by Vít Švanda over 2 years ago

  • Status changed from In Progress to Needs feedback
  • Assignee changed from Vít Švanda to Radek Tomiška
Actions
Copy link
 #11

Updated by Radek Tomiška over 2 years ago

  • Status changed from Needs feedback to Resolved
  • Assignee changed from Radek Tomiška to Vít Švanda
  • % Done changed from 90 to 100

I did test and code review, it works, awesome, thx!

Actions
Copy link
 #12

Updated by Radek Tomiška over 2 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF