Azure

Connecting To Azure SQL Database With Energetic Listing – Common With MFA

Overview

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)

Step 1

Navigate to Azure portal and seek for Azure SQL Server.

Step 2

Choose the SQL Server – In Overview – Copy the Server identify,

Connecting to Azure SQL Database with Active Directory – Universal with MFA

Step 3

Now go to the SQL Server Administration Studio,

Paste the server identify,

Kind the Username then Join,

Connecting to Azure SQL Database with Active Directory – Universal with MFA

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,

Tags
Show More

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Close