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?

1 Answer 1


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.

  • +1: This is exactly want I looked for! Thanks @Tex !!
    – mico
    Aug 5, 2011 at 10:37
  • They even give you a batchfile to set up all the ports.
    – surfasb
    Aug 5, 2011 at 15:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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