dbTalk Databases Forums  

RE: Impersonation

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss RE: Impersonation in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
yongli
 
Posts: n/a

Default RE: Impersonation - 11-22-2006 , 11:41 PM






I experienced the same problem and somehow got workaround. I had to reenter
the user name and password then rebuild the project to make processing
working again. Good luck.

"Jukes231" wrote:

Quote:
I am building a cube that uses has to use impersonation due to security
access. I built the data source, embedded the impersonation account
into the data source, connected and got the tables needed for the DSV
and constructed the dimensions. When I try to process the dimensions,
I get an error stating "Logon failure: unknown user name or bad
password". I know the account works because I used it to get the
tables for the DSV, so I assume that when it processes it needs more
rights. What kind of rights does a user need to process.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.