Issues connecting to SQL Server

[TPR]

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:

Edited July 3, 2022 by TPR

[TPR]

Finally recreated the user and restarted SQL server. That seems to have fixed it.

Thread can be closed.