Announcements
One of my users recieved this error when trying to add a record using the application that I built. The user was accessing the application in Chrome. My app uses an Azure SQL server connection.
I've added an exception to my server's firewall that allows PowerApps to access the application. Would I need to add every single IP address that my users use? What would cause this error?
Brendon
Hi @BrendonBrooksP1,
Did you mean that all your users are getting this error?
Please check the following things.
1. Please make sure your database engine is configured to accept remote connections.2. Please make sure that you create an exception on the firewall for the SQL Server instance and port you are using.3. Please check if your SQL server services is up and running properly.4. Please make sure that you enable TCP/IP in SQL Server Configuration
This article could be a reference for you:https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-erro...
Make sure that you have gone throught the below article:
https://powerapps.microsoft.com/en-us/tutorials/connection-azure-sqldatabase/
Best regards,Mona
Turns out, it was caused by an invalid input. The column in question was set to timestamp, when it should have been set to DateTime
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 236 Super User 2026 Season 2
WarrenBelz 207 Most Valuable Professional
Mohsin Ali 169