Forum Discussion

ARAFATH's avatar
ARAFATH
New Member
2 years ago

Power BI Desktop to SQL Server connection Error

Please help me to resolve the below issue

I am getting follwoing error when try to connect to MS SQL 

Conncetion detail 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ARAFATH 

     

    You can try the following to troubleshoot:

     

    • Ensure that the SQL Server service is running on the host computer. You can check this using SQL Server Configuration Manager or the Services application in Windows.
    • Ensure that the computer on which Power BI Desktop is installed can communicate with SQL Server over the network. This can be tested by pinging SQL Server from the command line.
    • Verify that the correct authentication method is being used (Windows or SQL Server authentication) and that the credentials are correct. If you are using Windows authentication, ensure that Power BI Desktop is running under a user account that has access to SQL Server.
    • Verify that the firewall on the SQL Server machine allows SQL Server to listen for incoming connections on the port (TCP/IP connections default to 1433).

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • ARAFATH's avatar
      ARAFATH
      New Member
      2 years ago

      Thanks for the reply .Point 1 & 2 are ok.3and 4 need to check .Who can check this from IT department?