Trying to run Powershell script SQL query using Oledb connection string , New-Object -comobject ADODB.Connection and New-Object -comobject ADODB.Recordset
Need to run this query with RunAsAccount credentials.
Running this in Powershell window by opening it with RunAsAccount Credentials
$myconnectionstring = "Provider=SQLOleDb;Integrated Security=true;Database=xxxSQL;Server=xxxDBServer"
Getting following error
Exception calling "Open" with "1" argument(s): "Invalid authorization specification"
(for creating monitors in System Center Operations Manager 2012 )
Trying to create rules/monitors based on PowerShell Script using VSAE (Visual Studio Authoring Extensions)
What needs to be corrected.