Select Inventory.*,tbl_dealer.Default_Make_Name, tbl_dealer.IsManufacturerCertified,
                        tbl_dealer.Hide_Demos_In_New_Inventory
                        from Inventory inner join tbl_dealer on inventory.DealerId = tbl_dealer.dealer_ID
                        where inventoryid = 'd866d11c-2607-4610-80f4-9cb6a64e102e'A 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)