You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am creating a sample application with purpose to demonstrate connecting to on-prem SQL server through SqlClient provider using Azure Active Directory authentication.
I am planning to use Active Directory Interactive and Active Directory Device code flow authentication.
I will be setting Authentication property in the connection string appropriately.
Now, for my application I am assuming that I need to create Azure AD app registration. So, I will be having client Id and tenant Id as well.
But what I am not getting is, how to provide Azure AD client Id, tenant Id to the SqlClient. Can somebody help me through this?
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I am creating a sample application with purpose to demonstrate connecting to on-prem SQL server through SqlClient provider using Azure Active Directory authentication.
I am planning to use Active Directory Interactive and Active Directory Device code flow authentication.
I will be setting Authentication property in the connection string appropriately.
Now, for my application I am assuming that I need to create Azure AD app registration. So, I will be having client Id and tenant Id as well.
But what I am not getting is, how to provide Azure AD client Id, tenant Id to the SqlClient. Can somebody help me through this?
I am referring this documentation related to Active Directory authentication for SqlClient,
https://docs.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication?view=sql-server-ver15
Beta Was this translation helpful? Give feedback.
All reactions