Error while processing cube

Hi All,
I keep on getting the following error while processing a cube in SSAS
2005:
Connection could not be established to the Data Source with
DataSourceID <my_data_source_name>
I don't understand why as my project deployement completed successfully
and a "Test Connection" of my Data Source returns a "Test connection
succeeded"
My user is 'sa' so I don't think rights are a problem here.
Does someone have any idea on this ?
Thanks in advance
Eric
Hello esl,
This error is more than likely caused by the Analysis Services service
account not having the permissions to connect to your data source. This
happens when you use windows authentication for the data source
connection and the AS2005 service is running under local system
account.
Try to run the Analysis Services with a windows account that has rights
to connect to your data source. The cube should then process.
Hope this helps,
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com
|||Hello Myles,
you're right it was indeed a problem with the impersonation account I
used for the data source.
I know use the service account which I have given required permissions
(domain +db) and it works fine.
Many Thanks for your help !
Eric