https://redmine.czechidm.com/https://redmine.czechidm.com/themes/purplemine2/favicon/favicon.ico?16339658642021-04-26T10:31:23ZIdStory Identity ManagerIdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=151812021-04-26T10:31:23ZAlena Peterováalena.peterova@bcvsolutions.eu
<ul><li><strong>Priority</strong> changed from <i>Normal</i> to <i>High</i></li></ul><p>This would be nice to solve, because we meet SQL Server databases as a HR system quite often.</p> IdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=151822021-04-26T10:35:17ZVít Švanda
<ul><li><strong>Target version</strong> set to <i>11.2.0</i></li></ul> IdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=157932021-07-12T09:52:56ZVít Švanda
<ul><li><strong>Estimated time</strong> set to <i>8.00 h</i></li></ul> IdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=158292021-07-13T13:30:42ZVít Švanda
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>In Progress</i></li></ul> IdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=158362021-07-14T15:02:13ZVít Švanda
<ul><li><strong>Subject</strong> changed from <i>Support connection properties in the wizard for the SQL Server database table</i> to <i>Support 'Windows authentication' in the wizard for the SQL Server database table</i></li></ul> IdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=158412021-07-15T14:48:00ZVít Švanda
<ul><li><strong>% Done</strong> changed from <i>0</i> to <i>70</i></li></ul> IdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=158992021-07-16T13:35:16ZVít Švanda
<ul><li><strong>Status</strong> changed from <i>In Progress</i> to <i>Needs feedback</i></li><li><strong>Assignee</strong> changed from <i>Vít Švanda</i> to <i>Ondrej Husník</i></li><li><strong>% Done</strong> changed from <i>70</i> to <i>90</i></li></ul><p>Implemented. MS-SQL wizard now supported Windows authentication -> using logged windows user.</p>
Wizard also supports:
<ul>
<li>NTLM protocol (I was not able tested it),</li>
<li>skip CRT server check,</li>
<li>use Domain and Instance name.</li>
</ul>
<p>I implemented test too.</p>
<p>Documentatio is here: <a class="external" href="https://wiki.czechidm.com/devel/documentation/wizards/table#ms-sql_server_wizard">https://wiki.czechidm.com/devel/documentation/wizards/table#ms-sql_server_wizard</a><br />Commit: <a class="external" href="https://github.com/bcvsolutions/CzechIdMng/commit/dbc6ad36cfb79fd1aca033a2906939abe31a7b1a">https://github.com/bcvsolutions/CzechIdMng/commit/dbc6ad36cfb79fd1aca033a2906939abe31a7b1a</a></p>
<p>Tip for testing:<br /><code> <!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc --><br /> <dependency><br /> <groupId>com.microsoft.sqlserver</groupId><br /> <artifactId>mssql-jdbc</artifactId><br /> <version>9.2.1.jre11</version><br /> </dependency></code></p> IdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=161372021-09-06T08:05:06ZVít Švanda
<ul><li><strong>Assignee</strong> changed from <i>Ondrej Husník</i> to <i>Radek Tomiška</i></li></ul> IdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=161452021-09-07T12:28:54ZRadek Tomiškaradek.tomiska@bcvsolutions.eu
<ul><li><strong>Status</strong> changed from <i>Needs feedback</i> to <i>In Progress</i></li><li><strong>Assignee</strong> changed from <i>Radek Tomiška</i> to <i>Vít Švanda</i></li></ul><p>I did test and code review, it works, awesome, thx!</p>
<p>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.</p> IdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=161472021-09-07T13:58:40ZVít Švanda
<ul><li><strong>Status</strong> changed from <i>In Progress</i> to <i>Needs feedback</i></li><li><strong>Assignee</strong> changed from <i>Vít Švanda</i> to <i>Radek Tomiška</i></li></ul><p>Thanks for testing, I fixed field clearing.</p>
<p>Commit: <a class="external" href="https://github.com/bcvsolutions/CzechIdMng/commit/75fc846d76737c5107e78e9f0a4cfaf179340cfd">https://github.com/bcvsolutions/CzechIdMng/commit/75fc846d76737c5107e78e9f0a4cfaf179340cfd</a></p> IdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=161482021-09-08T06:34:54ZRadek Tomiškaradek.tomiska@bcvsolutions.eu
<ul><li><strong>Status</strong> changed from <i>Needs feedback</i> to <i>Resolved</i></li><li><strong>Assignee</strong> changed from <i>Radek Tomiška</i> to <i>Vít Švanda</i></li><li><strong>% Done</strong> changed from <i>90</i> to <i>100</i></li></ul><p>I did test and code review, it works, awesome, thx!</p> IdStory Identity Manager - Task #2711: Support 'Windows authentication' in the wizard for the SQL Server database tablehttps://redmine.czechidm.com/issues/2711?journal_id=162662021-09-23T06:28:43ZRadek Tomiškaradek.tomiska@bcvsolutions.eu
<ul><li><strong>Status</strong> changed from <i>Resolved</i> to <i>Closed</i></li></ul>