Problem starting InfoMart

[efrainclg95]

Dear expert friends, first of all I hope you are well, it happens that I have a problem starting InfoMart (new installation), I have the ICONs operational, I have a sql server 2019 with the ICON and InfoMart databases properly configured, in addition to this I have a DBServer installed on the sqlserver 2019 database server, said DBServer is connected to the dap of the ICON and Infomart, but when uploading the InfoMart application the application does not run and does not leave a log record, but when reviewing the DBServer log I have this line:

+0000 Open DB: username = 'sa', database = 'ICON_CFG', dbserver = 'CIM1-2'
+15888 Could not connect to SQL Server using SQL Server Native Client 11.0. Attemting default MS SQL Server driver...
+33728 odbcerr: [Microsoft][ODBC SQL Server Driver]Dialog failed
+33728 MSG_ERROR status='dbNotOpened' msg='[Microsoft][ODBC SQL Server Driver]Dialog failed '

+0000 Open DB: username = 'sa', database = 'ICON_Voice', dbserver = 'CIM1-2'
+15795 Could not connect to SQL Server using SQL Server Native Client 11.0. Attemting default MS SQL Server driver...
+33628 odbcerr: [Microsoft][ODBC SQL Server Driver]Dialog failed
+33628 MSG_ERROR status='dbNotOpened' msg='[Microsoft][ODBC SQL Server Driver]Dialog failed '

You mention something of a connection problem, my server system variables for infomart (windows server 2019) are:

CLASSPATH
C:\Program Files\Java\jre1.8.0_351\mssql-jdbc-6.2.2.jre7.jar

JAVA_HOME
C:\Program Files\Java\jre1.8.0_351

I don't know what could be wrong, please your kind support and/or recommendations.

Thank you

[nonny]

It's likely your issue relates to TLS being required and not using the correct SQL client.  Check the registry settings on both your InfoMart host and SQL Server for TLS etc then also look into downloading and using the latest SQL native client.  There's a couple of articles around that specifically mention some of this.

[efrainclg95]

Thanks Nonny, I found the problem and it was so simple, I didn't have the mssql-jdbc-6.2.2.jre7.jar in the correct path, I corrected the path and it worked.

Correct path:
CLASSPATH
C:\Program Files\Java\jre1.8.0_351\lib\mssql-jdbc-6.2.2.jre7.jar

Thanks for your time and help