"Connection to the database failed for an unknown reason." connection to MSSQL fails even when tsql succeeds #1688
Description
connexion Issue with PgLoader :
$ pgloader --debug --verbose --dry-run ms.loaddevel
pgloader version 3.6.3
compiled with SBCL 2.1.11.debian
sb-impl::default-external-format :UTF-8
tmpdir: #P"/tmp/pgloader/"
2025-10-14T10:42:02.004001Z NOTICE Starting pgloader, log system is ready.
2025-10-14T10:42:02.012001Z INFO Starting monitor
2025-10-14T10:42:02.016001Z LOG pgloader version "3.6.3~devel"
2025-10-14T10:42:02.040002Z INFO Parsed command:
LOAD DATABASE
FROM mssql://Test_Connexion:Test...2025@host2019.domaine.local:1433/BDD_PRE_PRODUCTION
INTO pgsql://postgres:example@10.173.254.184:5432/my_bdd_test
;
2025-10-14T10:42:02.040002Z LOG Loading the FreeTDS shared librairy (sybdb)
2025-10-14T10:42:02.044002Z LOG DRY RUN, only checking connections.
2025-10-14T10:42:02.044002Z LOG Attempting to connect to #<MSSQL-CONNECTION mssql://Test_Connexion@host2019.domaine.local:1433/BDD_PRE_PRODUCTION {1007F983D3}>
2025-10-14T10:42:02.076004Z FATAL Failed to connect to #<MSSQL-CONNECTION mssql://Test_Connexion@host2019.domaine.local:1433/BDD_PRE_PRODUCTION {1007F983D3}>: Failed to connect to mssql at "VDRSQL2019.primever.local" (port 1433) as user "Test_Connexion": Connection to the database failed for an unknown reason.
2025-10-14T10:42:02.076004Z LOG Attempting to connect to #<PGSQL-CONNECTION pgsql://postgres@10.173.254.184:5432/my_bdd_test {1007F99113}>
2025-10-14T10:42:02.120006Z DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@10.173.254.184:5432/my_bdd_test {1007F99113}>
2025-10-14T10:42:02.124006Z LOG Success, opened #<PGSQL-CONNECTION pgsql://postgres@10.173.254.184:5432/my_bdd_test {1007F99113}>.
2025-10-14T10:42:02.124006Z LOG Running a simple query: SELECT 1;
2025-10-14T10:42:02.128006Z SQL SELECT 1;
2025-10-14T10:42:02.128006Z LOG report summary reset
table name errors read imported bytes total time read write
2025-10-14T10:42:02.152007Z INFO Stopping monitor
Connexion with sqlcmd OK:
~$ /opt/mssql-tools18/bin/sqlcmd -S host2019.domaine.local -U "Test_Connexion" -P "Test...2025"
1> exit
~$