Jacob, yes, i'm running RS on my PC and grabbing reports created here, but using data (in this case a SP running on a SQL Cluster (but both on the same Domain). now, (i've done a lot of internet searching) Yesterday afternoon i went into RS Config Mgr & under "Execution Account" i unchecked the box labelled: "Specify an Execution Account" and my reports started working. this is NOT the route i wish to travel. My feelings are that, yes, there is something blocking my request for the SP to run on the SQL Cluster Node when using the ReportExecution Account. i don't know where to go on the SQL server to enable that authority. i believe i have it correctly taken care of within SQL under Security/Logins, could it be that i need to do something with the MS-Server2003 permissions?
Russ
Jacob Luebbers (4/15/2008)
@rholt:It sounds like you may be running into a Kerberos delegation issue. Are your RS server and the source DB server running on different boxes? If so you may not have your RS server setup to correctly delegate the users' credentials to the DB server, so that final "2nd hop" connection is coming through as anonymous. This has been discussed a few times in various threads, the latest I recall was in a linked server context here. aureolin posted a link partway through the thread (http://msdn2.microsoft.com/en-us/library/aa905162(SQL.80).aspx) that gives you the details on correctly configuring your servers.
Regards,
Jacob