IFW - MSSQL Integrated Security

Icinga 2 Icinga for Windows
,
1

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
image1279×279 36.8 KB

The service looks like this:

image
image818×1086 61.9 KB

Thanks for your help!

2

Hello

Thank you for your post. Is the domain user which is used for the Icinga Agent/Icinga for Windows service allowed to access the MSSQL database?

If not, the integrated security will not work, as it will try to authenticate with the user the services are running with.

However, if you are running JEA, you cannot use IntegratedSecurity, because then the entire session and plugins are running in a system/computer context, with no real user session assigned.