You need to follow the given steps which stated in very easy way. In this blog steps for 2008 Version of SQL Server, hope it will be helpful for you also. http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx