SQL 2008 : Enable TCP/IP

After installing, we need to enable TCP/IP so external machines can access SQL...

1. run SQL Server Configuration manager

2. select SQL Server Network Configuration

3. select Protocols for 'instancename'

4. right click on TCP/IP and select 'enable'