Named Pipes Provider: Could not open a connection to SQL Server
You need to enable Named Pipes:
Open SQL Configuration Manager -> SQL Server Network Configuration -> Protocols -> Named Pipes -> Right-click -> Restart
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Use proper server and instance names (you need to determine both) for example
Also check if TCP/IP connection is enabled:
Open SQL Configuration Manager -> SQL Server Network Configuration -> Protocols -> TCP/IP -> Right-click -> Restart
Check if firewall is blocking a connection on port 1433.