Can be caused by the SQL server browser service being disabled. Set to automatic and start the service. Restart the ‘add connection’ wizard from Visual studio and the local SQL server host and databases should be discoverable again.
Named pipes / Connectivity error. Cannot see SQL server connection or databases from Visual studio 2008