topic Re: Library and DB error in New SAS User

Library and DB error

NaveenKichcha — Thu, 13 Feb 2025 09:36:53 GMT

Hi All,

I have setup a library on SAS 9.4 M8 which uses a user name and a password for authentication to the DB server. It was working fine till yesterday but I am not sure what happened and I didn't change any configuration on SAS server but when try to open the library on SAS Enterprise guide I am getting this error :

CLI error trying to establish connection: [SAP][ASE ODBC Driver][Adaptive Server Enterprise] Login failed.

This library is using a Sybase ODBC driver installed on the server to connect to the DB server in backend.

Even my test connection to the DB server from ODBC administrator tool is failing with the same error:

I generated a libname statement on SASMC for the library and tried to run that statement from the editor and got same error:

But the ping to DB server or test connection from my app server windows PowerShell to the DB server is positive. There is no any firewall blockage between my app server and the DB server. So my doubt here is do I need to check anything on the SAS configuration end or the issue is on DB end?? Please guide.

Re: Library and DB error

LinusH — Thu, 13 Feb 2025 09:54:35 GMT

Since it doesn't work outside SAS either, I would start by contacting the DBA's, and next som networking/infra team.

Ping doesn't say much, sometimes ping can reach through even if the road is blocked.

Re: Library and DB error

NaveenKichcha — Thu, 13 Feb 2025 10:33:44 GMT

Thank you for the reply Linush.

I have same issue on the production server as well. But there the test connection from ODBC administrator tool is successful and when I try to access the library on SAS EG, I am getting the same error:

CLI error trying to establish connection: [SAP][ASE ODBC Driver][Adaptive Server Enterprise] Login failed.

So, I thought of checking this on SAS end first.