Different Ways of Connecting to Azure SQL DB from Azure Virtual Machines and Internet

This video explores different ways to connect to Azure SQL and explains different troubleshooting scenarios.

We also discussed about Azure SQL Architecture like Gateways, Data Slices & Traffic Manager. Also, we examined the differences between Proxy and Redirect Connectivity.

We considered the Private DNS Zone, Private virtual network link and DNS records too.

I highly recommend for beginners & for the people who are appearing for interviews.

By Watching this Video you will be able to answer the below interview questions

1) Can you Explain about Azure SQL Architecture?
2) What are the public facing Gateways in Azure SQL?
3) What is the role of traffic Manager in Azure SQL?
4) What are the different connection Policies in Azure SQL?
5) What is the difference between Proxy and Redirect connection Policy?
6) What are the ports that’s needs to be enabled for the redirect connection policy to work as expected?
7) What are the 3 different public network polices that allows you to connect to Azure SQL from Azure Virtual Machines?
8) What firewall would get added when you enable Allow Azure Services and resources to access this server?
9) What will happen when we enable the Service Endpoint for Azure SQL?
10) What needs to be done if you want to Access Azure SQL with the private IP of the Azure virtual machine?
11) What is the importance of Private Endpoint for Azure SQL?
12) Will there be any difference with the results of nslookup command before and after enabling Azure Private End point?
13) What will happen if I delete the DNS record of the private End Point?
14) What will happen if we delete virtual network link of the private end point?
15) What’s the difference between service endpoint and private endpoint?
16) Do you know anything about Azure SQL DB connectivity error 40914?
17) What will you do as a DBA if you are not able to connect to Azure SQL DB?

[kazukikimoto]

This is the best video to learn about Azure SQL connectivity

[gatlaaravind]

All times, we can learn something new with Vamsi.. Thanks for uploading

[KTEXPERTS]

Doing great job Vamsi by sharing the knowledge.

[sudheerratna]

Hi Vamsy, thanks for this video. Appreciate all your efforts.
Could you please help us understand as to how you were able to access SQL DB from VM when there is no explicit firewall rule/vnet rule or exception.
Fyi, this was discussed around 19:53 of this video.

[chaitanyabhoomireddy]

Very nice video and awesome explanation.

[venkatreddy]

can you please share that PowerShell script which you used for troubleshoot the connection issues or share us the link

[mohseenshaikh]

This was really helpful video.
We are stuck at one point.

We have azure api, we want to connect it using private endpoint of sql server.

Api is not able to resolve private ip of sql server because we have api vnet inteigration set on vnet gateway.
We dont want to change it form virtual gateway.

What can we do

[vaibhavwadhai]

If we disable public access and enable private endpoint then which is best connection policy option need to select ?

[vaibhavwadhai]

Can we connect the Azure SQL server if we given access via RBAC role ??

[who]

Hi Vamshi
Have been watching your videos it was a very good learning. could you please tell me when you gonna start new batch on AZURESQL(PASS)so that i could be part of your amazing knowledge transfer

[vaibhavwadhai]

Could you please share the note for this

[vaibhavwadhai]

How we can provide the sql access to end user without RBAC role for Azure SQL server ?

[jeffringeorgejose]

Hi, So instead of accessing the SQL from VM, can I connect from my local machine, if I use a VPN? (Provided the VPN gateway is hosted in Azure, and I have added the Virtual network rule in Sql server for the VNET where the gateway is hosted)