How to Use PowerShell to Set Secure SA Passwords in Bulk

• Vincent92

  Old Hand

  Points: 303

  More actions

  September 16, 2022 at 12:00 am

  #4076825

  Comments posted to this topic are about the item How to Use PowerShell to Set Secure SA Passwords in Bulk

• September 17, 2022 at 11:13 am

  This was removed by the editor as SPAM

• September 21, 2022 at 7:50 am

  This was removed by the editor as SPAM

• prabhuvella

  Grasshopper

  Points: 12

  More actions

  September 28, 2023 at 12:13 pm

  #4296911

  Hi Vincent. Excellent article. I am getting a small error in resetting the SA password. Its in Bulk Reset the SA passwords script. Please let me know if I need to change something.

   

  sapwd : The term 'sapwd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check

  the spelling of the name, or if a path was included, verify that the path is correct and try again.

  At C:\Work\SA_Password\Bulk_Change_SA_Password.ps1:5 char:111

  + ... e -Database master -Query "ALTER LOGIN sa WITH PASSWORD = '$(sapwd)';

  + ~~~~~

  + CategoryInfo : ObjectNotFound: (sapwd:String) [], CommandNotFoundException

  + FullyQualifiedErrorId : CommandNotFoundException