I have an App with SQL as datasource. App was working fine till yesterday, today morning I see 'An error occured on the server'. I tried refreshing the datasources but still see the same issue. Can someone help me understand what the issue is?
Is the SQL server in Azure or On-premises? If its on-Premises check the Gateway to make sure its still communicating correctly.
Have you tried creating a new PowerApp quickly to test the connection? Does it also fail? Can you access the SQL database in Azure or with SQL Management Studio?
The only other suggestion I would have would be to remove the connection and recreate it. I know that can be a fair amount of work so its a last resort, but its the only other idea I have.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.