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/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
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |