Forum Discussion

DanB's avatar
DanB
Icon for Advisor rankAdvisor
5 years ago

Is it possible to have two collector instances on one box?

I was wondering is it possible to have 2 collector instances running on the same box? Asking this b/c monitoring SQL Server requires the collector to be running as the actual Windows User that has ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Ah, ok, I think see. You have certain devices monitored by the collector, Collector01, which is running with credentials that won't work for those devices. So you'd like to move the work of collection onto another Collector instance that is running with different credentials required to monitor those devices. 

    If that's an accurate understanding: the short answer is still no. You can't have two collectors running on the same box because they'd both try to bind to the same TCP ports for receiving data in response to queries. The answer would be to spin up a VM (either on Collector01 or, if Collector01 is a VM, on the same host as Collector01). This would give each collector the ability to run with different credentials and each would have their own TCP/IP stack to which they could bind listeners.

DanB's avatar
DanB
Icon for Advisor rankAdvisor
5 years ago

Hi Stu, No let me clarify.  We have Collector01 running and it's monitoring a SQL Box (say SQL001) We have specific AD creds that were created for monitoring this client environment and those creds are specified via the wmi.user\pass properties.
The jdbc.user\pass properties are also set using the SQL Specific AD user but all the SQL metrics are "NoData" We dont' get anything from SQL Datasource. I mean we see the databases in the Resource Tree under SQL001 but everythings is "NoData"

We have a different Windows AD SQL Account that we monitor the SQL DB Boxes with today (using other tool UIM) but its a windows account. According to https://www.logicmonitor.com/support/monitoring/applications-databases/microsoft-sql-server the jdbc.mssql.user cannot be a Windows Account. It can only be a local SQL user w/in the SQL DB. That's is a user we will not get. 

jdbc.mssql.user

jdbc.mssql.pass 		SQL Server username and password. This cannot be a Windows user account. This account must have the minimum SQL Server permissions described in the previous Provide Credentials section of this support article.


So in order to monitor the SQL Boxes we need the collector service running as the SQL AD User that has access to the SQL DB's.

I was asking on the collector box that we have today if we can run a 2nd instance on the same existing Collector01 box, and have that 2nd instance run as the SQL AD User and we throw all the SQL Boxes under that 2nd Collector instance
That is the issue we found with the SQL Datasource. The LM Collector service has to "Run As" the user that has the access to the SQL DB. We tried specifiying the wmi.user/pass of the SQL User but it didn't work.