enabling Snapshot history

I want to enable history for my report but on the property page there is a
red warning saying that I have not registered credentials for the report. (I
think it means the datasource).
So in the docs it says that credentials are required for datasources that
have subscriptions enabled. But I don't have or want any subscriptions - I
just want to enable history for a report that is never subscribed to.
But, it looks like I have to do this for my report regardless if it uses
subscriptions. I suppose that's just a quirk in the system.
It asks for a connection string - a connection string to what? The
reportserver database?
It asks for a uid and password - whose uid and password do I need to enter?
Is this explained anywhere in the docs?
--
Regards,
Gary BlakelyHello Gary,
Thanks for using Microsoft Newsgroup.
I understand that you have questions about storing credentials for
datasources when configuring history of reports. If I'm off-base, please
let me know.
This behavior is as designed because report server has to know how to
connect to the data source of a specific report when creating report
history snapshot. It cannot prompt users to input credentials as that in
UI/Web forms.
The connection string shall be the same as that in the shared data source.
You could find it in the properties of the shared data source. You could
copy it directly from there directly. It is not connection string to report
server but data srouce of the specific report you configure.
As for credential, you shall select "credentials supplied by the user
running the report", and other options when necessary. As for the user
name/password, you shall input the Windows/SQL credentials you want the
report to connect to external data source. If it is Windows domain user,
you shall also select "Use as Windows credentials when connecting to the
data source"
You could see the following article in BOL for details:
http://msdn2.microsoft.com/en-us/library/ms160330.aspx
If anything is unclear, please feel free to let's know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.