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.

Select the Public Network Access

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

Add the Firewall Rule

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

Public Access Network Updated Successfully

Now Get the Connection String

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

Open SSMS (SQL Server Management Studio)

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

Enter the Server credentials

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

After Entering server Credentials, click the connect button.

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

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.