I have used Idera since its version 6.0 and its spot on. many configurable options and query monitor is a key along side reporting side of it. if you have...

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...