Connecting To Azure SQL Database With Active Directory - Universal With MFA. The Complete CLOUD Azure Developer Course 2022 [Videos].

Azure SQL Database - Microsoft Azure SQL Database is a Microsoft Azure-provided managed cloud database. A cloud database is a database that is accessible as a service and runs on a cloud computing platform. Managed database services look after the databases scalability, backup, and high availability.

To connect Azure SQL with Universal MFA, SQL server management studio Needs to be SQL016 or higher.

Below is V13.0 SSMS and you can see there is no Active Directory- Universal with MFA Option,

Most recent version is 18.11. You can download from here (Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) | Microsoft Docs)

Step 1

Navigate to Azure portal and search for Azure SQL Server.

Step 2

Select the SQL Server – In Overview – Copy the Server name,

Step 3

Now go to the SQL Server Management Studio,

Paste the server name,

Type the Username then Connect,

After the Connect it will popup a sign-in window and verify the Identity with MFA,

Now you have successfully connected to the Azure SQL Server,

    See All

    Comments (605 Comments)

    Submit Your Comment

    See All Posts

    Related Posts

    CLOUD Azure / Blog

    How to Creating ASP.NET Web App In Azure?

    Azure Web App is very popular service in Azure and it is very cheap in cost as compared to the other services. It provides awesome features and a highly scalable, self-patching web hosting service. Deployment is quite simple with Azure. The advantage of Azure Web App is that it supports multiple languages, like .NET, Java, PHP, Node.js.
    7-Feb-2022 /21 /605

    CLOUD Azure / Blog

    What Is Azure Functions?

    Azure functions is a serverless concept of cloud native design that allows a piece of code deployed and execute without any need of server infrastructure, web server, or any configurations. Azure functions can be written in multiple languages such as C#, Java, JavaScript, TypeScript, and Python.
    7-Feb-2022 /21 /605

    CLOUD Azure / Blog

    Getting Started with Azure File Storage

    Azure File Storage, a Microsoft cloud storage solution for modern applications, offers a file-sharing system in the cloud. This system is easily accessible via Server Message Block (SMB) protocol or NFS protocol.
    8-Mar-2022 /21 /605