Step 3 (Azure): Permissioning Blendo to Windows Azure MS SQL Server

This guide considers that you already have a Windows Azure MS SQL Server setup. If not you can read how to setup a Windows Azure MS SQL Server Database.

Permissioning Blendo: To ensure Blendo will have access to your Windows Azure MS SQL server, please make sure to whitelist and allow connection from the following IP addresses: 52.18.126.160/32, and 52.213.36.20/32
For more instructions, please continue bellow.

Permissioning Blendo to Windows Azure MS SQL Server

Let’s see how to setup Windows Azure SQL Server permissions to allow Blendo to write into your instance.

1> At the Azure Portal, click on All Resources on the left sidebar. In the new window, start typing the name of the server we created before (i.e., gandalfxero). From the filtered results click the server called “gandalfxero”.Azure Portal

2> Click on Firewall on the window on your right side.Azure SQL Server Firewall Rule

3> Type a rule name eg Blendo_1, at START IP box type 52.18.126.160. Put the same at END IP (Or you can put a range of addresses).

Azure SQL Server Firewall Rule

4> Click Save to create the rule.

5> Let’s create rules for the rest of the IP addresses. Repeat steps 3,4 for the following IP addresses. Please, use a different rule name for each (i.e Blendo_2, Blendo_3):

  • 52.213.36.20

6> Click Save to create the rule.

Next Steps:

With Azure MS SQL Server permissions done, Blendo will be able to connect and send your data to the MS SQL instance.

READ NEXT: Step 4 (Azure): How to connect Windows Azure MS SQL Server as Data Warehouse Integration

Questions? Contact us!

in MS SQL Server