Forum Discussion

tryingPowerBI's avatar
tryingPowerBI
Frequent Visitor
9 years ago

Unable to connect to SQL server

Hello, does anyone have the same issue before?   I was trying to connect SQL server, called it server A and server B.  I can connect both servers on other apps, and I have no problems to get datab...
Vicky_Song's avatar
Vicky_Song
Impactful Individual
9 years ago

tryingPowerBI, 

 

1). Do you try to connect to SQL on Server B via Power BI Desktop or Power BI online service?

2). Did you ever tried to connect to that SQL via SSMS on the same machine you have questions?

3). Can you successfully ping Server B IP address?

  • tryingPowerBI's avatar
    tryingPowerBI
    Frequent Visitor
    9 years ago

    Hi, 

     

    I am trying to connect SQL on Server B via Power BI Desktop. 

    I tried to ping the IP address, it was 100% receive. And I could connect SQL via SSMS on the same machine. 

     

    Anything I can do on it?

     

    Thanks for your help!!!

    • Vicky_Song's avatar
      Vicky_Song
      Impactful Individual
      9 years ago

      tryingPowerBI, your issue seems very strange to me. I'm trying to involve other senior engineers to have a check on it. 

    • Vicky_Song's avatar
      Vicky_Song
      Impactful Individual
      9 years ago

      tryingPowerBI, could you please help to provde the following information?

       

      1. Version of Power Bi
      2. Version of his SQL Server version number as well.
      3. Also see if the user can try to connect through Excel using Power Query, and see if that would work.
      4. Find the SQL ports they are using, the standard is 1433
      5. Capture a Network trace

      Download link for Wireshark

      Wireshark:

      1. Download and install Wireshark from the link above.
      2. Open the application as an Administrator using Right Click > Run as Administrator
      3. Click on Capture > Options at the top

      4. Select the connection that the traffic is processing on.  In my screenshot below, this is Etherne

      5. Click on Start

      6. Recreate the connection and/or refresh issue

      7. As soon as the issue is recreated, come back into Wireshark and click on "Stop"

      8. Save the file by going to File > Save As

       

      Download Link for Message Analyzer

      Steps to capture the network trace:

       

      Message Analyzer:

      1. Download and install Message Analyzer from the above link then open the application as an Administrator using Right Click > Run as Administrator
      2. Click on "New Session"

      3. Click on Live Trace

      4. Ensure that you are using "Localhost" as the Target Computer

      5. Click on Select Scenario

      6. Select "Local Network Interfaces"

      7. Change the Parsing Level to "Network Analysis"

      8. Click on Start

      9. Recreate the connection and/or refresh issue

      10. As soon as the issue is recreated, come back into Message Analyzer and click on "Stop"

      11. Save the file by going to File > Save As

       

       

    • Vicky_Song's avatar
      Vicky_Song
      Impactful Individual
      9 years ago

      tryingPowerBI, do you still need further help for your issue?