Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

I set this script as a Trigger Action in my Environment but it is not able to work. Running the script outside of SW works.

pauljordan

Find more posts tagged with

Accepted answers

All comments

tdanner

You could use a try/catch block to collect the error and write it to a text file.

But my guess is that SQL Server authentication is failing. Since you are not specifying a username/password, I'm guessing that Invoke-SqlServerQuery is using Windows authentication. When you run the script as yourself, your AD account is authorized to query that database so it succeeds. When the script runs as a trigger action, it is running under local system context. This means it accesses SQL Server as the machine account, which probably doesn't have access to your database.

pauljordan

Thank you for the response. I am going to work on this first thing tomorrow and let you know how it turns out