Forum Discussion
Unable to access DB from Azure Virtual Machine using Gateway
Hi. You don't have to skip connection. Otherwise we won't know if that's ok. I looks like there is somethign wrong in configuration you made because it can't get to it. If you force to test connection the gateway won't allow the data source unless it's really ready to do it.
Maybe a recap from this video can help you:
https://www.youtube.com/watch?v=Vlv1tbuZNcM
Regards,
Hi, Ibarrau.
I think configuration doesnt went wrong since i had tried several ways before that. Refer from error details below:
I assume the problem is come from IP address, i had been tried to insert network port test IP address into virtual machine, but the error remains same.
Any more solutions for these?
It's clearly a problem of the VM with the SQL Server. You have to allow remote conections to the server and check if there is something else in the network blocking access. You might need to read about this in microsoft doc or check some youtube videos unless you have a database administrator to ask about it :S
Regards,
Hi ibarrau,
Currently connection issue is solved by insert certain region of Public IP from azure services under this website
https://www.microsoft.com/en-us/download/details.aspx?id=56519&ranMID=24542&ranEAID=je6NUbpObpQ&ranSiteID=je6NUbpObpQ-7gEFFkuxnhi32xtiQ.8Upw&epi=je6NUbpObpQ-7gEFFkuxnhi32xtiQ.8Upw&irgwc=1&OCID=AID2000142_aff_7593_1243925&tduid=%28ir__yv13hbbtrskfqhjikk0sohzz2u2xpuaq1jhps9rc00%29%287593%29%281243925%29%28je6NUbpObpQ-7gEFFkuxnhi32xtiQ.8Upw%29%28%29&irclickid=_yv13hbbtrskfqhjikk0sohzz2u2xpuaq1jhps9rc00
Other than that, is there a way to find certain IP address that my current Power BI server using under certain region?I don't think there is another. You can check urls too if you want:
https://docs.microsoft.com/en-us/power-bi/admin/power-bi-allow-list-urls
Regards,