Friday, January 6, 2017

SSRS - Subscription can't be created or edited

A Reporting Services subscription is a configuration that delivers a report at a specific time or in response to an event, and in a file format that we specify. Subscriptions can be used to schedule and automate the delivery of a report and with a specific set of report parameter values. 

"Subscriptions cannot be created because the credentials used to run the report are not stored or if a linked report, the link is no longer valid" is the very generic error in SQL Server Reporting Services. This error occurs because SSRS requires a Login to connect to the data source to process the report whenever subscription will be occurring at its scheduled time.
If you are creating your report with the shared datasource and your datasource is built up on the Use Windows Authentication (Integrated security) as given below image then you will not able to create subscription on that report and will face the above error.
Shared Data Source is not allowed in Report Subscription and before creating subscriptions, scheduled report needs to know which credentials we want to run with, when producing the reports.
If you want to create report subscription on the report then I would recommend you to store the credential security into report level and use embedded connection instead of shared data source reference. To sort out this issue, we are doing the following settings step by steps.
1.In development studio, right click on the Data Sources and choose Data Source Properties from report data as given below:

2.In Data Source Properties, checked Embedded connections, Type Microsoft SQL Server and click on Edit button as given below:

3.After click on Edit button, it will open Connection Properties window where you need to fill Server name, checked Use SQL Server Authentication and fill user credentials, select or enter a database name and click on test connection. If Test result alert shows succeeded then click on OK button as given below:
4.Click on OK button on Connection Properties window. In Data Source Properties window’s Credentials tab, you can see that your report connection is set on Use this user name and password as given below:

5.Click on OK button and deploy your report on the report server again and open the data source of the report and set custom data source as given below:
 

6. After testing the connection string, click on Save button. Choose the Subscription, where you can see the enabled New Subscription.


After following the all the above steps, you are able to create "New subscription" or "New Data-driven Subscription" with the help of report manager.

