Share via

Bad password trying to process an SSAS cube against Oracle

  • Article

Shout-out to my homies Chris and Thanh.

Depending on how you set up the impersonation settings on your Analysis Services cube’s data source to Oracle, you may run into the following error when trying to process:

Login failure: Unknown username or bad password.

If you bump into this, open up your data source and choose the Impersonation Information tab. Make sure Default is selected. Next, edityour data source, enter your Oracle credentials and don’t forget to select the save password checkbox.

That should do it for you.

Comments

  • Anonymous
    April 18, 2008
    This suggestion really helped me out.  Do we know as to the reason why this so?  Is setting to 'Default' telling/marking the connection string to pass the user id and password that was set and saved in the designer mode.
  • Anonymous
    November 13, 2008
    Thanks!  This really helped me out and my project connected after changing this option.
  • Anonymous
    June 29, 2009
    thanks russell, saved my bacon. getting oracle 64bit connectivity is fun.