When I process the dimension I get following error

Initiating transaction in Database 'CACI Cubes'
Processing Dimension 'BAL Periods' failed. No changes have been made to the
database.

Start time: 9:42:42 AM
Initializing Dimension 'BAL Periods'
Data source provider error: Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.;42000; Time:3/23/2006
9:42:42 AM

Data source provider error: Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.;42000; Time:3/23/2006
9:42:42 AM

Rolling back transaction in Database 'CACI Cubes'
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.;42000; Time:3/23/2006 9:42:42 AM



User is able to login to the db via enterprise manager and is a dbo. also
the data source connection test succeeds. I am not sure what could be causing
this error? any idea?

The database connection is being made by Analysis Services to the SQL
Server. This is happening on behalf of the AS service account -- probably
that user doesn't have permissions. Change the AS service to run as a domain
user...

HTH,
Akshai

--
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.


"shahab" <shahab (AT) discussions (DOT) microsoft.com> wrote