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)
Release : 20.1
Component : UIM - INSTALL
This is due to Windows Authentication for SQL connection
Installer works fine if we select SQL Authentication