Jump to content
Pulseway 9.14 🔥

Featured Replies

Posted

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:

image.png.2db3f6c451715a6a4bd341be4081285c.png

Connection works when testing:

image.png.ba77e5fe79c7282010fc7b78d5b124e9.png

 

Results of query:

image.png.3ed462396fab47d024d7fd03c81dd524.png

Edited by TPR

  • Author

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

Thread can be closed.

Create an account or sign in to comment