Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Our company has recently acquired another firm and are in the process of adding them to our network. The new firm has Power BI reports that use on-premises SQL Server datasources that use a SQL Login. I can connect to the data with Power BI desktop (and SQL Server Management Studio), but cannot create a connection in the service so the reports can use one of our Gateways.
error message below:
Hi, @duncfair
This error means that the client can't find the SQL Server instance. This can happen when at least one of the following problems exists:
To learn more detail solution ,refer:
A network-related or instance-specific error occurred - SQL Server | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It was our corporate firewall.
Hi @duncfair
Is it possible to try and connect via the IP Address and see if that work successfully? It looks to be an issue with the named pipes connection?
Network Firewall.
Thanks, but definitely not a named pipes issue, as that would negate the possibility of connecting via SQL server Management Studio (and Power BI desktop, I suspect).
It appears to be a networking issue. The network techs have been notified and I will post the results of that investigation here when complete.