Forum Discussion

steveelder's avatar
steveelder
New Member
10 years ago

SQL Connection error - Named Pipes

Hi all first time poster , so be easy on me When trying to connect to SQL Server ( all 2008 r2 ) i get the following error messages This is only a problem on my production servers,,, test servers ...
Need Help
steveelder's avatar
steveelder
New Member
10 years ago

Hi Lydia

connecting through SQL management studio works fine

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi steveelder ,

Is SSMS installed in the same server that is running Power BI Desktop?

Thanks,
Lydia Zhang

  • steveelder's avatar
    steveelder
    New Member
    10 years ago

     Power bi desktop is running from a workstation

    SSMS is on the servers, and they can connect to other SQL services ok

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi steveelder,

    In Power BI Desktop, what is the result when specifying “IP address, port” or “tcp:computername” as server name to connect to SQL Server?

    In addition, please set the value of "Command timeout in minutes" to a higher value, also write a custom SQL statement in “SQL statement” and check if the connection is established or not.


    Thanks,
    Lydia Zhang

  • liwei's avatar
    liwei
    Regular Visitor
    9 years ago

    I met the same error: A network-related or instance-specific error occurred while establishing a connection to SQL Server.... when i refresh the dashboard from powerBI, I could access to the server from SSMS also I have succefully refresh once in powerBI, but most of the other times it keeps on fail and error message like this, one thing i should mention is my data is extramly huge, the refresh would take 40 mins at least.