File Share Data-Driven Subscription

Hi.
Iâ'm trying to create File Share Data-Driven Subscription. Everything work
right, but when I set User and Password to the position â'Get the value from
databaseâ' some problems begin: the subscription stops working immediately, it
doesnâ't even try to generate report.
Can anybody help me?Yes, this is a known issue with RS. The credentials do not get encrypted
when the notification is created from the DD subscription, causing the
notification to fail. There is a work around, but it is not pretty. :)
Basically it required creating a subscription for each username/password
combo, each time you create it, find the encrypted values in the database
for the user name and password. Store these values in your table where your
DD subscription query is getting it's values. Obviously this won't work if
you can't change the values in the DD queries table.
This issue will be fixed in the next release of RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Boris" <frolovBA@.trytoguessHM.com> wrote in message
news:A7EE6253-C8C5-41B9-B9B8-E97219F10946@.microsoft.com...
> Hi.
> I'm trying to create File Share Data-Driven Subscription. Everything work
> right, but when I set User and Password to the position "Get the value
> from
> database" some problems begin: the subscription stops working immediately,
> it
> doesn't even try to generate report.
> Can anybody help me?
>