How to connect to Azure SQL with SSMS and Azure Data Studio!

Steps to connect to Azure SQL via Azure Data Studio and SQL Server Management Studio (SSMS):

Azure Data Studio:

1. Open Azure Data Studio on your PC.

2. Click on the New Connection button or select New Connection from the New dropdown.

3. In the Connection window, provide the following details:

- Connection type: Choose the connection type as SQL server.

- Server: Specify the server name of your Azure SQL. You can find the server name by navigating to the Azure SQL database in the Azure Portal.

- Authentication type: Choose SQL Login as the authentication type.

- Username and Password: Specify the Username and password you specified during the Azure SQL database creation in the Azure Portal.

4. Finally, click on the Connect button.

SQL Server Management Studio (SSMS):

1. Start SQL Server Management Studio (SSMS).

2. The Connect to Server a dialog box appears.

3. Enter the following information:

- Server type: Select Database Engine.

- Server name: Enter the fully qualified server name of your Azure SQL Database or Azure SQL Managed Instance.

- Authentication: Select the appropriate authentication method (SQL Server Authentication or Azure Active Directory).

- Login: Enter the server account user ID.

- Password: Enter the server account password.

4. After you complete all the fields, select Connect.

5. To verify that your Azure SQL Database or Azure SQL Managed Instance connection succeeded, expand and explore the objects within Object Explorer where the server name, the SQL Server version, and the username are displayed.

Please note that you might need to create a new firewall rule if your server doesn't have one allowing Azure Data Studio or SSMS to connect. Also, remember to install Azure Data Studio and SSMS if you haven't done so.