Hi everbody,

I am trying to process a cube where my datasource is on
sql server. I get an error msg saying login for my userid
failed. I am using windows authenication and went as far
as to set up a user with sa rights and still it won't
process. Funny thing is, I can browse this data when I am
setting up my cube. My workaround was to move my
underlying data onto my desktop and process from there.
But I would really like to make it work from the server.
Any advice?

When you process a cube, dimension or partition -- the actual component that
is actually issuing the SQL query is the msmdsrv process; not your
interactive user.
If you have configured the data source to use a SQL Server *trusted*
connection, then you need to change the NT Account that the
MSSQLServerOLAPService (msmdsrv process) is running under. Just go to Start
\ Control Panel \ Services -- select MSSQLOLAPService and Properties -- then
Logon. Specify a valid domain account that has access to the data source.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Lam Nguyen" <anonymous (AT) discussions (DOT) microsoft.com> wrote