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.
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)GetOnlineHelpCannot create a connection to data source 'SCS'.(reErrorOpeningConncetion)GetOnlineHelpSQL 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 |
 |
|
|
|
|