Understanding the Azure SQL login fields
In this article, we explain what each Azure SQL login field means and where to find the required credentials when connecting Azure to Dataslayer.
When using the Azure SQL destination in Dataslayer, you need to connect your Azure SQL account to send and store data via queries.
.png?width=670&height=307&name=Azure%20SQL%20-%20Login%20Fields%20(1).png)
To establish this connection, you’ll be prompted to fill out several Azure SQL login fields. This article explains what each field represents and where to find the necessary credentials within your Azure SQL environment.

Required fields for connecting to Azure SQL
Below is a breakdown of the required fields to set up your Azure SQL destination in Dataslayer, including where to find each value:
1. Database
- Where to find it
- Log in to Azure SQL and use the search bar to find SQL server settings.
- Select one of your available servers and then scroll down until you find your SQL database
- Copy the last part after the / in the title of this page and paste it into Dataslayer's connection page


2. Host
-
Where to find it
- In the left menu, go to Settings, and then click on Properties. You'll see the Server name, copy that and pase it the the Host field in Dataslayer

3. User
- Where to find it
- In the same page as host above, you'll see Server admin login, copy that and pase it the the User field in Dataslayer

4. Password
-
This is the same password you used to sign in into Azure's portal.

Configuring a Firewall Rule
For the connection to work, your database must accept connections from the IP address 54.155.2.113.
To do so:
-
Go back to your Server
-
Go to Security in the left panel and click on Networking.
-
Scroll down until you see Firewall Rules and click Add a Firewall rule
- Give it a name of your choosing
- Paste 54.155.2.113 in both Start IP and End IP fields


Example Configuration
Here is a sample of a completed configuration:
-
Host:
example-server.database.windows.net -
User:
EXAMPLEUSER -
Password:
pS$hX4MñE.QwRD% -
Database:
MARKETING_AZURE -
Firewall Rule Name:
Dataslayer Connection -
Start IP:
54.155.2.113 - End IP:
54.155.2.113
As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!