Ad Widget

Collapse

New to Zabbix: MSSQL on Windows Monitoring Problem (all pipes are busy)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Rob_NOLA
    Junior Member
    • Apr 2025
    • 2

    #1

    New to Zabbix: MSSQL on Windows Monitoring Problem (all pipes are busy)


    Hello all, I'm brand new to Zabbix and we are installing it to monitor various on-prem equipment. We have a Windows Server with MSSQL installed. When attempting to run the agent, I am getting the following error (via the --print command):

    zabbix_agent2 [13052]: ERROR: Cannot register plugins: failed to remove plugin socket, with path "\\\\.\\pipe\\agent.plugin.sock": CreateFile \\.\pipe\agent.plugin.sock: All pipe instances are busy.

    There are no errors in the Agent2.log file (even with debug level 5 turned on)
    And I'm also not getting any data in the Device > Dashboards > MSSQL Overview graphs (obviously)

    This is what I've done so far:

    1) I am using zabbix 7.0.10

    2) I got the agent from https://cdn.zabbix.com/zabbix/binari...le/7.0/7.0.10/ via MSI

    3) I got the MSSQL plugin from the same link: https://cdn.zabbix.com/zabbix/binari...le/7.0/7.0.10/ , also via the MSI

    4) I added the host in to the webui with the following 2 macros defined:
    • {$MSSQL.CONNSTRING} as Server=localhost;Database=master;User Id=zabbix;Password=password;
    • {$MSSQL.INSTANCE.NAME} as MSSQLSERVER

    5) The zabbix_agent2.conf file has the following settings:
    • Include=C:\Program Files\Zabbix Agent 2\zabbix_agent2.d\
    • ControlSocket=\\.\pipe\agent.sock
    • PluginSocket is currently commented out, as it came. The default is listed as \\.\pipe\agent.plugin.sock

    6) The mssql.conf file exists in C:\Program Files\Zabbix Agent 2\zabbix_agent2.d\ and contains the path definition:
    • Plugins.MSSQL.System.Path=C:\Program Files\Zabbix Agent 2\zabbix-agent2-plugin-mssql.exe

    7) The zabbix-agent2-plugin.mssql.exe file exists in C:\Program Files\Zabbix Agent 2\

    8) I have deleted all of the other plugins that come with the MSI, trying to isolate the issue.

    I've been reading documentation and trying to fix this for 2 days now and can't figure out why the plugin won't load.
    I am receiving normal windows diagnostics from the agent on this server in the webui, just not from the MSSQL plugin.

    Please help


  • bbonno
    Junior Member
    • Apr 2025
    • 22

    #2
    Hmm, I tried comparing your setup to mine, and I think you are using the wrong template on your host.

    This is the documentation for the plugin you are using: those two macros are not in the documentation anywhere!
    https://www.zabbix.com/integrations/mssql (details)
    You should using the template called 'MSSQL by Zabbix agent 2', and define the macros {$MSSQL.URI}, {$MSSQL.USER} and {$MSSQL.PASSWORD}.

    Comment

    • Rob_NOLA
      Junior Member
      • Apr 2025
      • 2

      #3
      You're right, the problem was with the template and the passed macros! I'm not sure how I arrived at my original macros, but directly examining the template, it was obvious what should have been being passed. This was resolved by essentially just starting over with a fresh install of the Agent and the MSSQL plugin, ensuring the correct template, and passing the correct Macros. No other crazy problems...

      Thanks for the help!

      Comment

      Working...