cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
papp
Level: Powered On

An error occurred on the server - SQL connection

Hi,

 

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?

 

 

Thanks!

6 REPLIES 6
Dual Super User
Dual Super User

Re: An error occurred on the server - SQL connection

Is the SQL server in Azure or On-premises?  If its on-Premises check the Gateway to make sure its still communicating correctly.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
papp
Level: Powered On

Re: An error occurred on the server - SQL connection

Hi Pstork1,

 

It is Azure SQL server.

Dual Super User
Dual Super User

Re: An error occurred on the server - SQL connection

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?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
papp
Level: Powered On

Re: An error occurred on the server - SQL connection

I am able to create a powerApp with same connection. Also, I am able to connect using SSMS.

Dual Super User
Dual Super User

Re: An error occurred on the server - SQL connection

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
papp
Level: Powered On

Re: An error occurred on the server - SQL connection

I re-created the connections but no luck 😞 Let me recreate the app.

 

 

Thanks!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 409 members 5,996 guests
Please welcome our newest community members: