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

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

ToddChitt's avatar
ToddChitt
Super User
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

    You are right, I tried to connect through my local machine and just now realized the server address im trying to connect to is an organizational IP address. Thanks for the hints, I will take it from here!