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

The Requested Operation is Invalid: Server Response: Microsoft SQL: A Network -related or instance-Spectific Error...Inner Exception

I am intermittently getting an error very occasionally as I edit applications. Interestingly, it almost always presents when I first load up the app to edit it. the error is (currently) as follows:

 

The requested operation is invalid. Server Response: Microsoft SQL: A network-related or instance-specfic error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 ... And repeats the error again)

 

Previously, I was seeing a similar error, but the inner exception was that the Handshake timed out. 

 

The change we made was to make the the connection cloud based instead of using the on prem gateway.

 

Refreshing the application solves the issue, which makes me think that the initial connection process is slow and causing this error. is there anything that can be done to eliminate this error, or is anyone else seeing this? end users also experience this. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
loviedo27
Level: Powered On

Re: The Requested Operation is Invalid: Server Response: Microsoft SQL: A Network -related or instance-Spectific Error...Inner Exception

The issue we had here was that PowerApps was having to wind its way to our data. Our on Prem gateway was set up on a base server where most of our data resides, however this application's data is stored on a more sensitive server for HR reasons. 

 

The solution was to create a new on prem gateway on the same server as the data resides and the app reduced latency and ceased to have time out issues. 

View solution in original post

2 REPLIES 2
Microsoft v-siky-msft
Microsoft

Re: The Requested Operation is Invalid: Server Response: Microsoft SQL: A Network -related or instance-Spectific Error...Inner Exception

Hi @loviedo27 ,

 

Could you share more detail with you connection of your Apps? That looks somethings wrong with SQL connections of Apps.

Could you follow the steps and check if your issue is fixed?

1. Remove all possible sql conections, which are linked to the app. Take care. The SQL Connection should all be deleted. Sometimes the System hangs and does not clear a sql connection.
2. Uninstall On-premises data gateway,
3. After this step, take a little break. Maybe the background needs some time.
4. Clear Browser cache, re-install the gateway, add the connection threw the Power Apps Portal (View/Connection/Add Connection).

5. Create a new canvas app, turn off these feature below, connect to SQL database and check if your issue still remain.

Snipaste_2019-12-06_13-53-17.png

Best regards.

Sik

loviedo27
Level: Powered On

Re: The Requested Operation is Invalid: Server Response: Microsoft SQL: A Network -related or instance-Spectific Error...Inner Exception

The issue we had here was that PowerApps was having to wind its way to our data. Our on Prem gateway was set up on a base server where most of our data resides, however this application's data is stored on a more sensitive server for HR reasons. 

 

The solution was to create a new on prem gateway on the same server as the data resides and the app reduced latency and ceased to have time out issues. 

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,069)