The nature of IT Analytics' (ITA) architecture requires multiple identities to be defined across Microsoft Internet Information Services (IIS), SQL Server, SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS), though the same identity may be used in all cases. Additional credentials are used with content packs to connect to data sources. In some environments, the passwords of one or more identities may periodically change, necessitating an update of the passwords used for ITA and data source connections.
This article does not address changes to ITA portal user account credentials.
Standard Method
After resetting or updating the ITA service account's password in Active Directory, follow this procedure to update the credentials used by the ITA application:
- Follow the procedure for Microsoft Internet Information Services (IIS) provided below to update the password of the
ITAnalyticsServer_AppPool
identity
- Login to the ITA portal using an account with administrative privileges
- In the IT Analytics header, click on the gear icon and navigate to Settings > Servers
- Click on each gear icon and select Edit for each of the following servers:
- Analysis Server Settings
- Report Server Settings
- SQL Server Agent Settings
- Follow the prompts in the Configuration Wizard for each server to update the service account password
Manual Method
If the standard procedure fails to update the credentials on one or more servers, refer to the following procedures.
Microsoft Internet Information Services (IIS)
To update the password of the application pool identity used by IIS for the ITA application, follow this procedure:
- On the ITA application server, open the Internet Information Services (IIS) Manager
- In the Connections pane, expand the server hosting the ITA application and select Application Pools
- In the Application Pools page, right-click the ITAnalyticsServer_AppPool and select Advanced Settings
The Advanced Settings window opens
- In the Advanced Settings window, locate the Process Model heading
- Under the Process Model heading, select Identity and click on the ellipsis next to the credential name
The Application Pool Identity window opens
- In the Application Pool Identity window, click the Set... button next to Custom Account
The Set Credentials window opens
- In the Set Credentials window, enter the user name and new password
- Click the OK button to close the Set Credentials window
- Click the OK button to close the Application Pool Identity window
- Click the OK button to close the Advanced Settings window
- In the Application Pools page, right-click the ITAnalyticsServer_AppPool and select Recycle...
Microsoft SQL Server
To update the password used by the IT Analytics Proxy to initiate cube processing on the Analysis Server, follow this procedure:
- Using SQL Server Management Studio (SSMS), connect to the Database Engine hosting the
ITAnalytics
relational database
- In Object Explorer, navigate to Security > Credentials
- Right-click the IT Analytics Credential and select Properties
The Credential Properties window opens
- In the Credential Properties window, update the Identity (if needed) and password
- Click the OK button to save the credentials and close the Credential Properties window
Microsoft SQL Server Analysis Services (SSAS)
To update the password used by SSAS to connect to the SQL Server, follow this procedure:
- Using SSMS, connect to the Analysis Services server hosting the IT Analytics OLAP cubes
- In Object Explorer, navigate to Databases > ITAnalytics
- Right-click ITAnalytics and select Properties
The Database Properties window opens
- In the Database Properties window under the Security Settings heading, edit the Data Source Impersonation Info
The Impersonation Information window opens
- In the Impersonation Information window, update the Password
- Click the OK button to save the password
- Click the OK button to close the Database Properties window
- In Object Explorer, navigate to Databases > ITAnalytics > Data Sources
- Right-click ITAnalytics and select Properties
The Data Source Properties window opens
- In the Data Source Properties window under the Security Settings heading, edit the Impersonation Info
The Impersonation Information window opens
- In the Impersonation Information window, select the Inherit impersonation option
- Click the OK button to close the Impersonation Information window
- Click the OK button to close the Data Source Properties window
- Restart the SQL Server Analysis Services service
Data Sources
To update the password used to connect to a data source, follow this procedure:
- Using SSMS, connect to the Database Engine hosting the
ITAnalytics
relational database
- In Object Explorer, navigate to Server Objects > Linked Servers
- Right-click the linked server for the data source to be updated and select Properties
The Linked Server Properties window opens
- In the Linked Server Properties window, select the Security page
- In the Security page, enter the username and new password under Be made using this security context
- Click the OK button to close the Linked Server Properties window