Jump to content
View in the app

A better way to browse. Learn more.
Pulseway

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Issues connecting to SQL Server

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

Featured Replies

  • 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

Go to topic listing

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.