Reporting Services Report Subscriptions with Windows Authentication - by Anthony L. Thomas

Status : 

 


27
0
Sign in
to vote
ID 471468 Comments
Status Active Workarounds
Type Suggestion Repros 1
Opened 6/30/2009 10:40:56 AM
Access Restriction Public

Description

Our SQL Server Relational Engine is configured for Windows Authenticated logins only, which is a recommended Microsoft Best Practice.

However, SSRS documentation states that only stored credentials (non-Windows Integrated) for the data source configuration is required in order to support Report Subscriptions.

This seems at least like a feture bug, but at the very least, the product should support the Recommended Best practices.
Sign in to post a comment.
Posted by Microsoft on 12/17/2013 at 12:17 AM
Thank you for your feedback. This is a known issues and we will consider this for the next version of Reporting Services.

Regards,
Tzvi
Posted by Andreas.Wolter on 4/21/2011 at 5:10 AM
Credentials have to be know upfront, this makes sense.
They can be Windows, but not integrated so far.
I have made a proposal for the Implementation of saved Credentials/Proxys here:

https://connect.microsoft.com/SQLServer/feedback/details/663839/allow-the-use-of-saved-credentials-proxy-accounts-for-reporting-services-subscriptions
Posted by Microsoft on 9/9/2009 at 9:04 AM
Thank you for filing this issue. We will consider a solution to it as a feature for a future version of Reporting Services.

To answer some of your specific questions - SQL Agent does not actually execute the report subscription. Agent simply writes a row in our event queue telling RS service that it is time to do a particular piece of work. The report server monitors the queue and start processing the events in the event queue. So SQL Agent's logon account cannot be used to run the actual report.

I very much appreciate you taking the time to offer a suggestion of how to improve Reporting Services.

Thank you,
-Lukasz