Problem importing foreign MSSQL schema

[grouchobear]

We're attempting to connect to an MSSQL server and are receiving an error when importing the dbo schema. The error is:
ERROR: remote server returned an error

SQL state: XX000

Not sure what this indicates and any insights are appreciated.

Steps used creating the FDW:
CREATE EXTENSION IF NOT EXISTS jdbc_fdw SCHEMA public VERSION "1.2";

/* mssql-jdbc-12.2.0.jre11.jar is located in /usr/bin */
CREATE SERVER lyons_mssql FOREIGN DATA WRAPPER jdbc_fdw OPTIONS(
drivername 'com.microsoft.sqlserver.jdbc.SQLServerDriver',
url 'jdbc:sqlserver://;serverName=sqlcluster;databaseName=lmdw',
querytimeout '30',
jarfile '/usr/bin/mssql-jdbc-12.2.0.jre11.jar',
maxheapsize '600'
);

CREATE USER MAPPING FOR CURRENT_USER SERVER lyons_mssql OPTIONS(username 'readeruser',password '*********');

CREATE SCHEMA IF NOT EXISTS lyons_mssql_dbo AUTHORIZATION postgres;

IMPORT FOREIGN SCHEMA dbo LIMIT TO (BATCH) FROM SERVER lyons_mssql INTO lyons_mssql_dbo;

[Kenchir]

I am not sure. But its said on docs, import schema works only on GridDB.
You can use this PR which fixes debug mode display on logs for more understanding of the error you are facing.

[JulmeTran]

Currently, we do not support JDBC FDW with SQL Server.
We have not tested on SQL Server and only support import foreign schema on GridDB.
Therefore, we can not provide any information about this problem.

[m0rt]

Hello.

I currently have the same problem when connecting to SyBase ASE, is it possible to activate debug ?

[ShahriarKh]

For anyone facing the same issue, you can check the logs on sql server side. In SSMS, from Object Explorer, open XEvent Profiler and try to run the query from postgres again. You will see live logs in SSMS and that can help you debug.
For me, it was a connection issue and I had to use jdbc:// ... ;trustServerCertificate=true;encrypt=false; to connect to my local instance.