Sql-server – sql server firewall

sql-server-2008

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.

Best Answer

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.

[http://msdn.microsoft.com/en-us/library/ms177440.aspx][1]

Related Question