| Akshai Mirchandani [MS] 2006-03-23, 8:37 pm |
| 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@discussions.microsoft.com> wrote in message
news:AF4DE013-0DEB-47EB-A718- 184FC1E16447@microso
ft.com...
> 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?
|