I look for installing an sql server express. I check some post/tuto and saw that I need to enable tcp/ip, but did I need to do something with the firewall even if the database is only use on lan.

maybe it depend of my firewall.

  • This question is really hard to follow, so we have two choices: We can work on cleaning it up (at which point it sounds like it should goto Super User) or we can close it. Help us help you ...
    – jcolebrand
    Nov 17 '11 at 20:14

Also, when you enabled TCP/IP did you make sure to restart SQL Server? Did you run netstat -a from the command prompt to see what ports where listening?

You can force express to listen to a specific IP address by disabling dynamic ports in SQL Server Configuration Manager.



Make sure that ports 1433 and 1434 are not blocked, and you should be fine.

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.