As far as I am aware CMS only allows you to query/register servers with windows authentication. however, have you tried linked server.

alternatively, I have used SSIS to create a global temp table (##table) that way you can use it throughout the scope of SSIS and dump final results into a single database or CSV