Cognos Analytics

I am able to connect with Azure synaps datasource with database SQL login, but my customer prefer that vi use a service princal account.  I have  CA 11.7 in production and CA 12.1 in sandbox enviroment. I have to adjust JDBC URL and entered ID and Secret to server prinsipal as user name and password 
without any success. Has anyone done this?   Do I need to update JDBC driver?  

Enclosed are the screenshots of my connection that not working.  

After working on this for a while I got it to work by loading jar files into the drivers folder.  First I downloaded version 12.8 of SQL JDBC driver. From here i copied mssql-jdbc-12.8.0.jre8.jar to drivers folder. To find the  addition jar files I used DBeaver. When doing a connection against Azure DB all jar files was placed in  \Users\{username}\AppData\Roaming\DBeaverData\drivers\maven\maven-central. From this structure I copied   slf4j-api-1.7.36.jar, oauth2-oidc-sdk-11.9.1.jar, nimbus-jose-jwt-9.37.3.jar, msal4j-1.16.0.jar, lang-tag-1.7.jar, json-smart-2.5.0.jar, jcip-annotations-1.0-1.jar, jackson-databind-2.13.4.2.jar, jackson-core-2.13.4.jar, jackson-annotations-2.13.4.jar, content-type-2.3.jar, asm-9.3.jar and accessors-smart-2.5.0.jar.    The JDBC string I used was :  jdbc:sqlserver://;serverName=[servername];databaseName=[databasename];encrypt=true;trustServerCertificate=true;authentication=ActiveDirectoryServicePrincipal

I posted this in blog so it possible to see screenshots : https://community.ibm.com/community/user/businessanalytics/blogs/pl-risa-zachariassen/2024/09/24/connect-cognos-analytics-to-azure-db-with?CommunityKey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58

------------------------------
Pål Risa Zachariassen
Director
KPMG
Oslo
------------------------------