Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Removing integration w...
Finance | Project Operations, Human Resources, ...
Answered

Removing integration with SSRS

(0) ShareShare
ReportReport
Posted on by Igor_CF 165

Hello!

The process of integration of Dynamics SL with SSRS is well described and not too complicated. But I cannot find anywhere any instructions on removing the integration. 

We use only a small subset of features from SL and our team did not find a use for the integration. I wouldn't bother looking for a way to remove if we wouldn’t experience annoying sync delay when we create, update or remove a user. Sometimes we get time out on sync. Not a big deal, but I’m wondering if someone knows the way.

Regards

  • Suggested answer
    Igor_CF Profile Picture
    Igor_CF 165 on at
    RE: Removing integration with SSRS

    Thank you Marc!

    Confirmed, removing the record for SSRS server from the dbo.RS_ReportServer fixed my issue and now Dynamics SL doesn't try to connect to SSRS every time I create or delete a user.

  • Verified answer
    MARC_ Profile Picture
    MARC_ 620 on at
    RE: Removing integration with SSRS

    Do you have web apps installed - my understanding is that this was used primarily with web apps.  I could be wrong, though....Where are you getting the error / notice? 

    I guess you could always back it up to be safe and the delete it.  Running through the report server deploy would also put the record back into the table. 

    select *
into rs_reportserver_bak
from rs_reportserver

delete from rs_reportserver

  • Igor_CF Profile Picture
    Igor_CF 165 on at
    RE: Removing integration with SSRS

    Hello Brad!

    Thank you for your reply, sorry it took me a long to reply back.

    All you explained is done already, the SSRS server does not exist anymore.

    The problem is that SL is still looking for a connection to SSRS. If I go to SL Report Server Configuration Console, the entry for SSRS is there and I can only change SSRS URL, I cannot delete it. So SL is trying to connect to nonexisting SSRS no matter what.

    I see the record for SSRS in the system DB dbo.RS_ReportServer, but I’m hesitant to delete the record as I do not know if there is something else I can break.

    Or it’s very poor design not allowing to remove, or there is another way to remove the integration from SL and I don’t see it.

    Dynamics-SSRS.jpg

    Thank you

  • Suggested answer
    Brad_Woodruff Profile Picture
    Brad_Woodruff 35 on at
    RE: Removing integration with SSRS

    Igor,

    Yes, there is a simple way to remove the integration from SSRS.

    SSRS connects directly into SQL to read the information. Look at your data sources on the SSRS server.

    Lookup the user that connected to your SL SQL database in the SSRS data sources.

    Delete the data sources, data sets, and reports (if any) from SSRS.

    If a custom user was used, determine if it was only used for SSRS->SL SQL database.

    Delete the user from the SL SQL databases users and the SQL server users.

    Thanks,

    Brad Woodruff

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.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans