i. The Connect to Server dialogue box automatically appears when you launch SQL Server Management Studio for the first time. Alternatively, you can also go to Object Explorer > Connect > Database Engine.
ii. Then, in the Connect to Server window, input the following information-
Server Type- Here, you need to enter the database engine
Server Name- Enter the name of the Azure SQL Database or Azure Managed Instance you want to use.
Authentication- Enter the SQL Server Authentication
Login- Enter the user ID for the server account.
Password- Enter the password for the server account.
iii. Once you've filled all the required fields, click on Connect.
If the firewall settings aren't configured, a popup occurs to do so. Provide the Azure account login credentials once you've signed in. After that, click OK.
iv. Select and browse Object Explorer for the hostname, SQL Server version, and username to see whether your Azure Database connection is successful.
