Walkthrough: Connecting to SQL Azure via the SSMS (2024)

In this task you will learn how to connection to SQL Azure using SQL Server Management Studio (SSMS).

To connect to SQL Azure with SQL Server Management Studio:

1. Open SQL Server Management Studio. You will be presented with a logon dialog.

   

2. Replace "server_name" with your assigned server. In the Login field replace "user" with the database master, following by the "@" symbol, and again replace "server_name" with your assigned server.

3. Press Connect. Probably the following error will occur.

   

   See Also

   Create, load, or edit a query in Excel (Power Query)

4. Click OK and after that press the Cancel of the LogOn dialog.

   

5. Click the New Query action in the SSMS toolbar.

   

6. Again, you will be presented with a logon dialog.

   

7. Press the Options button. Enter SofiaCarRental for a name of the database for the connection.

   

8. Press Connect. If all parameters (login, password and server name) you should successfully connect to your SQL Azure instance.

   

In this task you connected successfully to the SofiaCarRental database on your SQL Azure instance. However the SofiaCarRental database is still empty (it contains no tables and no records). The next step is to migrate (upload) the SofiaCarRental database from the SQL Server to SQL Azure.

See Also

• Walkthrough: Migrating SofiaCarRental Database to SQL Azure
• Walkthrough: Creating model
• Walkthrough: Preparing SQL Azure Account and Empty Database