During installation of SQL Server 2008 R2, we were not able to connect to the SQL database server from the client PC. The error that we would receive is posted in the screenshot below.
After much research we came across this post which was very helpful. There a few things to look for in the Management Studio and Configuration Manager on the SQL server and this post covers all of the them. Very helpful. Thanks to Daniel_Wazenbach.
Please check the post at: http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx?PageIndex=2&CommentPosted=true#commentmessage