I have installed a .Net Framework 4.5.2 Web app into Azure, which is set up to use Entra authentication. The app needs to connect to a SQL Server database in the Azure account. The Azure UI shows a variety of connection strings to use with the database. But none of them work. I put the connection strings (modified to include server, db, uid, and pwd as needed) in a Connection String environmental variable. It does not allow specifying a provider, by the way. How do I know what providers are present in Azure? Or do I need to add a new one to my application? It currently references System.Data.

I have installed a .Net Framework 4.5.2 Web app into Azure, which is set up to use Entra authentication. The app needs to connect to a SQL Server database in the Azure account. The Azure UI shows a variety of connection strings to use with the database. But none of them work. I put the connection strings (modified to include server, db, uid, and pwd as needed) in a Connection String environmental variable. It does not allow specifying a provider, by the way. How do I know what providers are present in Azure? Or do I need to add a new one to my application? It currently references System.Data.

I have installed a .Net Framework 4.5.2 Web app into Azure, which is set up to use Entra authentication. The app needs to connect to a SQL Server database in the Azure account. The Azure UI shows a variety of connection strings to use with the database. But none of them work. I put the connection strings (modified to include server, db, uid, and pwd as needed) in a Connection String environmental variable. It does not allow specifying a provider, by the way. How do I know what providers are present in Azure? Or do I need to add a new one to my application? It currently references System.Data.

I have installed a .Net Framework 4.5.2 Web app into Azure, which is set up to use Entra authentication. The app needs to connect to a SQL Server database in the Azure account. The Azure UI shows a variety of connection strings to use with the database. But none of them work. I put the connection strings (modified to include server, db, uid, and pwd as needed) in a Connection String environmental variable. It does not allow specifying a provider, by the way. How do I know what providers are present in Azure? Or do I need to add a new one to my application? It currently references System.Data.

I have installed a .Net Framework 4.5.2 Web app into Azure, which is set up to use Entra authentication. The app needs to connect to a SQL Server database in the Azure account. The Azure UI shows a variety of connection strings to use with the database. But none of them work. I put the connection strings (modified to include server, db, uid, and pwd as needed) in a Connection String environmental variable. It does not allow specifying a provider, by the way. How do I know what providers are present in Azure? Or do I need to add a new one to my application? It currently references System.Data.