JDBC Library for Azure Sql Server created in SAS Management Console Register Tables returns no table

[rtynd4]

Not sure if this is the right group. but here goes:

I have created a JDBC library using the SAS Management Console. When trying to registering tables it return no tables and the error message is "No Tables were retrieved from your query". Trying to connect to Azure SQL Server database. 

Below is the details of the registering table. There is an exclamation next to the DRIVERCLASS.

If I log into the database using a different tool the default schema is dbo which has no tables. The library is assigned but it fetches no tables to register.

Any help would be appreciated.

NOTE: The autoexec file, /usr/sas/config8/Lev2/SASApp/WorkspaceServer/autoexec.sas, was executed at server initialization.
1 LIBNAME pathncpp SASIOJDB URL="serv-ccc-path-pp-synws.sql.azuresynapse.net:1433;
2 Authentication=ActiveDirectoryServicePrincipal;
3 databaseName=Mydatabase;
4 schema=Myschema;
5 user=userxxx;
6 password=xxxT;
7 "
8 CLASSPATH="/usr/sas/sashome8/AccessClients/9.4/DataDrivers/jdbc/synapse"
8 ! DRIVERCLASS="com.microsoft.sqlserver.jdbc.SQLServerDriver" AUTHDOMAIN="PathNC_PreProd_Auth" ;
NOTE: Credential obtained from SAS metadata server.
NOTE: Libref PATHNCPP was successfully assigned as follows:
Engine: JDBC
Physical Name:
jdbc:sqlserver://serv-ccc-path-pp-synws.sql.azuresynapse.net:1433;Authentication=ActiveDirectoryServicePrincipal;database
Name=Mydatabase;schema=Myschema;user=userxxx;password=xxx;

[SASKiwi]

Does the chosen database and schema genuinely have tables in it? If so how long are the tables names? If they are all > 32 characters then SAS can't handle this and will not return any names. Try creating a table <= 32 characters long and see if that works. Open the LIBREF pathncpp in SAS EG or SAS Studio to see if any tables are listed.

[rtynd4]

There are 3 out of 38 tables where the name is > 32. However, there are many columns in each table where the column length is > 32.

Thx for the help.