MSSQL by ODBC: Issue with Job discovery

[BigSmooth]

Hello all,

I finally managed to make AD authentication work with MS SQL.
Now, I have another issue:
Cannot execute ODBC query: [SQL_ERROR]:[42000][229][[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The SELECT permission was denied on the object 'sysjobs', database 'msdb']

But if I am trying via isql (with exact same query as in DR definitions), I have access to it:
isql -v DSN1 [email protected] '****************'
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select count(*) FROM msdb..sysjobs WHERE enabled = 1
+------------+
| |
+------------+
| 6 |
+------------+
SQLRowCount returns 0
1 rows fetched

Any idea how differently zabbix is doing the query?

Regards,
Olivier

[dedy]

You must give your user this grant

use msdb
GRANT SELECT ON OBJECT::msdb.dbo.sysjobs TO user;

[dedy]

You must give your user this grant

use msdb
GRANT SELECT ON OBJECT::msdb.dbo.sysjobs TO user;