Notifications
Announcements
No record found.
Hi,
We used to have an email subscription to Historical Aged Receivables SSRS report on the older version of GP (2015) and SQL (2014).
The subscription stopped working after we upgraded to GP 2018 and SQL 2019. The SSRS report pops a message about credentials that need to be stored. The issue is that one of the data sources of the Historical Aged Receivables report is a Model and would not allow storing credentials.
Is there a way around that?
Thank you,
Oleg.
Good Afternoon Oleg,
Just completed this update last week. Updating the data source worked with out issue, but I was getting the same issue about not allowing storing credentials.
Not sure what the client's IT provider changed on the server but this was the response I got from them about my issue.
-- response
Apologies I neglected to turn off threat lockers,
I have put it in learning mode for one week to ensure no more issues
--
Whatever they changed, it removed the message allowed me complete my SSRS changes, the server's zero trust policies on the SQL server was causing some interesting issues.
Hope this points you in the right direction.
Sonny Pawchuk
Thank you for the answer, Sonny,
However, my issue is not just about storing credentials. It is about creating an email subscription to the report that uses GP Model as data source. It is that Model that has no place to enter credentials, preventing from creation of subscription.
Cheers,
If you haven't, I'd ask this in the SQL Server forums, specifically SQL Reporting Services as subscriptions are handled more by that support team than Dynamics GP. They would be the experts in that area.
Thanks
Thank you, Derek,
Will try that.
Best,
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader
