I have a new M8 setup and we are connecting to SQL server using Access engine through provided Datadirect drivers LIBNAME SQLSRVT SQLSVR Datasrc=MyDatasrc SCHEMA=MySchema authdomain="SQLSRV"; Authentication is successful but it does not list Schema tables in the library I have some users connecting to SQL server using long Libname definitions: LIBNAME SQLSRVT1 SQLSVR NOPROMPT="Driver=SAS Institute, Inc 8.2 SQL Server Wire Protocol; AuthenticationMethod=9; Database=MYDB ; HostName= MyHost\SSINST; PortNumber=Myport; Domain=MYDOMAIN; LogonID=[username]; Password=[password];" Schema=MySchema; Library assignment is successful and it list tables. Can you suggest where this is going wrong? Below are the ODBC.ini entries for libname using AuthDomain [DataSRC] Driver=/sashome/AccessClients/9.4/SQLServer/lib/S0sqls28.so Description=SAS Institute, Inc 8.2 SQL Server Wire Protocol AuthenticationMethod=9 Database=MyDB HostName=MyHost\SSINST PortNumber=MYPORT EncryptionMethod=6 ValidateServerCertificate=0 Trusted_Connection=Yes QuotedId=yes IntegratedSecurity=false TrustServerCertificate=yes CryptoProtocolVersion=TLSv1.2, TLSv1.1,TLSv1, SSLv3, SSLv2 SSLLibName=/usr/lib64/libssl.so.1.1 CryptoLibName=/usr/lib64/libcrypto.so.1.1
... View more