Unable to access reports remotely | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Unable to access reports remotely

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
is you datasource shared? Joe Janka
Even I am facing a similar problem. any solution will be greatly appreciated!!
just as a test, see if it works if you are an administrator on the box
http://msdn2.microsoft.com/en-us/library/ms365166.aspx Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
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