Forum Discussion
Dynamically update Term store values based on SQL Server database updates
Hi, I have a SQL Server database living on a virtual machine hosted in Azure and am trying to connect SharePoint to it so I can dynamically update the term store based on records added to a certain c...
From what I recall when trying to do this, it wasn’t really possible. No connector etc. for powerapps to update the term store.
As for your error it’s most likely a firewall issue. Would have to allow office services to your azure sql server before powerapps is able to talk to it.
As for your error it’s most likely a firewall issue. Would have to allow office services to your azure sql server before powerapps is able to talk to it.
Thank you, ChrisWebbTech (et all) -
"Would have to allow office services to your azure sql server before powerapps is able to talk to it."
How can I accomplish this? We'll want to wire up MS to this SQL DB wherever possible.
Thank you,
Morghan
- It being an sql server and not azure sql database, it might also not have a public endpoint / name configured. I can't recall but it might require an agent just like on-prem etc. if you don't see anything obvious in the firewall settings etc.
mdcastorena should have this in the sql server firewall settings
ChrisWebbTech I am missing this "Set server firewall" setting here when I am in the portal... Why would that be? The second screenshot is one where it does exist in a sample screenshot I found.... Is it because mine is a VM and not a SQL database within Azure?
My screen:
Sample screenshot from the web:
Thank you again for your help!
Morghan
- Basically. You should have a set of azure network functions connecting you're VM's together etc. There should be something in those to allow Azure services in.