ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Update ICA services credentials and data source credentials

book

Article ID: 226575

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

The nature of Information Centric Analytics' (ICA) architecture requires multiple identities to be defined across Microsoft Internet Information Services (IIS), SQL Server, and SQL Server Analysis Services (SSAS), though the same identity may be used in all cases. Additional credentials may be used with integration packs and in the Integration Wizard (IW) for data source queries. In some environments, the passwords of one or more identities may periodically change, necessitating an update of the passwords used for ICA and data source integrations.

This article does not address changes to ICA portal user account credentials.

Environment

Release : 6.5.x

Component : Credentials

Resolution

Microsoft Internet Information Services (IIS)

To update the password of the application pool identity used by IIS for the ICA application, follow this procedure:

  1. On the ICA application server, open the Internet Information Services (IIS) Manager
  2. In the Connections pane, expand the server hosting the ICA application and select Application Pools
  3. On the Application Pools page, right-click the RiskFabricAppPool and select Advanced Settings
  4. In the Advanced Settings window, locate the Process Model heading
  5. Under the Process Model heading, select Identity and click on the ellipsis next to the credential name
  6. In the Application Pool Identity window, click the Set... button next to Custom Account
  7. In the Set Credentials window, enter the user name and new password
  8. Click the OK button to close the Set Credentials window
  9. Click the OK button to close the Application Pool Identity window
  10. Click the OK button to close the Advanced Settings window
  11. On the Application Pools page, right-click the RiskFabricAppPool and select Recycle...

Microsoft SQL Server

To update the password used by SQL Server to connect to the SSAS server, follow this procedure:

  1. Using SQL Server Management Studio (SSMS), connect to the Database Engine hosting the RiskFabric database
  2. In Object Explorer, navigate to Server Objects > Linked Servers
  3. Right-click the RiskFabric_ASDB linked server and select Properties
  4. In the Linked Server Properties window, select the Security page
  5. Update the remote login (if needed) and password for the setting Be made using this security context
  6. Click the OK button to save the setting and close the Linked Server Properties window

Microsoft SQL Server Analysis Services (SSAS)

To update the password used by SSAS to connect to the SQL Server, follow this procedure:

  1. Using SQL Server Management Studio (SSMS), connect to the Analysis Services server hosting the RiskFabric cube
  2. In Object Explorer, navigate to Databases > RiskFabric
  3. Right-click RiskFabric and select Properties
  4. In the Database Properties window under the Security Settings heading, edit the Data Source Impersonation Info
  5. In the Impersonation Information window, update the Password
  6. Click the OK button to save the password
  7. Click the OK button to close the Database Properties window
  8. Restart the SQL Server Analysis Services service

Integrations

To update the password(s) used to connect to data sources through integration packs or via custom integrations, follow this procedure:

  1. Open the ICA console
  2. Navigate to Admin > Integration > Data Sources
  3. From the Choose Data Source menu, select the integration to be updated (e.g., Symantec Data Loss Prevention)
  4. If the data source is connected via an integration pack, select the contact card icon next to the server to be updated
  5. Follow the prompts in the Edit Connection Settings window to update the credentials of the data source connection
  6. If the data source is User Defined, right-click the datasource name and select Edit Data Source
  7. On the Create Data Source page, update the password used for the data source connection
  8. Repeat applicable steps 3 through 7 for each data source connection to be updated