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 :...