Q98. How to connect SQL Database instance with SQL Server Management Studio?
Follow these steps to connect to your SQL Database instance using SQL Server Management Studio:
Open SQL Server Management Studio and enter the values for the following .
Server name: You need to enter a fully qualified server name of the SQL Database server. Refer Figure. This is a fully qualified server name and is located in the properties pane in the same screen.
Authentication. Select SQL Server Authentication.
Login. Type the administrator username (created previously).
Password. Type the password of the administrator account.
Click on Connect. A new query window opens, and you can execute T-SQL commands against your SQL Database instance. If you open the Object Explorer, the structure of the database can be seen. You will observe that the structure of the tables is similar to tables in on-premise SQL Server.
Open SQL Server Management Studio and enter the values for the following .
Server name: You need to enter a fully qualified server name of the SQL Database server. Refer Figure. This is a fully qualified server name and is located in the properties pane in the same screen.
Authentication. Select SQL Server Authentication.
Login. Type the administrator username (created previously).
Password. Type the password of the administrator account.
Click on Connect. A new query window opens, and you can execute T-SQL commands against your SQL Database instance. If you open the Object Explorer, the structure of the database can be seen. You will observe that the structure of the tables is similar to tables in on-premise SQL Server.

See More Questions and Answers on - Azure SQL Server
- Two models of using SQL Server in the cloud
- Choose between SQL Server in vm and sql database
- How to access data in Azure sql databas
- Create and configure SQL database server in the cloud
- How to configure the SQL database firewall
- How to connect to a SQL database with ado.net
- Build a Azure application that works with SQL database
- Connect to Azure sql database using the ado.net entity framework