Report Server Stored Credentials

I am getting the standard "Subscriptions cannot be created because the credentials used to run the report are not stored -".I tried to store them in the Stored Data Source in the Visual Studio Project and then deployed. I cannot find in any documentation a reference where to go to STORE CREDENTIALS for a Report Server subscription. I would really appreciate any help on this. I did look at the existing threads, but they don't specifically address where to create the credentials. Thanks for any help you can provide.

Hello Gary,

Using Report Manager, drill down to your report. Click the properties tab, then select 'data sources' on the left side of the page. Make sure the 'A custom data source' is the radio button selected, then click the radio button for 'Credentials stored securely in the report server'. Type in your credentials to run the report and if it's a domain account, then check the box for 'Use as Windows credentials when connecting to the data source'. Click Apply at the bottom and you should be able to create a subscription.

Hope this helps.

Jarret

|||Where is this in the documentation? I searched Books on Line and MSDN and got NADA. What a brilliant person you are. Maybe smarter than the richest man in the world (BG), how bout that. Thanks and thanks again.|||

Many thanks for your kind words Gary.

In BOL, just search for 'stored credentials', it also has a way to set the stored credentials via a RS connection in Management Studio.

Jarret