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.