Hello @Newbie ,
To access Sql Azure in the azure cloud, you need to provide public access from the internet.
Did you look at these firewall settings?
Keep in mind that if you are able to access the database, the whole world can access it. Only eg. the credentials and IP filtering keeps your database secure.
Three alternative ways are:
- Hiding your database behind a Rest API (eg. an Azure Function with HTPPTrigger (secured over HTTPS))
- A more elaborate roundtrip where your device sends a request in a telemetry message and the response is sent eg in a direct method
- Sql Azure support for a virtual network
The second solution could be challenging but you make use of the single secure channel which is already setup by the IoT edge.
@AshokPeddakotla-MSFT Im refering to Azure SQL Database. I want to querry Azure SQL Database within iot edge module running on raspberry with pyodbc