cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mapembert
New Member

connection attempt failed.... did not properly respond after a period of time

Hello forum!

 

Came across PowerApps yesterday and wanted to connect to our enterprise system in MS Azure instance running DB2. My connection is successful but it fails to load the tables. I suspect the timeout is due to the fact that our enterprise system has nearly 1000 tables.  Is there a way to increase the timeout time or manually add 1 table? I know the schema and table name of course.

 

This is the full error message:

 

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond NNN.NNN.NN.NNN:50006 SQLSTATE=08S01 SQLCODE=-1037
inner exception: Microsoft Db2 Client: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond NNN.NNN.NN.NNN:50006 SQLSTATE=08S01 SQLCODE=-1037
clientRequestId: 1c39a92f-41e2-49e3-99e8-92186843ad45

Session ID: 9bfecc14-b0aa-4a3a-9ae5-42540f91a163

3 REPLIES 3
v-monli-msft
Community Support
Community Support

Hi @mapembert ,

 

Firstly follow the troubleshooting steps listed in below documentation:

https://azure.microsoft.com/pt-br/blog/sql-azure-connectivity-troubleshooting-guide/ 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you! We can connect to DB2 remotely using the connection parameters but I will try these steps as close as I can to see if anything else applies. We use DB2 and not SQL Server so not everything will apply.

@v-monli-msft , Mona, Looks like all the suggestions are in place. 

Any suggestions on how I can get more details, add tables manually, or give the discover of tables more time?

Mike

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (4,373)