Link to home
Create AccountLog in
Avatar of Wade Knox
Wade KnoxFlag for United States of America

asked on

SSRS shared data source connection does not have credentials and will not allow subscription to be setup?

I have created a report using a shared db connection in visual studio - I have deployed the report to report server 2008 and now i wish to set it up to be emailed as a report but it keeps telling me the credentials are not saved for this db connection type - why cant i set this up to run automatically with my shared db connection?
ASKER CERTIFIED SOLUTION
Avatar of twol
twol
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Wade Knox

ASKER

what is report manager? visual studio? SQL Server Reporting Services?

Thanks for your help!
Report manager is the browser based report display tool distributed with SSRS.
ok i understand but how do i set this up automatically when i create a report in visual studio or am i always goping to need to do this step if i want to setup a subscription on any future reports?
how does this browser based service account differ from the current report server database credentials and the execution account credentials in reporting services configuration manager?
In SSBS Dev Studio, I think you can go to properties on the shared connection in  and tell it to save the credentials and redeploy the shared connection...sorry I am not in front of the product at the moment.
SOLUTION
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks!