Power Platform Community Forum Thread Details

Hello

I need connect power app whit SQL server but I recibet this error

"Error en la prueba de conexión. Detalles: 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 - TCP Provider: ) inner exception: 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 - TCP Provider: ) clientRequestId: b04cacb0-ef7f-8696-c5c2-545877851b9d"

I used SQL server 20 and door conection

Categories:

Connector development

Check if the SQL Server name is correct. Use ServerName\InstanceName or ServerName,PortNumber.
Ensure SQL Server allows remote connections. Open SQL Server Management Studio, right-click the server name, go to Properties > Connections, and enable "Allow remote connections".
Make sure the firewall allows SQL Server traffic. Open port 1433 in the firewall.
Confirm the On-Premises Data Gateway is online and installed on a machine that can reach the SQL Server.
If you are using Windows Authentication, ensure the Windows user has access to the SQL Server and database.
Open SQL Server Configuration Manager and enable the TCP/IP protocol under SQL Server Network Configuration.
Restart the SQL Server service after making these changes.
Test the connection by running telnet SQLServerName 1433 on the same machine as the gateway.
Double-check the server name, database name, username, and password in Power Apps.