SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904)

i had the same issue.
go to Sql Server Configuration management->SQL Server network config->protocols for ‘servername’ and check named pipes is enabled.