Connecting To Azure SQL Database With Energetic Listing – Common With MFA
Azure SQL Database – Microsoft Azure SQL Database is a Microsoft Azure-provided managed cloud database. A cloud database is a database that’s accessible as a service and runs on a cloud computing platform. Managed database companies take care of the database’s scalability, backup, and excessive availability.
To attach Azure SQL with Common MFA, SQL server administration studio Must be SQL016 or increased.
Beneath is V13.zero SSMS and you’ll see there isn’t a Energetic Listing- Common with MFA Choice,
Most up-to-date model is 18.11. You may obtain from right here (Obtain SQL Server Administration Studio (SSMS) – SQL Server Administration Studio (SSMS) | Microsoft Docs)
Navigate to Azure portal and seek for Azure SQL Server.
Choose the SQL Server – In Overview – Copy the Server identify,
Now go to the SQL Server Administration Studio,
Paste the server identify,
Kind the Username then Join,
After the Join it’s going to popup a sign-in window and confirm the Id with MFA,
Now you’ve efficiently related to the Azure SQL Server,