Microsoft Azure SQL Database

Connecting to Microsoft Azure SQL database.

This tutorial shows you how to create and configure an SQL cloud database for your Microsoft Azure account, construct firewall rules for it, and how to connect it with API Express.

The first step is to create a Microsoft Azure account if you don't have one already.

Creating Microsoft Azure Account

  1. Open the link https://portal.azure.com. Log in with your account credentials; if you do not have it you will need to create one.
  2. In order to create a cloud SQL database, on the left panel click : New > Data + Storage > SQL Database.
  3. In the pop-up list, fill in the required fields with your parameters. Start with the DB name then configure the required Server settings.
  4. Click on Create a new server in the pop-up list and enter the new server name (you can also select an existing server). Add an admin login and password, then choose the server location. Finally, click OK.

🚧

Server name

Remember the full name of the server you have just created as you will need it later for configuring the Appery.io API Express database connection.

  1. To create and configure a database click Select Source, and then check Sample* .
  2. After, clicking Select Sample choose AdventureWorksLT [V12], click Create. Within a few minutes your server database will be created.

How To Configure Firewall Rules

Please follow the steps in Exposing Your Database to API Express.

👍

Database created

After a few minutes your rules will have been applied, and you will have successfully created/setup a Microsoft Azure SQL server and a SQL database in the Microsoft Manuals.

Creating API Express database connection

    1. Please login to your account
  1. Go to the API Express tab in the Visual App Builder and click Create new DB Connection. Fill in all of the required information and enter the name.
  2. In the next window, add your Database connection name, selected the SGL Server as Database Type, and add the Host.

📘

Host

The host is the name, which you created above: your_server_name.database.windows.net

  1. Define the Port 1433, Database Name, Username and password. This is for your Microsoft Azure SQL Database, which you created earlier and click Save.

📘

Ports

1433 is the default port for Microsoft Azure SQL DB Server

  1. To ensure that the connection from the API Express can access your Microsoft Azure SQL database click Test.