27 comments:

  1. You have done a great job on this article. It’s very readable and highly intelligent. You have even managed to make it understandable and easy to read. You have some real writing talent. Thank you.
    Managed Service Providerfox valley area

    ReplyDelete
  2. I intended to send you the little word to finally give thanks the moment again considering the pleasing suggestions you have contributed above. This has been simply remarkably open-handed with people like you to grant unreservedly what most of us might have marketed for an electronic book to help make some bucks on their own, even more so given that you might have tried it in case you decided. These tips additionally served like a fantastic way to be certain that other people online have the same dream much like my own to know significantly more with reference to this problem. I believe there are some more fun periods in the future for individuals that scan through your blog. china sourcing agent

    ReplyDelete
  3. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. siem

    ReplyDelete
  4. There are a few issues with data handling that is why people become frustrated because they don't know the ultimate way to handle the info complexity and its own management. So for conquering this kind of problem individuals retain the best data scientist from this amazing the original source Active Wizards site who can certainly solve their all kind of data managing problems.

    ReplyDelete
  5. Actually, you're wrong. I have DOZENS of subscriptions on reports, and those reports ALL use a shared data source. I've been using shared data sources for years. The whole point of the shared data source is repeatability. Why would someone want to create a single data source for every single report they write?

    I ran into this error after deploying a new report that used a shared data source, so there is something else going on. I deployed an older report that uses a shared data source and I have zero problem creating a subscription

    I'll post what I eventually find.

    ReplyDelete
  6. If you are unable to reach your target audience-those most likely to be interested in what you are selling-you will not be able to reach the number of people necessary to truly become successful. digital lifestyle

    ReplyDelete
  7. Superbly written article, if only all bloggers offered the same content as you, the internet would be a far better place..
    john faraday

    ReplyDelete
  8. If you really want you can look the other way and not talk about it. The best thing you can do is become relevant with yourself and faithful with your own morals. Generally this will lead to a mistaken and unproductive life. incasso credifin-nederland.nl

    ReplyDelete
  9. I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. high quality Automatic Recirculation Valve

    ReplyDelete
  10. For users looking for a device that delivers more and combines business and leisure opportunities, this may be Microsoft's only competitive advantage.Best Windows USA System

    ReplyDelete
  11. Hi there, simply was alert to your blog via Google, and found that it’s really informative. I’m going to watch out for brussels. I’ll be grateful if you happen to continue this in future. Numerous other folks will likely be benefited out of your writing. Cheers! www.trainingroomsg.com

    ReplyDelete
  12. Thanks a lot for sharing this with all of us you actually know what you are talking about! Bookmarked. Kindly also visit my web site =). We could have a link exchange agreement between us! Total Quality Management Company

    ReplyDelete
  13. I exactly got what you mean, thanks for posting. And, I am too much happy to find this website on the world of Google. John

    ReplyDelete
  14. hey all, I used to be just checking out this blog and I actually admire the premise of the article, and don’t have anything to do, so if anybody wish to to have an engrossing convo about it, please contact me on AIM, my name is heather smith займ на киви кошелек

    ReplyDelete
  15. It’s amazing in support of me to truly have a blog site, which will be valuable meant for my knowledge. Thanks admin. PARALLEL PROFITS STEVE CLAYTON

    ReplyDelete
  16. Be it basic SEO tasks such as keyword research and rank tracking, dedicated SEO tasks such as social media tracking and Local SEO, or analytical tools like performance tracking and competitor research, Web CEO is perfect for all types of niche backlinks requirements. SEO Powersuite is a combination of four tools; Link Assistant, the Website Auditor, The Rank Tracker, and SEO Spyglass.

    ReplyDelete
  17. Business coaching can actually bring the much-desired changes to your business. Coach is a word which is derived from "kocsi", a Hungarian name that means [link] Today, however, the word has a wider use and it basically means transportation of people from one point to the other where they desire to be.

    ReplyDelete
  18. Also, a lot of restaurants opt for temporary fencing to create a visually appealing outdoor sitting area for its guests. national car wrap

    ReplyDelete
  19. I really appreciate this post. Anti Termite Abu Dhabi have been looking all over for this! Thank goodness I found it on Bing. You’ve made my day! Thanks again

    ReplyDelete
  20. The type of insurance that helps maintain a business while the primary revenue generator is convalescing is called Business Overhead Expense (BOE) Disability Insurance (DI). The probability that a person will become disabled for three months or longer is a little over 25%, which puts a business at risk of insolvency in the event the business owner cannot work. This article discusses the key reasons for purchasing BOE, what it covers, the benefits, limitations, and the factors that go into calculating a premium. vladimir vrbaski republika

    ReplyDelete
  21. educator, Android Mods. Although Sue had a list of discharge instructions in her hand, she paused and

    ReplyDelete
  22. I’d must seek advice from selfie filter here. Which is not some thing Which i do! I enjoy reading an article that may make people feel. Also, thanks for allowing me to comment!

    ReplyDelete
  23. Youre so cool! I dont suppose Ive learn anything like this before. So nice to find any person with some authentic thoughts on this subject. realy thank you for starting this up. this website is something that is wanted on the internet, someone with a little bit originality. useful job for bringing something new to the web! Bubble Shooter 5

    ReplyDelete
  24. This is a dubious subject region anyway it has been recognized that they exist inconsistencies in IQ appraisals between social, racial alongside sexual orientations classifications. Paradoxically, elective research give contentions to got obliterated this sort of studies.מבחן אישיות חינם

    ReplyDelete
  25. A home is made of more things than four walls. There are so many upgrading to be done in the home from time to time. Home improvement is so many things. Since it involves so many things, it requires a lot of finance also. You may not always have access to finance but you can always get a home improvement loan. Getting a home improvement loan is simple and besides providing comfort, it is increasing the equity present in your home. Get a home loan today for creating that much needed personal space Bank Internships Summer 2019

    ReplyDelete

Popular Posts

Get Sponsored by Big Brands