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...
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.

lbendlin's avatar
lbendlin
Super User
3 years ago

does it work from SSMS on the gateway VM?

 

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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I spoke with networking and I think it is a firewall issue where althought 1433 is allowed, there is an application rule which was not applied. I will let you know the results.

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        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.