This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 60%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Hi is there a way for Azure Machine Learning to be able to perform analytics using data from an on premise SQL Server?
Only found the below article which is for Azure Machine Learning Studio (classic):
https://learn.microsoft.com/en-us/azure/machine-learning/studio/use-data-from-an-on-premises-sql-server
Thanks.
Hello @Conrad Tan
Do you have any feedback on your issue?
Kindly mark any answer that helped you as Accepted and Upvote or post your feedback to provide additional help!
Regards
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 11%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
@conrad Here is the link to connect with the Azure SQL server.
https://stackoverflow.com/questions/61806350/database-communication-link-error-occurded-on-azure-ml-service-used-azure-sql-s/61950481#61950481
@Conrad Tan Just checking to see any update on this.. If an Answer is helpful, please “Accept Answer” or Up-Vote for the same which might be beneficial to other community members reading this thread.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 45%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPY%3C/text%3E%3C/svg%3E)
And for 'on-premises'? (i.e. local SQL)
Light Serviços de Eletricidade
Hello @Conrad Tan
Yes you can do that with On Prem SQL
You need an Azure Data Gateway
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem
You will establish a secure connection with Azure ML
https://www.sqlservercentral.com/blogs/using-azure-machine-learning-with-an-on-premises-database
I hope this helps!
Kindly mark the answer as Accepted and Upvote in case it helped!
Regards