Type of connection used by Altair SLC (WPS)

juraj kotisa_21947
juraj kotisa_21947 Altair Community Member
edited August 2 in Community Q&A

Hello all,

I have WPS (now Altair SLC) version 4.04 running on RHEL 8.10. User is connecting via analytics workbench to this server. On the analytics workbench he is trying to connect to a mssql server via sas code executed in the Workbench: 

%let ZIPCONN=Server='server,port' database='XXQUATDB1' schema='dbo' user='username' password='password';

Anyhow this execution is failing with the following error:

ERROR: A database error occurred. The database specific error follows:
DB: 08001: [Microsoft][ODBC Driver 13 for SQL Server]TCP Provider: Error code 0x2746
08001: [Microsoft][ODBC Driver 13 for SQL Server]TCP Provider: Error code 0x2746

Is ODBC driver responsible for the connection?

recently we upgraded OS from RHEL 7.9 to 8.10.

Is there any other upgrade (maybe ODBC) necessary? 

Any idea how to resolve this issue?

OS: RHEL 8.10
unixODBC version 2.3.11

OpenSSL 1.1.1k  FIPS 25 Mar 2021

Issue is very urgent, as we are facing it on UAT and PROD and lots of jobs are failing because of this problem

Many thanks for any advice on this

 

 

Tagged:

Answers

Categories