How to change the SQL Server PI repository password or authentication settings (4230110)

Is a script available to change the SQL authentication for a SQL Server repository to use Windows (Active Directory) authentication?

How can the username, password, or SQL authentication details be changed for a SQL Server PI repository?

WORKAROUND

For versions below 5.9.7.10, disconnect the PI extensions, delete the SQL PI agents, and then reconnect the PI extensions

1. Navigate to the Databases Dashboard
2. Select all of the SQL Server agents with the SQL PI extension enabled that require the credential change to the repository
3. Select Settings | Administration
4. Navigate to the Performance Investigator menu
5. Select all of the database agents of this type
6. Click the Disable button
7. Navigate back to the main databases dashboard
8. Repeat steps 2-7 for Azure SQL, Oracle, and MySQL database agents
9. Remove the SSAS agents from monitoring
10. Navigate to Administration | Agents | Agent Status
11. Delete the SPI-Repository, DB_SQL_Server_SPI_Repository, DB_Oracle_SPI_Repository, DB_Azure_SQL_SPI_Repository, and SSAS_SPI_Repository agents for the Agent Managers connected to the SQL PI repository instance. 
12. Navigate back to the databases dashboard
    
13. Add the SQL PI extension to the database agents using the new connection information and when prompted to choose the schema, use the pulldown list to select the database previously configured to maintain each agent's specific type of data 
14. Recreate the SSAS agents

STATUS

Enhancement ID FOM-35 was created to add a new Manage PI repositories dashboard beginning in the 5.9.7.10 and higher releases of the database cartridges. Please review KB 322778 for more details on this new dashboard.