Issue on database connection during the installation with Windows Authentication

book

Article ID: 198297

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

I'm currently installing the last version of UIM 20.1 in our lab

OS : Windows 2019
SQL : Microsoft SQL
Version : Windows Server 2016 Standard  

When I'm on the install, I'm stuck on the Database Configuration and the Test do not give me any error and do not unlock the next option.

We cannot use  Windows Authentication to create or use the existing database.
After check the uimserver_ia_install.log file, I have the following error :

2020-07-29 15:15:19,332 DEBUG config.UIMServerDBConfigBase:getTLSEmptyFieldValidation:83 [AWT-EventQueue-0]  - TLS Mode: no
2020-07-29 15:15:19,332 DEBUG config.UIMServerDBConfigBase:validateEmptyFields:72 [AWT-EventQueue-0]  - bEmptyTLSFieldsExistFlag: false
2020-07-29 15:15:19,332 DEBUG access.UIMServerDBAccessBase:getNimDBProviderBase:63 [AWT-EventQueue-0]  - Provider Name: sqlserver
2020-07-29 15:15:19,332 DEBUG access.UIMServerDBAccessBase:getNimDBProviderBase:67 [AWT-EventQueue-0]  - TLS Enabled: no
2020-07-29 15:15:19,332 DEBUG access.UIMServerDBAccessBase:getNimDBProviderBase:69 [AWT-EventQueue-0]  - Database Name: UIM_QUAL
2020-07-29 15:15:19,332 DEBUG individual.IndivDBProviderFactory:createDBProvider:31 [AWT-EventQueue-0]  - Retrieving provider for provider_name: sqlserver
2020-07-29 15:15:19,332 DEBUG provider.NimDBProviderBase:initDriver:81 [AWT-EventQueue-0]  - pre: initializing driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
2020-07-29 15:15:19,332 INFO  provider.NimDBProviderBase:initDriver:83 [AWT-EventQueue-0]  - post: successfully initialized driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
2020-07-29 15:15:19,332 DEBUG individual.SqlserverDBProvider:parseDBServerForEmbeddedPort:152 [AWT-EventQueue-0]  - sbDBServerOut: database-PP
2020-07-29 15:15:19,332 DEBUG individual.SqlserverDBProvider:parseDBServerForEmbeddedPort:153 [AWT-EventQueue-0]  - sbDBPortOut: 
2020-07-29 15:15:19,332 DEBUG individual.SqlserverDBProvider:postProcessServerName:128 [AWT-EventQueue-0]  - 2-server: database-PP
2020-07-29 15:15:19,332 DEBUG individual.SqlserverDBProvider:postProcessServerName:129 [AWT-EventQueue-0]  - 2-port: 1433
2020-07-29 15:15:19,332 DEBUG config.UIMServerDBConfigSqlserver:isInstanceNameSpecified:69 [AWT-EventQueue-0]  - bInstanceNameSpecifiedFlag: false
2020-07-29 15:15:19,332 DEBUG config.UIMServerDBConfigSqlserver:validateDBPort:126 [AWT-EventQueue-0]  - strDBPort: 1433
Exception in thread "AWT-EventQueue-0" java.lang.NoClassDefFoundError: com/sun/jna/platform/win32/Advapi32
 at com.nimsoft.install.nimcommon.security.windows.WindowsAuthenticationValidator.<init>(WindowsAuthenticationValidator.java:23)
 at com.nimsoft.install.uimserver.windows.WindowsAuthenticationModeUtility.validateWindowsLogin(WindowsAuthenticationModeUtility.java:35)
 at com.nimsoft.install.uimserver.db.config.UIMServerDBConfigSqlserver.validateWindowsAuthLogin(UIMServerDBConfigSqlserver.java:173)
 at com.nimsoft.install.uimserver.db.config.UIMServerDBConfigSqlserver.validateIndivFieldsAddl(UIMServerDBConfigSqlserver.java:117)
 at com.nimsoft.install.uimserver.db.config.UIMServerDBConfigBase.validateIndivFields(UIMServerDBConfigBase.java:110)
 at com.nimsoft.install.uimserver.db.config.UIMServerDBConfigBase.validateFields(UIMServerDBConfigBase.java:52)
 at com.nimsoft.install.uimserver.panel.impl.dbconfig.UIMServerDatabaseConfigBaseParamsPanel.processFieldValidation(UIMServerDatabaseConfigBaseParamsPanel.java:122)
 at com.nimsoft.install.uimserver.panel.impl.dbconfig.UIMServerDatabaseConfigSqlserverParamsPanel.btnTestActionPerformed(UIMServerDatabaseConfigSqlserverParamsPanel.java:511)
 at com.nimsoft.install.uimserver.panel.impl.dbconfig.UIMServerDatabaseConfigSqlserverParamsPanel.access$100(UIMServerDatabaseConfigSqlserverParamsPanel.java:35)
 at com.nimsoft.install.uimserver.panel.impl.dbconfig.UIMServerDatabaseConfigSqlserverParamsPanel$2.actionPerformed(UIMServerDatabaseConfigSqlserverParamsPanel.java:302)

Cause

This is due to Windows Authentication for SQL connection

Installer works fine if we select SQL Authentication

Environment

Release : 20.1

Component : UIM - INSTALL

Resolution

We have attached a zip file which contains 2 jars (jna-4.1.0.jar, jna-platform-4.1.0.jar) files please extract them and put it into "C:\Windows\Sun\Java\lib\ext"

Then start the installation. As this is installer we cannot provide hotfix for the same. the fix is available in the next release.

Attachments

1598599683830__jna-patch.zip get_app