How To Connect SSMS With Microsoft Azure SQL Cloud Service

In this article, you will learn how to Connect SSMS with Microsoft Azure SQL Cloud Service.

Connect SSMS with Microsoft Azure SQL Cloud Service

Step 1

After Creating Azure SQL Service on Azure Cloud, it's time to Connect with SSMS.

How To Connect SSMS With Microsoft Azure SQL Cloud Service

Select the Public Network Access

Select the public network access for the resource you have created.

How To Connect SSMS With Microsoft Azure SQL Cloud Service

How To Connect SSMS With Microsoft Azure SQL Cloud Service

How To Connect SSMS With Microsoft Azure SQL Cloud Service

Add the Firewall Rule

Now Add the firewall rule for the selected resource so that you can access this from any other environment.

How To Connect SSMS With Microsoft Azure SQL Cloud Service

Public Access Network Updated Successfully

How To Connect SSMS With Microsoft Azure SQL Cloud Service

How To Connect SSMS With Microsoft Azure SQL Cloud Service

Now Get the Connection String

After setting the firewall rule, get the connection string for the Azure SQL Instance.

How To Connect SSMS With Microsoft Azure SQL Cloud Service

Open SSMS (SQL Server Management Studio)

Open the SSMS to make a connection with Azure SQL Instance.

How To Connect SSMS With Microsoft Azure SQL Cloud Service

Enter the Server credentials

Enter the Name of Azure SQL Server Name and User Name and,

How To Connect SSMS With Microsoft Azure SQL Cloud Service

After Entering server Credentials, click the connect button.

How To Connect SSMS With Microsoft Azure SQL Cloud Service

Now you see that our SSMS is now connected with Azure SQL Instance.

How To Connect SSMS With Microsoft Azure SQL Cloud Service

Conclusion

A managed cloud database offered as part of Microsoft Azure is the Microsoft Azure SQL Database. A cloud database is a database that is accessible as a service and is run on a cloud computing platform. Managed database services manage the scalability, backup, and high availability of the database.