Could not open a connection to SQL Server

This video explains simply how to resolve issue of "provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server"