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/ms156468.aspx
http://msdn2.microsoft.com/en-us/library/ms365166.aspx Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
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

]]>