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.
