How do I use an Azure Active Directory Service Principal to connect to an Azure SQL DB?

asked 2019-05-09 14:15:39 -0500

lonzo177 gravatar image

Hello, I am looking for guidance using an Azure Active Directory Service Principal to connect to an Azure SQL Database using the JDBC Producer Destination.

Any guidance would be greatly appreciated.

edit retag flag offensive close merge delete

Comments

Have you tried a connection string in this format using MS-SQL JDBC Driver 6.0 "jdbc:datadirect:sqlserver://your_server.database.windows:1433; AuthenticationMethod=ActiveDirectoryPassword;HostNameInCertificate=*.database.windows; ">User=test@mydomain.com;Password=secret""

rupal gravatar imagerupal ( 2019-06-12 16:03:38 -0500 )edit