Hi Team,
I am trying to connect MS SQL Server for building Power Apps. I have SQL server Database which is hosted on the AWS. I tried to add connection to the SQL server hosted on AWS using the Power Apps. But, I got the below error.
{
"error": {
"code": 502,
"source": "india-001.azure-apim.net",
"clientRequestId": "f7ea6b3d-2b04-46cf-8f52-3e369653c5dc",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "Microsoft SQL: A network-related or instance-specific 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: TCP Provider, error: 0 - The wait operation timed out.)\r\nclientRequestId: f7ea6b3d-2b04-46cf-8f52-3e369653c5dc",
"error": {
"message": "Microsoft SQL: A network-related or instance-specific 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: TCP Provider, error: 0 - The wait operation timed out.)"
},
"source": "sql-ci.azconn-ci.p.azurewebsites.net"
}
}
}
Session ID: bee67d61-ddc3-4d43-8832-78b7ca1df39c
I supplied all the required information.
SQL Server Name :- The private IP Address to my AWS machine where the SQL server is hosted.
SQL Database Name :- Name of my DB
UserName and PWD
Could you help me with this.
