Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

vids08

Unnable to connect to SQL Server 2012

Submitted by on ‎09-22-2017 06:18 AM

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)"

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎09-24-2017 11:52 PM

Hi @vids08,

 

Which action did you perform then the error throws out? In Power BI desktop, get data from SQL database, or In Power BI service create a SQL data source under Manage Gateways? 

 

In your scenario, please make sure connection string is correct. Also make sure you are able to ping the physical server where SQL Server is installed from the client machine (machine has Power BI desktop or on-premise data gateway installed). Make sure firewall configured correctly. For details, follow this article: https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-erro...

 

Best Regards,
Qiuyun Yu 

 

 

Idea Statuses