Forum Discussion
cant connect to sql server
Details: "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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Ahmedx amitchandak
4 Replies
Your SQL Server configuration may not include the Named Pipes protocol. However, you should normally use TCP/IP anyway.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
Hi Anonymous ,
Based on the error message you provided, this error message indicates a problem with the connection to Microsoft SQL Server. First, make sure that the server name and instance name in the connection string are correct. Second, make sure that SQL Server is running on the server machine. You can check this by opening SQL Server Management Studio and connecting to the server. Then, if there is a firewall between the client and the server, make sure that the necessary ports for SQL Server are open. By default, SQL Server uses port 1433 for TCP/IP connections. You may need to configure your firewall to allow incoming connections on this port.
For more information about linking databases, you can refer to the following documentation
Configure a Windows Firewall for Database Engine Access - SQL Server | Microsoft Learn
A network-related or instance-specific error occurred - SQL Server | Microsoft LearnBest regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
