Forum Discussion

hina's avatar
hina
Contributor
4 months ago
Solved

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...
rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
4 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.

  • hina's avatar
    hina
    Contributor
    4 months ago

    Thank you guys for your reply. The connection string that worked for me is:

    "Provider=MSOLEDBSQL19.1; Persist Security Info=False; Initial Catalog=<db name>; Data Source=<server name>; Use Encryption for Data=False;Authentication=ActiveDirectoryMSI;";