Error when I try to add subscription: "Subscription cannot be created because credentials used to run this report are not stored."
I have SSRS 2005 and WSS 3.0 both installed on a Windows 2008 x64 Server. SQL 2005 is the database, which his on a 2nd server (also Win 2008 x64).
I'm able to publish reports to sharepoint. I'm able to view them in sharepoint web parts, but only when I set the credentials for the datasource to "stored connections" and check both "Use as windows credentials"
and for "Set execution context to account".
Everything I read seems to say that I have to use Stored Credentials. That's what I'm doing though.... necessary in order for me to view the reports within sharepoint.
Other environment things that may be important:
The Report Server App Pool is using a domain account. The same one I'm using to execute the report. The WSS Content App Pool and the Sharepoint Central Admin App Pool are also using domain accounts. However all 3 are using different accounts.
I see reference to Kerberos vs. NTLM authentication. Up to this point I've not had to completely understand that. So the only thing I do understand about that is that in my Sharepoint Central Admin --> Application Management, Auth Type: Windows;
Anonymous is NOT checked, an
View Complete Post