Post reply

Error while connecting to OLAP Server with Reporting Services

  • June 18, 2005 at 3:24 am

    #164122

    Guys,

    I am using SQL Server Reporting Services, My SQL box is on Win2k3 and My Reporting services are on Windows Xp Professional. Iam using MDX queries in reports. I am able to see data and preview. when iam deployig the reports its giving me error.

    "An error has occurred during report processing. (rsProcessingAborted) Get Online Help

    Cannot create a connection to data source 'ProjectServer'. (rsErrorOpeningConnection) Get Online Help

    Database 'MSP_Sample_Cube' does not exist. "

    I have a shared datasource on Reporting Services machine.

    Any help??

    Thanks in Advance.

    Regards

    Vijay

  • June 18, 2005 at 5:28 am

    #566594

    Do you have a Role set on the catalog/cube?  What context are the reports on the server being run under? What security setting/s do you have on the datasource (windows authentication?)

     

    Steve.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply