Create a connection to Azure sql server using "Active Directory - Integrated " authentication

Hi,

We have a server for which we need to use "Active Directory - Integrated " authentication.

I tried adding "OLEDB" connection. But there I can just see "windows authentication" and "sql server authentication". Can you please let me know how I can configure "Active Directory - Integrated " authentication in BIML studio

Hi Raksha, 

Sorry for the delayed response. As our code uses ADO.NET, it should hand off the code appropriately and produce a window prompt for the user to sign into. You can also save those credentials locally for automated builds. What happens when you try and put SQL Server Auth and test the connection?