We have a SQL Server in a remote location. If we access the server from the same location (internal IP, same IP as the server is using) the performance is good. We don't face any problem with connectivity.
But whenever we try to connect from a remote client (public IP) we are faced with a timeout error.
I have made an
etc/host entry for the server.
What might be the reasons for such problems?
I have connected via ODBC in Management Studio. The connection has been established. I am facing the problem only when executing queries (any query).