Error: Cannot impersonate user for data source

An error has occurred during report processing. (rsProcessingAborted)

Cannot impersonate user for data source 'DataSource1'. (rsErrorImpersonatingUser)

Logon failed. (rsLogonFailed)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Any help would be greatly appreciated. Thank you.

Can you enable remote errors so we can see the detailed error message:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=230635&SiteID=1

sql

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

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
EricHello 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

Error while processing a cube :(

I am getting the following error when trying to process my cube. Can someone
please guide as to how this problem can be solved. Thanks
Data source provider error: [Microsoft][ODBC SQL Server Driver][
SQL Server]Cannot resolve collation conflict for equal to operation.;37000;
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...When you process the cube you can see the query that olap is using to
retrieve data from SQL.
If you have a look at that query he is going to match several fields to each
other. In one of the fields you have a collation problem. You try to match
2 field together with a different collation.
You will have to check the collation settings of these fields.
Regards,
Nico
"Learner" wrote:

> I am getting the following error when trying to process my cube. Can someo
ne please guide as to how this problem can be solved. Thanks
> Data source provider error: [Microsoft][ODBC SQL Server Driver]
1;SQL Server]Cannot resolve collation conflict for equal to operation.;37000
;
> ****************************************
******************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NE
T resources...
>|||Tons of thanks Nico.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...