Credentials used to run this report are not stored.
I created a report in SSRS, and deployed it. I have created security where when users run the on demand report, it will prompt them for a username and password. I went to the properties of the report then Execution, and tried to set up report execution snapshot and got an error 'Credentials used to run this report are not stored.' I get the same error if I go to History and try to select any of the options there.
April 17th, 2007 4:47pm

Hello, In order to create a subscription/snapshot, you have to store credentials to run the report. If you don't store the credentials, when it goes to run unattended, it has no connection information. Jarret
Free Windows Admin Tool Kit Click here and download it now
April 17th, 2007 4:56pm

Where do I store these credentials?
April 17th, 2007 4:58pm

Hello, Go to the properties of your report, then click on 'Data Sources'on the left. In here, select 'Credentials stored securely in the report server' and supply a username and password. If you use a Windows account, you have togive the domain as well(domain\user) andcheck the box for 'Use as Windows credentials when connecting to the data source'. Hit Apply. Hope this helps. Jarret
Free Windows Admin Tool Kit Click here and download it now
April 17th, 2007 5:04pm

That worked....thanks!!
April 17th, 2007 5:08pm

Hi Jarret, I am wondering can this be done by using cmd.exe with RS scripts? Dennis
Free Windows Admin Tool Kit Click here and download it now
August 20th, 2010 2:23am

HI Jarret, I am using a shared data source on SQL server 2008 Version , so i am unable to check the Radio button for 'Credentials stored securely in the report server' . please advise on this... Thanks Siva.
December 21st, 2010 8:57am

hi Siva well inorder to check the credentionals stored securely you have to first check A custom data source.
Free Windows Admin Tool Kit Click here and download it now
January 17th, 2011 10:40am

HI Jarret, I am using a shared data source on SQL server 2008 Version , so i am unable to check the Radio button for 'Credentials stored securely in the report server' . please advise on this... Thanks Siva. If the datasource is shared, you have to navigate to it. By default in RS 2008 + the datasources are in a hidden folder called 'Data Sources'. On the main page of report manager, click 'details' and this folder should be revealed. Then you can find you data source and click 'manage' then follow the same instructions from Jarret.
September 26th, 2011 9:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics