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

    Anil Kumar
  2. jastone New Member

    is you datasource shared?

    Joe Janka
  3. raji New Member

    Even I am facing a similar problem. any solution will be greatly appreciated!!
  4. DStevensTN New Member

    just as a test, see if it works if you are an administrator on the box
  5. satya Moderator

  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.

    Anil Kumar

Share This Page