Posted on 29, Nov 2010
Read further details here: Enable remote connections for SQL 2008
Run SQL Server Configuration Manager.
Expand SQL Server 2005 Network Configuration node.
Click Protocols for SQL Express.
Double click TCP/IP. Dialog TCPI/Properties will appear.
Set Enabled=Yes. Click IP Address tab.
Set Active = Yes. Set Enabled = Yes.
Expand SQL Native Client Configuration. Double click TCP/IP to display TCP/IP Properties.
Set Default Port = 1433, Enabled = Yes.
Now is access to SQL Server by TCP/IP enabled.
Next step is to enable Remote Connections.
Run SQL Server Surface Area Configuration.
Click Surface Area Configuration for Services and Connections.
In screen that will appear expand your server, Database Engine, Remote Connections.
Click Local and remote connections.
Choose Using both TCP/IP and named pipes.
SQL Server requires enabled TCP and UDP ports. Run Windows Firewall from Control Panel.
Display Exceptions tab.
Click Add port button. Dialog Add a Port will appear.
Repeat these steps to add UDP port with values: