#SCSM: Cube processing fails after changing service account password

You may run into a situation where you’ve changed the passwords for the Service Manager service accounts, and the DW Cubes stop processing with an error that looks something like this:

image

To fix:

Connect to the SQL Analysis Server hosting your cubes, expand Data Sources, and update them each as follows:

Open the Properties view of the Data Source

capture-20130325-083852-1

Ensure that the server name, etc is correct and click on ImpersonationAccount. Insert the updated password here.

capture-20130325-084029

Reset the Analysis Services service, and process your cube. It should complete successfully after running for 5-10 minutes. You can then resume the jobs in the SCSM console.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s