SELECT a.Street_No, a.Street_Name, a.City, a.Postal_Code, AS ProvinceName, AS DealerName, d.phone1 as DealerPhone, d.twitter FROM dbo.tbl_Address AS a INNER JOIN dbo.tbl_dealer AS d ON a.Address_ID = d.address_id LEFT OUTER JOIN dbo.tbl_prov AS p ON a.Province_ID = p.prov_ID where d.Dealer_ID=366A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)