Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Gateway not working though ODBC does

Hi, 

I have installed a gateway on one subnet which needs to access a SQL server in another subnet. As a test I created an odbc connection from the gateway server to the SQL server and it works just fine. However, when trying to use the gateway with PowerBI online, it fails. I have received this message:

Received error payload from gateway service with ID 275505: SqlException encountered while accessing the target data source.

Where can I see any logs that will help me determine what the issue is? 
Thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    The issue was firewall related. Thank you lbendlin  for suggesting trying SMSS. That showed me that just because 1433 was accessible did not mean I could connect to the database.

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      ODBC was just a test to make sure I could reach the SQL server from the gateway.

      Using the gateway, the connection to the sql server fails.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      no, it does not actually, just tried that. Remote connections are allowed. It is not a named instance. I can telnet using the port from the gateway server. What else can I check? I have permissions to the db.

      Thanks for you help.

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        Does SSMS give you any sort of error message?