Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

My Firewall seems to be blocking the connection from anywhere to my local MS Sql Server on my Windows7 development machine.

On Linux and Mysql I could telnet the database ports and it gives response like any other service that is running in some port. On Windows and MS Sql I could not repeat this task.

Also I could connect Mysql from Glassfish server ping command and Mysql answers with no problems. The Mysql server could be even on that Windows 7 machine. Again, no way to do this at MS Sql.

I am running out of ideas, what could help?

share|improve this question
up vote 2 down vote accepted

Out of the box SQL Server is not configured to allow any remote connection. You need to actively allow this so you can connect to it from the network.

I'm assuming you are using 2008, MSDN has an description to enable remote connections that also includes adding Firewall exceptions if this is really the problem.

share|improve this answer
+1: This is exactly want I looked for! Thanks @Tex !! – mico Aug 5 '11 at 10:37
You're welcome. – Tex Hex Aug 5 '11 at 10:47
They even give you a batchfile to set up all the ports. – surfasb Aug 5 '11 at 15:54

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.