Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 rsProcessingAborted Error

Author  Topic 

cipriani1984
Constraint Violating Yak Guru

304 Posts

Posted - 2008-10-06 : 09:34:11
I wasn't sure what chapter forum to post this question under, so I'm putting it here. I seem to have some kind of security or authentication issue that I can't track down.

Quick environment breakdown.Reporting services is loaded on a 2005 server with a local SQL server DB. When I run a report from the local server or a workstation everything works great. As soon as I change the DataSource to a SQL instance on another server I can no longer run the report from a workstation, but I can run the report from the server. The error I get from the workstation is:



An error occured during report processing. (reProcessingAborted)GetOnlineHelp

Cannot create a connection to data source 'SCS'.(reErrorOpeningConncetion)GetOnlineHelp

SQL Server does not exist or accessed denied.



I can use the same login for server and workstation. Server will work, workstaion will not. Am I missing something?



Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-06 : 09:49:14
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=171110&SiteID=1
Go to Top of Page
   

- Advertisement -