Hi anonymous user,
Per my research, This issue:"A transport-level error has occurred when receiving results from the server." occurs if the application can't connect to the server. You could try the following steps to troubleshooting.
1.Make sure that TCP/IP is enabled as a client protocol on the application server.
2.Check the application's connection string to make sure it's configured correctly.
3.Try increasing the connection timeout value.
4.Test the connectivity between the application server and the Azure SQL Database by using SQL Server management Studio (SSMS), a UDL file, ping, or telnet.
5.As a best practice, make sure that the retry logic is in place.
For Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues#steps-to-fix-common-connection-issues
And to solve this error:"A failure was reported when trying to invoke a service application: EndpointFailure". You could try to create a new Application.
IIS Manager > right click SharePoint Web Services > add application... > copy the full id in the url and add it in Alias > "C:\Program Files\Microsoft Office Servers\15.0\WebServices\SearchService" in Physical path
For more detials:
https://gai3kannan.wordpress.com/2015/04/15/a-failure-was-reported-when-trying-to-invoke-a-service-application-endpointfailure-solution-step-by-step/
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.