Anyone having success with SQL Server integration where multiple instances reside on the host?

[dpsnedd]

Hi there, thanks for taking the time to look at this question.

I'm trying to troubleshoot adding multiple instances on a single host to Datadog's SQL Server integration. The browser service is disabled on our host and we are using a GMSA to run our DataDog agent service. I was able to get the login to work for one host, but I am at a loss as to how I should format the yaml file to allow for multiple instances on the same host.

Additionally, if there is a way to filter or tag each instance so that it shows up on DataDog and there's no question as to which instance it is that would also be great. As it is currently configured I simply see the full host name.

Any help would be appreciated, thanks!

[dpsnedd]

I eventually found that by editing the YAML File you format it as such:

- host: localhost\Instance#1,"Port"
   reported_hostname: "Instance1"
 - host: localhost\Instance#2,"Port"
   reported_hostname: "Instance2"
 - host: localhost\Instance#2,"Port"
   reported_hostname: "Instance3"

I hope this helps someone else with this issue!