SQL Server Performance

Unable to access reports remotely

Discussion in 'SQL Server 2005 Reporting Services' started by Anil, Jul 4, 2006.

  1. Anil New Member

    Hi All,

    I have configured report services and created a project to generate reports. I am able to generate reports on the server where I had configured but if I try remotely then I am getting below error :

    An error has occurred during report processing. (rsProcessingAborted)
    Cannot create a connection to data source 'SQLdmDatabase'. (rsErrorOpeningConnection)
    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    I am new to this reporting tool. I am using SQL 2005 standard edition.

    Any help should be greatly appritiated !!! Thanks in advance

    Regards,
    Anil Kumar
    Anil, Jul 4, 2006
    #2

  2. jastone New Member

    is you datasource shared?

    Joe Janka
    jastone, Jul 7, 2006
    #2

  3. raji New Member

    Even I am facing a similar problem. any solution will be greatly appreciated!!
    raji, Jul 13, 2006
    #2

  4. DStevensTN New Member

    just as a test, see if it works if you are an administrator on the box
    DStevensTN, Jul 18, 2006
    #2

  5. satya Moderator

    satya, Jul 19, 2006
    #2

  6. Anil New Member

    Issue got resolved!!!!

    I just mentioned credentials in my data source and now I can access reports from local machine

    Thanks all for looking into it.

    Regards,
    Anil Kumar
    Anil, Jul 31, 2006
    #2

Share This Page