Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

820


Part V: Enterprise Data Management


FIGURE 31-12
Defi ning a New Connection in the Connection Manager for SQL Database.


  1. In the Connection Manager dialog, enter the server name of your SQL Database
    server, select Use SQL Authentication, and enter your SQL Database username and
    password. The username must be in the format username@server where username
    is your Administrator username or a valid SQL Database username and server is the
    fi rst part of the server name (the piece prior to .database.windows.net).

  2. In the Select or Enter a Database Name fi eld, select the AWMini database from the
    list of databases.

  3. Click the Test Connection button. If you correctly entered everything and your fi re-
    wall is set up, your test connection succeeds.

  4. Click OK in the Connection Manager dialog and then click OK on the OLE DB
    Connection Manager dialog.


c31.indd 820c31.indd 820 7/31/2012 10:00:29 AM7/31/2012 10:00:29 AM


http://www.it-ebooks.info
Free download pdf