Forum Discussion
How to use Power BI gateway
I want to use Power BI gateway to connect to an on premise SQL server, which is located on another computer. I want to access this database in Power BI desktop on my local machine. I have install...
I can ping the IP address and the SQL server address, but can not connect in Power BI.
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)"
nandukrishnavs
Community Champion
Community ChampionAnonymous
Refer to this documentation: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15