Upgrading SQL Recommendations for IDM

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

Does Broadcom supply any documentation for how to upgrade SQL that is being utilized by Identity Manager or other Identity Suite appliances? Is there a best practice?

Environment

Release : 14.X

Component : IdentityMinder(Identity Manager)
Component : IdentitySuite(Identity Suite)

Resolution

As per instructions for the SQL upgrade itself, Broadcom does not have recommendations. However, we can provide the best recommended steps for what needs to be done while you are upgrading against your SQL server.

Here are the recommendations:

1) Shut down ALL Identity Suite appliances that are communicating with the SQL server.
2) Have SQL team confirm there are no open connections to SQL.
3) Take a snapshot of your SQL server.
4) Upgrade your SQL server
5) Once the upgrade is complete, start ALL Identity Suite appliances and test functionality.

If there are no changes to the machine name / DNS / IP address of the SQL server then no further actions will need to be taken but if they have changed you will need to edit the data sources against IDM.

Reference Material (Standalone):
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/identity-manager/14-3/installing/separate-database-configuration-optional/edit-the-data-source.html


Reference Material (VAPP):
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/identity-suite/14-3/virtual-appliance/Change-the-Password-of-Identity-Suite-Components.html#concept.dita_6599601b-9f72-4020-924e-461f4ce8109c_ChangeDatabasePassword

If you experience any issues after the upgrade please reference your server logs for any errors for troubleshooting and if under a time restraint please utilize the snapshot you took to revert your SQL server upgrade.