Post reply

How to Use PowerShell to Set Secure SA Passwords in Bulk

  • 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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply