Hello Jeff,
Thank you for posting in the MSDN newsgroup.
As for the reporting service accessing SPS list data issue, I think your
thought on the security permission is reasonable. At development time in VS
IDE, it use the logon user as the security context to access any remote
datasource (if require authentcated) user. However, after you deployed it
to reportServer, if you haven't explicitly set any credential for the
datasource(used in the report), it'll still use the authenticated user(if
you choose integrated windows credential) or the report server's service
account(if you do not specify any credentials).
Anyway, changing the report server's service identity is certainly not
recommended. I suggest you consider choose a certain credential supply mode
for your SPS datasource. We can configure credentials for report datasource
through two means:
1. In the DataSource's "Credentials" properties at design-time in VS IDE.
2. Use the report manager to configure credentials info for datasource
after deploying to report server.
Here is the BOL reference about how to specify credentials for datasource
connection:
#Specifying Credential and Connection Information
http://msdn2.microsoft.com/en-us/library/ms160330.aspx Hope this helps.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure!
www.microsoft.com/security (This posting is provided "AS IS", with no warranties, and confers no
rights.)
