SQL Server Performance

olap cube issues

Discussion in 'Analysis Services/Data Warehousing' started by mikechuk, Jan 14, 2008.

  1. mikechuk New Member

    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.
    Mike
    mikechuk, Jan 14, 2008
    #2

  2. satya Moderator

    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.
    satya, Jan 14, 2008
    #3

  3. mikechuk New Member

    Thanks alot Sayta for the reply, most appreciated. please can you give more details, i'm new t analysis services.
    Kind Regards,
    Mike
    mikechuk, Jan 14, 2008
    #4

Share This Page