Unable to Connect to SQL Server

Question

Hello,&nbsp;I'm using Power BI desktop Aug 2016 release.&nbsp;&nbsp;From my laptop: I am able to connect to my SQL server (11.0.6020.0) from SSMS 2016. But I'm unable to connect to the same SQL server using Power BI even though I changed the timeout setting to 10 mins. This is the error message that I'm getting:&nbsp;Any help will be greatly appreciated.&nbsp;&nbsp;&nbsp;

ankitpatira · Answer

Anonymous&nbsp;Have you tried using options such as IP address instead of name to connect.

bhaveshpatel · Answer

Hi&nbsp;Anonymous&nbsp;This link will help you to troubsheoot the error occured in SQL Server connection to the PBI.&nbsp;https://technet.microsoft.com/en-us/library/ms190181(v=sql.105).aspx&nbsp;Thanks &amp; Regards,Bhavesh

v-haibl-msft · Answer

Anonymous&nbsp;Maybe you can enable tracing in Options – Diagnostics, and then reproduce the issue in Power BI Desktop to create and collect new trace files.&nbsp;There may be some useful information in them. You can take a look at this document.&nbsp;Best Regards,Herbert

anonymous · Answer

Thanks for your reply ankitpatira. Yes i'm using IP address and getting the error. Using the IP address in SSMS 2016 connects to the SQL server without any issue.&nbsp;

anonymous · Answer

&nbsp;v-haibl-msft&nbsp;Thanks for the great advice. I did just that and have attached the&nbsp;Error log&nbsp;here. I can't seem to find further clues. Any help from anyone would be greatly appreciated. Many thanks!&nbsp;

Forum Discussion

Unable to Connect to SQL Server

7 Replies

Related content

Can't Connect Fabric Core MCP Server

Unable to Connect to SQL Server

Unable to connect to SAP Table Application Server

Unable to Connect to Analysis Services from Power BI Report Server

Unable to connect SQL Server Database with Power Query