olap cube issues | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
olap cube issuesHi 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.