Error while processing cube

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

esl - 10 Feb 2006 22:17 GMT

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

Reply to this Message

Myles.Matheson@gmail.com - 11 Feb 2006 10:49 GMT

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

Reply to this Message

esl - 13 Feb 2006 16:32 GMT

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

Reply to this Message