Jump to content

Issues connecting to SQL Server


TPR
 Share

Recommended Posts

Posted (edited)

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
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...