Change Service account password for multiple servers using T-SQL query or WMI Script or PowerShell script or SSIS script

• maroju1

  Old Hand

  Points: 310

  More actions

  August 2, 2017 at 9:53 am

  #343940

  Can anyone help to understand if there is any T-SQL query or WMI Script or PowerShell script or SSIS script to update Service account and its password for SQL Server service and SQL Server Agent service.

  Regards,
  GDBA

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  August 2, 2017 at 10:17 am

  #1953813

  powershell probably the best route, clustered or non clustered instances?

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉

• maroju1

  Old Hand

  Points: 310

  More actions

  August 2, 2017 at 10:26 am

  #1953815

  Veritas , windows  cluster and stand alone servers are there.

  Regards,
  Naveen

• goher2000

  SSCertifiable

  Points: 5479

  More actions

  August 2, 2017 at 12:57 pm

  #1953837

  good luck
   http://windowsitpro.com/powershell/changing-service-credentials-using-powershell