Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ntswakisto
Starting Member
33 Posts |
 Posted - 2010-05-14 : 10:02:43
|
| I need helpI have created a report with default parameters...and deployed the report in report server...I would like to schedule the report to save in the History everyday.i am getting an error that the credentials used to run the report are not stored....I have already set the username and password that don't expire in the data source properties....... |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-05-14 : 10:54:04
|
| On Report Manager, you have to go to "Data Sources" and set the check box to indicate that credentials are securely stored in the database and supply the credentials, for the datasource the report is using.______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
ntswakisto
Starting Member
33 Posts |
Posted - 2010-05-17 : 02:47:37
|
quote:
Originally posted by savior faire
On Report Manager, you have to go to "Data Sources" and set the check box to indicate that credentials are securely stored in the database and supply the credentials, for the datasource the report is using.______________________________________________Talk sense to a fool and he calls you foolish.
Thanks Savior faire ...i've already tried doing that but I still get the same error .....that credential used to run the report are not stored. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-05-18 : 07:18:47
|
| Just curious if you have checked the documentation on this item in Books OnLine. In my experience the documentation is pretty good.There are also two check-boxes under "Credentials Stored" section of the data source.______________________________________________Talk sense to a fool and he calls you foolish. |
|
|
|
|
|
|
Using stored credentials