Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I can connect to a remote sql server at home but not in the office. The server where the SQL Server is hosted is a VPS (Arvixe). How can I check if a firewall is making me not able to connect on that server?

share|improve this question
Ask your SysAdmin in the office. :-) – duenni May 15 '13 at 15:02
The first clue it might be a firewall will be the inability to connect. – NickW May 15 '13 at 15:02
up vote 1 down vote accepted

Contact the hosting company. If you set the VPS up from home and did not add your office as a connection site then there definitely should be a firewall blocking you.

share|improve this answer

If it's a firewall, then you will either get a "connection timed out" or "connection refused". Otherwise, the SQL error will say why you can't connect. Usually it's because the user has a restrictive host list and your office IP isn't on the list so it tosses a login failure.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.