Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding a subscription whilst many users can still view a report Expand / Collapse
Author
Message
Posted Monday, May 14, 2012 3:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:36 AM
Points: 9, Visits: 45
Hello

I have a report which several users view, including myself. I have a request to set up a subscription so the report is delivered daily. However, when I go to set up the subscription I have the error message Subscription cannot be created because the credentials used to create the report are not stored...

I can change the credentials in the data source to custom using my username and password and create the subscription but then the other users would not be able to see this report.

How would I go about setting up a subscription so that several users can still view the report and the subscription can still deliver?

Thanks for any help/understanding.
Post #1299416
Posted Monday, May 14, 2012 3:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 8, 2014 1:45 AM
Points: 5,221, Visits: 5,120
If you change the data source to use your credentials, then each user which runs any reports which use that data source will impersonate your credentials.

If you dont want this to happen, you would need to setup the unattended execution account via the SSRS configuration manager which it will use to run the subscriptions.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1299420
Posted Monday, May 14, 2012 3:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:36 AM
Points: 9, Visits: 45
Thanks Antony

The only issue I suppose then would be if I didn't change my password for the datasource when I change my Windows password, or if I was suddenly off sick or away and my password expired, then no user would be able to view the report.

Is this the recommended way or would you suggest teh second option?
Post #1299424
Posted Monday, May 14, 2012 3:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 8, 2014 1:45 AM
Points: 5,221, Visits: 5,120
Yes you are correct that if your password expires then the data source will fail to work.

Personally I would go for the second option, and set it as a user whos password will never expire. That way you still maintain all traceability of who has done what.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1299425
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse