Forum Discussion

itays's avatar
itays
Regular Visitor
2 years ago
Solved

Connecting to a remote SQL Server using the DirectQuery method

Hi, I have a SQL Server database running on some server on the network. I have another machine on the same network which runs the gateway to that SQL Server database and it functions correctly. I'm...
Tutorial Requests
  • ToddChitt's avatar
    ToddChitt
    2 years ago

    Your original post indicated that when designing a Power BI model that was to connect to SQL Server, you got an error stating that it could not find that SQL server on the network. You are desiggning from you LOCAL MACHINE correct? Does that LOCAL MACHINE have the ability to connect to the SQL Server?

itays's avatar
itays
Regular Visitor
2 years ago

Obviously I do have the credentials (I did manage to set up the gateway which requires db authentication). As I mentioned before: There is no appropriate place to provide the db credentials as well as choosing to connect to the gateway. What I'm asking is if there is a way to connect to a SQL Server which is NOT on my local machine?

ToddChitt's avatar
ToddChitt
Super User
2 years ago

The error in the orgininal post indicated that Power BI could not find the SQL Server. Let's start there. Can you connect to that SQL instance via SSMS or some other SQL client FROM YOUR LOCAL MACHINE?

  • itays's avatar
    itays
    Regular Visitor
    2 years ago

    Yes, from my local machine I can connect with a SQL Server client by providing a Username and Passsword

     

    • ToddChitt's avatar
      ToddChitt
      Super User
      2 years ago

      RDP as in Remote Desktop. No, doesn't count. I need you to verify that your LOCAL MACHINE can make a SQL Connection to that server. Do you have SSMS installed locally?

      • itays's avatar
        itays
        Regular Visitor
        2 years ago

        The machine which has the gateway installed on it has a SSMS client and can connect to the db machine.