Announcements
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
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
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.
Thank you
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
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.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 666 Super User 2026 Season 1
Abhilash Warrier 280 Super User 2026 Season 1
Martin Dráb 207 Most Valuable Professional
