0

I'm new to Power BI but I developed reports from SSRS. I'm trying to deploy a report from SSRS (SSDT 17) to a Power BI report server. I see that it created my report and my data source, but I'm getting an error that it connect/find the server: 

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

It's a pretty basic error, but I want to know what are the causes of this error. For context, the server I'm trying to connect is my local machine.

Dustine Tolete
  • 461
  • 1
  • 7
  • 19
  • The report server probably doesn't have access to your local machine. It is a good idea to create a shared data source on the report server and make sure that works before troubleshooting your report. – StevenWhite Jul 25 '18 at 19:34
  • Make sure you have no crash reporting services instance name in one machine. Check if you could access the power bi report server or not . Seems you need to check the aspects which is mentioned in the following links : [provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified](https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8cdc71eb-6929-4ae8-a5a8-c1f461bd61b4/) [A network-related or instance-specific error](https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b43775b9-cd96-4f14-bd1e-b40172c5fc83/) – Mitarai Queen Jan 01 '19 at 06:14

0 Answers0