The unit test adapter failed to connect to the data source or to read the data.

When you encounter the error descripted as title during your unit test work, please try to change value of "Copy to Output Directory" property of your datasource file (maybe excel/xml...) to "Copy if newer".

That works to me. Hope it's also helpful for you guys.