Creating the Azure SQL Server

  1. Log in to the Azure portal at https://Portal.Azure.com.
  2. In the resources tab, click the + New icon.
  3. Select Databases and choose SQL Database, as shown in the following screenshot:

The SQL Database blade appears as follows:

Assign the following properties, shown in the preceding screenshot:

  • Database name: ADFV2Book.
  • Subscription: Should already be populated with the active subscription.
  • Resource group: ADFV2Book.
  • Select source: Blank database, we'll attach one later using the BACPAC downloaded in a previous step.
  • Server: Click on Create a new server:
    • Server name: adfv2book
    • Server admin login: ADFV2User
    • Password: pwADFBook!

Click on Select at the bottom of the blade.

Select Pin to dashboard and click on Create at the bottom of the SQL Database blade.

We are directed to the dashboard and see that the database is deploying, as shown in the following screenshot:

Once the database in created, we need to access it. There is a tool available, the query editor. On the left side of the blade, there's a link to it. Clicking on it brings up the login blade. When we enter the password for ADFV2User, we get the query editor, as shown in the following screenshot:

Our database server and our database are created; we are now ready to attach a sample database to it.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset