Post reply

Need to change RS Execution Acct PWD, automatically w/ T-SQL

  • August 2, 2021 at 5:30 pm

    #3916250

    We use a 3rd party vendor to administer our SQL Server service account PWDS. We have an API to capture the new PWD -- which changes every "n" days and we're looking to automate the PWD update for our SSRS Execution Account.

    Using T-SQL, is there a way to change the SSRS Execution Account PASSWORD (found on the Reporting Services Configuration Manager)?

    fyi, we know we can manually start RS Config Mgr and manually change the RS Execution Acct there -- we're looking to automate this change using T-SQL command if possible.

    BT

  • August 2, 2021 at 5:54 pm

    #3916266

    look at the rsconfig utility https://docs.microsoft.com/en-us/sql/reporting-services/tools/rsconfig-utility-ssrs?view=sql-server-ver15

     

    regarding your SQL Service accounts - you should be using MSA/GMSA where possible (e.g. as the user that the services run under) so you don't even have to change those at all - service accounts should only be normal AD users where they are used by an application that requires username/password to connect to launch a process as that user.

Viewing 2 posts - 1 through 1 (of 1 total)

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