Question - How to connect to Azure Database from SQL Management Studio?
Answer -
1. The first time you start the SQL Server Management Studio, the Connect to Server dialog box opens up automatically. You can also open it manually by going to Object Explorer > Connect > Database Engine.
2. Then, enter the following information in the Connect to Server window:
Server Type Database Engine
Server Name Enter the name of your Azure SQL Database or Azure Managed Instance
Authentication SQL Server Authentication
Login Enter the server account user ID
Password Enter the server account password You can also choose to change the additional connection options by going to Options.
3. Click on Connect after completing all the required fields
If the firewall settings are not set up, a prompt appears to configure the same. Once signed in, provide the Azure account login information, and set the firewall rule. Then, click on OK.
4. To verify if your Azure Database connection is successful, expand and explore Object Explorer for the server name, the SQL Server version, and the username.