O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using SQL Server Management Studio

Because SQL Database supports the same Tabular Data Stream (TDS) protocol as standard SQL Server, you can connect to your new server using its hostname (or any alias you may have created) in the usual manner, as shown in Figure 52.7. Although you can enable the Encrypt Connection option on the Connection Properties screen of SSMS’s connection options dialog, it is not necessary to do so, as Azure encrypts the connection automatically.

Image

FIGURE 52.7 Connecting to SQL Database using SSMS.

When you’ve connected to your server, view it using Object Explorer and expand the databases node. As you can see, a few things ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required