Change service account you Analysis Server running under.
See similar posting on:
http://forums.microsoft.com/MSDN/Sho...68362&SiteID=1
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"gayu" <gayatri.kulkarni (AT) gmail (DOT) com> wrote
Quote:
Hi all,
I am getting the following error while processing the dimension using
SSAS--
'OLE DB error: OLE DB or ODBC error: Login failed for user 'NT
AUTHORITY\LOCAL SERVICE'.; 42000.'
Also, I am using windows authentication.
Could anybody please help me out here?
Regards,
Gayatri. |