Welcome to MSDN Blogs Sign in | Join | Help

Bad password trying to process an SSAS cube against Oracle

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, edit your data source, enter your Oracle credentials and don’t forget to select the save password checkbox.

 

That should do it for you.

Published Friday, October 19, 2007 2:29 PM by russch

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: Bad password trying to process an SSAS cube against Oracle

Friday, April 18, 2008 7:10 PM by Rich

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.

# re: Bad password trying to process an SSAS cube against Oracle

Thursday, November 13, 2008 2:01 PM by Aubrey

Thanks!  This really helped me out and my project connected after changing this option.

# re: Bad password trying to process an SSAS cube against Oracle

Monday, June 29, 2009 10:01 AM by howardm

thanks russell, saved my bacon. getting oracle 64bit connectivity is fun.

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker