Hi,
I'm currently setting up a custom SQL notification query and I'm running in to issues:
I am able to test my connection under the "Server Modules > SQL Server" tab, with a user that was created on the SQL Server
I am also able to run my query when I press "Executy query".
Yet, as soon as this query in ran in the background, I get an error:
"SQL Filter MyFilterName has failed to execute in SQL Server on the computer ‘MyComputerName’ in group 'Default'Error Message: The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "myDbName" under the current security context.
"
It seems like Pulseway insist on using the NT Authority\System user, and not the user I provided?
Any help would be greatly appreciated.
Thanks!
Some screenshots (I've removed details for obvious reasons)
Connection settings:
Connection works when testing:
Results of query: