Invoke-IcingaCheckMSSQLBackupStatus - error with credential

[picoroma (PiCo)]

Hi all!
yesterday I “extended” the Icinga4Windows agent installing the check to monitor MSSQL ( icinga-powershell-mssql )
After the installation on “Agent\Satellite” - I generated the “Invoke” command specific for MSSQL following the Icinga Integration with Director (icinga-powershell-framework/doc/200-Icinga-Integration/01-Director-Baskets.md at master · Icinga/icinga-powershell-framework · GitHub)
After that I IMPORTED these new “Invoke” command on my ICINGA MASTER and try to use like the other Icinga4Windows" Invoke command.

But - for example using the “Invoke-IcingaCheckMSSQLBackupStatus” - I receive always an error - related to the authentication to MSSQL server.

I tried both with a specific SQL user and even using the “already present” changing this to YES or NO:

Unfortunately I still receive an error at authentication:

But the credential I used (DOMANI\LocalAdmin) I’m quite sure that are correct.

If I use the “IntegratedSecurity” = NO - the error is quite different:

In this picture - Is not clear to me where is defined the user “WORKGROUP\HOSTNAME1$” ?

where I’m wrong?
How can I set the correct user to login to the MSSQL server ?

[moreamazingnick]

do you use JEA?

IFW - MSSQL Integrated Security

Hello I have a problem with the MSSQL plugins for Icinga For Windows. I want to use Integrated Security. The Powershell Service and Icinga Agent are running with a domain user. When I run the check with Icinga I get this response: [image] When I run a powershell with the service user the check works: [image] The service looks like this: [image] Thanks for your help!

[picoroma (PiCo)]

I tried without JEA but the plugin do not work at all.
So I have configured JEA. With IntegratedSecurity YES

With JEA enabled I receive the result from BackupStatus, but no-way to have output from Other Check. For example MSSQL resources.
Backup status Now is coming out, even is there is an Issue on the “status” itself due to a wrong threshold:

Where these threshold are defined?
I have open another POST for this:

Invoke-IcingaCheckMSSQLBackupStatus - wrong threshold for backup Status

I have configured the plugin for MSSQL (using Icinga for windows) - Invoke-IcingaCheckMSSQLBackupStatus I created a service check to check the backup Status. I leave all the Threshold empty in Command end service definition. But the check report these error regarding the “Status”. Seems that some threshold are defined (even in wrong way!) How can correct this ? [image] THX