To get a case sensitive DISTINCT result, use the COLLATE keyword … 

SELECT
   DISTINCT Column_With_Case_Values COLLATE sql_latin1_general_cp1_cs_as
FROM 
   Case_Insensitive_Table