Code issue

• mtz676

  SSCrazy Eights

  Points: 9253

  More actions

  February 13, 2024 at 2:17 pm

  #4377957

  A job step received an error at line 33 in a PowerShell script. The corresponding line is 'Get-WmiObject -ComputerName $serverName -query " '. Correct the script and reschedule the job. The error information returned by PowerShell is: 'Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) '. Process Exit Code -1. The step failed.

  The code works in Powershell ISE but when scheduled as a SQLJob it fails. Is this a permissions issue ? If yes, how to fix it.If not please advise.

  Thanks

   

• Johan Bijnens

  SSC Guru

  Points: 135484

  More actions

  February 13, 2024 at 2:29 pm

  #4377959

  • Does the sqlagent service account have the authority to perform the wmi query?
  • Does the sqlagent job step proxy account have the needed authority to perform the wmi query ?

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• mtz676

  SSCrazy Eights

  Points: 9253

  More actions

  February 13, 2024 at 2:51 pm

  #4377963

  Thanks for the response..

  how do we check what you recommended ?

  https://www.sqlservercentral.com/blogs/quick-tip-wmi-alerts-and-sql-server-agent-permissions..

  Let me check and get back...

  But the query captures data from 100+servers...so how does this work...check on all servers or ....

  • This reply was modified 1 year, 2 months ago by  mtz676.

• Phil Parkin

  SSC Guru

  Points: 247140

  More actions

  February 13, 2024 at 3:27 pm

  #4377976

  mtz676 wrote:

  Thanks for the response..

  how do we check what you recommended ?

  https://www.sqlservercentral.com/blogs/quick-tip-wmi-alerts-and-sql-server-agent-permissions..

  Let me check and get back...

  But the query captures data from 100+servers...so how does this work...check on all servers or ....

  Check the account which is running the SQL Agent service on the SQL Server. Unless you have configured a proxy account for the job, that will be the account which is running the PoSh script.

  ---

• mtz676

  SSCrazy Eights

  Points: 9253

  More actions

  February 13, 2024 at 5:25 pm

  #4378048

  Hello Phil, Did as advised. Not working.same error