Let me put my scenario: I have several sql servers that need to be monitored by sqlserver probe. So, the easy way to accomplish this would be through MCS. But, some of these sql servers have more than one sql instance using others ports than not the default (1433).
The question is: does there a way to set more than one connection for the same sql server using MCS ? And about the others that have only the default connection, they would be affected by this configuration ? Or would be a case to not use MCS due the lack of homogeneity ?
Into the sqlserver probe configuration, when you create a connection, you can specify the port you want. You can define that into an MCS profile. Each MCS profile is potentially defining a connection as far as I know, so you can create more than one profile and you should be good to go. The only "problem" is to find a way to organize your servers in proper groups if you want to use group profiles rather than device profiles.