Connect SQL Server Management Studio

You can connect SQL Server Management Studio (SSMS) to Azure SQL Database.

Connect SSMS

1. Open SQL Server Management Studio.

   The Connect to Server dialog box appears.

2. In the Server name box, enter the Datastore Server name. Ensure that this value matches the Server name displayed in the Connection String Management dialog box while creating the connection. For more information, see Manage Connection Strings.

3. In the Authentication drop-down list, select the SQL Server Authentication option.

   The dialog box appears.

4. In the Login and Password boxes, enter the user name and password to connect to SSMS. Ensure that this value matches the User Id and Password displayed in the Connection String Management dialog box while creating the connection. For more information, see Manage Connection Strings.

5. Click Options.

6. Click the Connection Properties tab.

   The dialog box appears as follows.

   

7. In the Connect to database box, enter the datastore name. Ensure that this value matches the Database name displayed in the Manage Connection Strings dialog box while creating the connection. For more information, see Manage Connection Strings.

8. Click Connect.

   The connection between SSMS and Azure SQL database is established successfully.