locked
How to Clean Dynamic CRM Origination’s Database, Reports, AD OU & Users? RRS feed

  • Question

  • Hi,

    I am a SQL DBA. My company is using MS Dynamic CRM 4.0 but unfortunately there is no Administrator for CRM. Some developers are there and they customize the CRM as requested by clients. around 200 originations exist in my CRM (multi-tenancy). so each origination having its own SQL Server Database, Report Folder in SSRS, OS & Users in AD.

    Now we want to clean around 150 originations from CRM. Please suggest what would we the best method to clean Database, Reports, OS from CRM.

    Can I manfully Drop Database from SQL Server, Delete Folders from SSRS using Report Manager, Delete OU from Active Directory. Is this method correct?

    CRM server did not show the reports when I try to open http://localhost/Reports and also Report Manager did not respond.

    Please help!

    With Respectfully,

    Ramdas


    Ramdas Singh
    Friday, September 24, 2010 1:17 PM

Answers

  • Use the CRM deployment manager to delete you organisations first. then you can go and delete the databases, OU's, report folders and users. you will also have to delete the OU groups under the Security->Users within SQL management studio.

    when you tried http://localhost/Reports, where you on the server. If so, does the reports website show? If it does then you can click on the Show Details in the top right of the grid to have the folders displayed.


    MSCRM Bing'd - http://bingsoft.wordpress.com

    Check out the CRM 4 to CRM 2011 JavaScript Converter Tool
    • Marked as answer by Ramdas Baghel Friday, September 24, 2010 1:52 PM
    Friday, September 24, 2010 1:43 PM
    Moderator

All replies

  • Use the CRM deployment manager to delete you organisations first. then you can go and delete the databases, OU's, report folders and users. you will also have to delete the OU groups under the Security->Users within SQL management studio.

    when you tried http://localhost/Reports, where you on the server. If so, does the reports website show? If it does then you can click on the Show Details in the top right of the grid to have the folders displayed.


    MSCRM Bing'd - http://bingsoft.wordpress.com

    Check out the CRM 4 to CRM 2011 JavaScript Converter Tool
    • Marked as answer by Ramdas Baghel Friday, September 24, 2010 1:52 PM
    Friday, September 24, 2010 1:43 PM
    Moderator
  • gr8, now when I try to http://localhost/Reports in IE on CRM server it prompts me enter to user name password and then it accept. but did not show Report Manager to manage reports it just showing in-progress in status bar of IE. I am good in SSRS designing and administering  but my CRM Server Report Manager does not opening. Just showing progress in status bar on IE.

    Please suggest what are the best books, articles, webcast to understand the architacture of CRM 4 in deep. I am going to take approval to my manager to purchase below books.

    Working with Microsoft Dynamics(TM) CRM 4.0
    Programming Microsoft Dynamics CRM 4.0

    are these books help me to become CRM 4.0 Adminstrator?

    With Respectfully,

    Ramdas

    MCDBA

     


    Ramdas Singh
    Friday, September 24, 2010 2:02 PM