Hi,
I am having a problem in applying subscription to a report.
Here is my case:
I have a datasource with 'Windows integrated security ' authentication, yes....I am using windows domain authentication, so login info is not stored in DB but its authenticated from domain. Now the report I want to use subscription on is using this DS. I read it somwehere that I can use rsconfig -e -u -p option to assign user to unattended reports.
I think, this is the unattended report. I tried with rsconfig and then clicked on 'new subscription option'...and i got error (again) saying 'Subscription can not be created because the credentials used to run the report are not stored...or if linked report.....blah blah...'
I want to use subscription to this report but with 'Windows integrated security', is there any way I can do it How can I assign some user to this report without changing authentiation method and use subscription
Help me ...I am stuck, this is the last milestone in my project !!!
Thanks,
Prashant
Windows integrated security and subscription
KeeperMustDie
Subscribed reporty delivery can only use data sources configured for stored credentials or no credentials. As you noted, subscribed reports run in an unttended mode and there is no interactive user. If Windows Authentication was supported, the report would have been processed under the identity of the report server (e.g. COMPUTERNAME\ASPNET). imagine an user that otherwise doesn't have permissions to see certain data but now she gains access through subscribed delivery and you would understand that allowing Windows authentication may present a security risk. That said, you should be able to configure your data source either to use stored credentials (preferred option) or no credentials. In the later case, you need to configure a special account for unattended execution as explained here.
Tomas L
Thanks for the reply.
I will again explain my question ...please look into it
I MUST use 'Windows Integrated Security', I can see report ..but when it comes to subscription ...its doesnt allow...it shows above error :-(
Is subscription possible with 'Windows Integrated Security'
Any solution ..any hack
Thanks,
Prashant
user__2006
Thanks Teo, for prompt response.
This all issue was started because in our project we have to use windows domain authentication. I can try other options which store login info on RS DB but problem comes when a particular user changes his windows password, because we also have to change the password on RS DB. So its like work repeated and no. of users can be very large, its cumbersome task with lots of manual work. Thats the reason why those 'Store' options can not be used here.
So we wanted something that can handle this password changing thing itself, if a user changes his windows domain password, it should also be reflected in RS. This integrated security option suited for it. As RS connects to DB(from where it will fetch data) using this login.
But for subscription, looks like RS has its restrication.
Thanks for the reply,
Prashant
die fledermaus
>Is subscription possible with 'Windows Integrated Security'
It's simple - it's not possible. You can write a custom data extension to get around this but again there isn't an interactive user at the time when the subscription is processed so I am not sure what your expectations are when you say you need Windows Integrated security.
banababa
Yeah, it looks so now. Thanks for clarification !
Prashant
Swapna.B.