Timeout to SQL Server in Azure

osmelbrito — Tue, 13 Sep 2022 16:55:02 GMT

We just added ACCESS to SQL Server on our linux installation.

We installed odbc drivers in linux and we connect to destination database


universal@gu01sasdi.seguros.local:/home/universal>isql InteligenciaComercial17 sql_admin XXXXXXX -v
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

but when we try to connect using libname from SAS

libname azdescom sqlsvr datasrc=InteligenciaComercial18  schema=UNIPROFIT
                 user=sql_admin password="XXXXX" CONNECTION=SHARED
                 insertbuff=30000 readbuff=20000 trace=yes tracefile="/home/universal/odbc.log";

we got the following error

ERROR: CLI error trying to establish connection: [unixODBC][Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired : 
       [unixODBC][Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9
ERROR: Error in the LIBNAME statement.

I just opened a support track with SAS

Re: Timeout to SQL Server in Azure

SASKiwi — Tue, 13 Sep 2022 20:57:39 GMT

Have you tested SAS/ACCESS to SQL Server with any other database and does it work? If so then you have a connection-specific problem and Tech Support is your best option so it's great that you have already opened a track.

topic Timeout to SQL Server in Azure in SAS Programming

Timeout to SQL Server in Azure

Re: Timeout to SQL Server in Azure