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
Store

Powershell script issue with connect to db

I'm using powershell OOTB powerhell component monitor.

Im tying to execute very simple sql query with invoke-sqlcmd (sqlserver module). I put the modules file in all relevant directories.

Also I've configured a dedicated user, with permisions, and tested it from the powershell console itself .

Now, I know it should work acording to the following article

But I still getting an error. like the script engine of solwarwinds is not familiar with the module. see image for the error, and then image of the script.

Thanks for your help

Find more posts tagged with

Accepted answers

All comments

brscott

Add this to your script and I think you will see the problem.

Write-host "message.blah: $(whoami)"
Write-host "statistic.blah: 1"

You are likely running the command as "nt authority\system", not as the user you think you are running it as. The "Credential for Monitoring" setting is really only setting a variable called ${CREDENTIAL}. I get around this by:

$Creds = Get-Credential '${CREDENTIAL}'

Invoke-SqlCmd -Credential $Creds [and whatever else]

brscott

and don't forget to take out the "integrated security=true"