olap cube issues | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

olap cube issues

Hi All,
i’m writing a report with visual studio 2005, connecting to sql 2000 analysis sp4 remotely.I’ve created a datasource to a cube succesfully, but when i try to view the report in the design pane it errors. error message:’an error occured during report processing. cannot create a connection to datasource ‘datasource name”
will appreciate if anyone has any fix for this error. thanks in advance.

Analysis Services only supports Windows Authentication, so when you store the login and password the "Used as Windows credentials when connecting to the data source" checkbox just distinguishes it from a non-Windows login like in mixed mode.

Thanks alot Sayta for the reply, most appreciated. please can you give more details, i’m new t analysis services.
Kind Regards,


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |