*!! Also do not forget to make the PORT change in the Windows Firewall for the service (in case you have your firewall turned on).*
Click on Start button in Windows. Go to All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager Click on SQL Server Network Configuration -> Protocols for [SQL Server Instance Name] -> TCP/IP double click ( Right click select Properties ) on TCP/IP.