[ZBX-24348] Plugin mysql não conecta em uma instancia nomeada exemplo sqlserver://host\instancia:1433 89 / 5.000 Resultados de tradução Resultado da tradução mssql plugin does not connect to an instance named example sqlserver://host\instance:1433 Created: 2024 Apr 13  Updated: 2025 Feb 12  Resolved: 2025 Feb 12

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent2 plugin (G)
Affects Version/s: 6.4.13
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Eduardo Jordan Prado Assignee: Stanislavs Jurgensons (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Microsoft Windows [Version 10.0.14393] with SQL Server Standard 2019


Issue Links:
Duplicate
duplicates ZBXNEXT-9292 Support of MS SQL Instance name in co... Closed

 Description   

Steps to reproduce:

  1. In File mssql.conf
    1. Plugins.MSSQL.Sessions.SQL2019.Uri=sqlserver://Server\Instance:1433
  2. Configuration Item for zabbix server
    1. mssql.version[SQL2019]

Result:

Failed to evaluate metric parameters: invalid first parameter "URI": parse "sqlserver://Server
Instance:1433": invalid character "
" in host name.

Expected:
Get version of SQL



 Comments   
Comment by Arkadiusz Zyla [ 2024 Apr 15 ]

Looking into the https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16 - please try with double backslashes before instance name, like shown below

Plugins.MSSQL.Sessions.SQL2019.Uri=sqlserver://Server\\Instance:1433
Comment by Eduardo Jordan Prado [ 2024 Apr 15 ]

hi, i try it, but, backslashes are not recognized, returns invalid characters

 

"Plugins.MSSQL.Sessions.SQL2019.Uri=sqlserver://SERVER\ \SQL2019:1433"

Log

2024/04/15 12:40:28.024829 failed to execute exporter task for itemid:46888 key 'mssql.version[SQL2019]' error: 'Failed to evaluate metric parameters: invalid first parameter "URI": parse "sqlserver://SERVER\\\\SQL2019:1433": invalid character "
" in host name.'
2024/04/15 12:40:28.024829 check 'mssql.version[SQL2019]' is not supported: Failed to evaluate metric parameters: invalid first parameter "URI": parse "sqlserver://SERVER\\\\SQL2019:1433": invalid character "
" in host name.

Generated at Tue Jun 10 07:47:57 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.