Be sure you have added your Azure SQL database to Microsoft SQL Server Management Studio.
From the HCO for SQL Server interface, click
Manage Connections.
On the
Connection List tab, select the
Azure Connection Type.
From the
Connection List tab, click
New SQL Server Connection.
You must provide the appropriate user ID and password for your Azure server to make the connection.
On the
SQL Server Connection tab, type an appropriate Azure user ID into the
User ID field as follows:
userID@serverName
Type the accompanying Azure password into the
Password field.
In the
SQL Server Instance field, type your Azure server name as follows:
tcp:serverName.database.windows.net
Click
Confirm Server. This populates the
Database drop-down list with available Azure SQL Databases.
If you want to use a database other than the default database, check
Use a database other than the default database:
dbname, and then select an alternative database from the
Database drop-down list.
Click
Test to verify the connection details.
When the connection tests successfully, click
OK to clear the message.
Click
Save.
The new connection appears on the
Connections List located on the
Connections List tab.