Post reply

[SSRS Subscriptions] : Credentials Stored Securely in the report server won't work

  • March 24, 2014 at 5:32 am

    #289722

    Hello everyone ,

    I designed a report on BIDS where i have creating an shared datasource connected on SQL SERVER account "sa" .

    So i can see the report worked on report server but i can't subscribe that report , i don't why.

    I did different step to try to solve my issue.

    Solution 1 :

    - Check if my sa account can connected on sql server and he can do it.

    - I gave him the role of "sysadmin and public" for role server

    - On databases , he got different roles like db_owner and public.

    - When i connected on reportServer , look at the credential on sharedDataSource,

    i checked the " Credentials Stored Securely in the report server"

    I filled my sa authentification and checked " impersonate The authenticated user ... "

    Connection was in successfull

    - Check if my reports used the shared connections and he used the shared connection

    - Check if reports works and he worked it

    but

    reports can't subscribe

    Solution 2 :

    Instead to use an Database SQL user i used an Windows User

    Instead to checked the "impersonate The authenticated user ... "

    i checked " Use a Windows Credentials ..."

    Connection was successful

    But

    Reports can't subscribe

    I m searching different solution but i don't why report can't be subscribe

    If you got suggestion i will be interested

    Thanks for your help

    Hani

    Ps:

  • March 24, 2014 at 5:54 am

    #1699491

    Uncheck the impersonate checkbox. I have never checked that and it works.

    Russel Loski, MCSE Business Intelligence, Data Platform

  • March 24, 2014 at 6:30 am

    #1699504

    hi Russel Loski

    well , i did what you told me.

    i got the same error message " subscription cannot be created because the credentials used to run the report are not stored"

    I don't know why i always that same message.

    i checked on reports logs. I don't have more détails

    Hani

  • March 24, 2014 at 8:21 am

    #1699542

    Hello,

    I did another step but unfortunately it doesn't seems work

    Solution 3 :

    i used reporting Services Configuration Manager .

    I deleted all content on stored connexion

    I write credential

    But it doesn't work

    I Wonder if it's possible to write credential on web.config from ReportServer or web.config from Report mybe there are also reportserver.config

    Have you ever test that other solution ?

    Hani.

  • March 24, 2014 at 9:37 am

    #1699577

    Solution solved

    thx for help

    hani

  • February 4, 2015 at 9:21 am

    #1775375

    and well?

    🙂 we are curious of how you solved it 🙂

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply