Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed

On 12/6/24 13:19, Zacher, Stacy wrote:
> Hello:
>
> We recently did an OS upgrade from Rocky Linux 8 to 9 on a Postgres v13
> server that has 2 Foreign data wrappers that use tds_fdw for connections
> to 2 different SQL Servers.
>
> After the OS upgrade, one of the FDWs stopped working for some reason
> but the other one still works.
>
> The error message when trying to run the import statement in psql is as
> follows (I changed some of the names):
>
> using psql:
>

> I tested connecting to the server/port via ncat and it returns
> successfully.
>
> When I try sqlcmd or tsql, The 1477 port is static (vs. dynamic)
>
> [postgres(at)rh9server bin]$ ./sqlcmd -S 141.xxx.x.xxx,1477 -C -d Pdata_db
> -U PData_Reader -P xxxxxxxxxxxxxx
>
> Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : TCP Provider:
> Error code 0x2746.

Some searching mentions that this 'TCP Provider: Error code 0x2746.' can
be related to lack of TLS 1.2 support.

I don't see your tsql connection attempt.

> The FDW that is still working is going to a SQL Server v14.x 2017 server
> and the broken one is going to a SQL Server version 13 2016 server.

Are the SQL Server instances running on the same machine?

If not what versions of Windows are they using in each case?

>
> Also, I recreated the FDW that is broken on another server (Postgres 16
> on Rocky Linux 8) and it works there.
>
> So I'm puzzled here as to why it's not working on the upgraded server,
> yet the other FDW on the same server still works.
>
> Any help on this issue would be greatly appreciated.
>
> Thank you,
>
> Stacy
>
> szacher(at)mcw(dot)edu
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com