hina
3 months agoContributor
Connection string using managed identity authentication
Hi, I am trying to connect to the Azure SQL database using managed identity. Here is my the code: AConnection = ADO.CreateADOConnection(); // Specify the connection string var AConnection = ADO.C...
- 3 months ago
I use the following connection string,
"Provider=MSOLEDBSQL19.1; Integrated Security=SSPI; Persist Security Info=False; Initial Catalog=<DB Name>; Data Source=<DB Server Name>; Use Encryption for Data=False;"
together with ADO.CreateConnection method.
You can download the appropriate driver from https://learn.microsoft.com/en-us/sql/connect/oledb/applications/installing-oledb-driver-for-sql-server?view=sql-server-ver17 and ensure you can connect to your database using Microsoft SQL Server Management Studio first.