I have this same problem - and already did the "accepted solution" (enabled shared pipes and actually turned Windows Firewall off temporarily), but did not fix. I have installed SQL Server 2008 R2 as MSSQLSERVER on the same development computer in a workgroup (not a domain). For this, I will use "computername" as the computer name. I have tried as a database server:
None of these work.