How to setup Azure on-prem Data Gateway

[@arvinddas1968]

Explained in a very simplified form, thanks for sharing.

[@arvinddas1968]

I think challenges would be around creating user in azure active directory and mapping with on-prem SQL server, it would be great if you share some pointers here for further study.

[@ozappbuilder9412]

Hi Arvind. In this case, you just need to join your database server to AD domain and instead of using a local account, create an AD user and add it to sql users.

[@WoodyDataAI]

Thank very very much! Very good video. You explained the whole story clearly.

[@ozappbuilder9412]

Glad it was helpful!

[@chrislupton7521]

Hi, great video but I'm having issues validating my SQL Server credentials. The AD profile the SQL server is using is linked to my domain admin account, does it need to be a local user profile? Edit; created a local sql server profile and used that, got it working. Brilliant tutorial, thanks!

[@khajamiyaputnala8180]

Thank you so much for the clear explanation.

[@ozappbuilder9412]

Glad it was helpful!

[@chaitanyakuppili6337]

How can i insert data to on prem sql from json format using logic app

[@sushilvisual]

Very helpful

[@yanivsudai9944]

i just don't understant what is the diffarance between regular vpn site to site and that thing iam just learning az 305

[@cloudtech273]

Can I use Azure Relay to achieve the same ? Azure Relay is much simpler (at least on-paper !)

[@ozappbuilder9412]

Different use cases, different solutions but accessing local db is recommended through ADG

[@user-lk6zl3bb4v]

my mail is not working

[@BijouBakson]

Get some rest, when you are ready for the world, then you may record your video and post it on a public forum that can be viewed worldwide over and over and over for as long as KZbin is relevant. This video could be done in less than 5 minutes if you prepared it. You sound both tired and bored. Thank you for your effort regardless.

[@shreeshavitthala6507]

The video helped me but your voice is too low and the video is too slow