App MS SQL Instance Discovery return error

[studero]

Hi,

My Zabbix server run on RedHat 9 with the last version of Zabbix.

I want to monitor MS-SQL Server with multi instance. I have tried to use the community-templates/Databases/Microsoft_SQL_Server/template_app_ms_sql_instance_discovery_(lld)/6.0 at main · zabbix/community-templates (github.com)

But I have a problem when run the Discover rules. I have the following error message "Unsupported item key" with the Key "windowssqlinstances.discovery"

From my Zabbix server, I run the following command with the same result:
[root@svx-mon-02t ~]# zabbix_get -s svw-mssql-01t -k windowssqlinstances.discovery
ZBX_NOTSUPPORTED: Unsupported item key.
[root@svx-mon-02t ~]#

I thinks that I need or there are an error into the Template.

Thanks for your help
Regards
Olivier

[dimir]

FYI The thread actually started here:

https://www.zabbix.com/forum/zabbix-help/469755-how-to-use-the-template-app-ms-sql-instance-discovery

As an alternative, you can use the official template for MS SQL monitoring, using ODBC:

https://www.zabbix.com/integrations/mssql

[studero]

Hi,

Ok, Now I have testing using ODBC. But that's does not work. I have the following error:

Cannot connect to ODBC DSN: [SQL_ERROR]:[HY000][458752][[unixODBC][Microsoft][ODBC Driver 18 for SQL Server]SSPI Provider: No credentials were supplied, or the credentials were unavai]|[HY000][458752][[unixODBC][Microsoft][ODBC Driver 18 for SQL Server]Cannot generate SSPI context]


I have some questions about the configiguration of ODBC:
- odbc.ini file contains the following information. It is true ?
# cat odbc.ini
[svw-mssql-01t]
Driver = ODBC Driver 18 for SQL Server
Server = svw-mssql-01t,1431
Database = GESTENS
Encrypt = No
Trusted_Connection = Yes
- Wich type of use I need to connect to the Database ? Actually I use an Account AD user ?


Regards
Olivier

[dimir]

Could this one be of any help? https://www.zabbix.com/forum/zabbix-...-a-domain-user

[studero]

Hi dimir

I'm able to create a connection from the Linux server to the MS-SQL server using the following commande and result:

]# isql -v svw-mssql-01t USER PASSWORD
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| echo [string]                         |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> 

But not with the sqlcmd commande as follow :
# sqlcmd -S svw-mssl-01t\\GESTENS -C -E
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Login timeout expired.
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. .
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to svw-mssl-01t\GESTENS. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..

I need more help

[dimir]

Sorry, I have never set up MS SQL monitoring, hopefully someone else could help here.

[vijayk]

Have you installed the ODBC driver in Zabbix server?

[dimir]

FYI. The work has started on Agent 2 plugin for MS SQL monitoring without ODBC, planned for 7.0: https://support.zabbix.com/browse/ZBXNEXT-6235