Project

General

Profile

Task #2711

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

Added by Alena Peterová 8 months ago. Updated 29 days ago.

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

100%

Estimated time:
Milestones:

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.

History

#1 Updated by Alena Peterová 6 months 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.

#2 Updated by Vít Švanda 6 months ago

  • Target version set to 11.2.0

#4 Updated by Vít Švanda 3 months ago

  • Status changed from New to In Progress

#5 Updated by Vít Švanda 3 months 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

#6 Updated by Vít Švanda 3 months ago

  • % Done changed from 0 to 70

#7 Updated by Vít Švanda 3 months 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>

#8 Updated by Vít Švanda about 2 months ago

  • Assignee changed from Ondrej Husník to Radek Tomiška

#9 Updated by Radek Tomiška about 1 month 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.

#10 Updated by Vít Švanda about 1 month ago

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

#11 Updated by Radek Tomiška about 1 month 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!

#12 Updated by Radek Tomiška 29 days ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF

Go to top