Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications

CRM 4.0 - How to change SQL Reporting Services for Organization

Post Author: Joe D365 |

CRM 4.0 - How to change SQL Reporting Services for Organization and the steps needed is profiled in today's blog from PowerObjects, an HCL Company.

We often get how-to requests on how to change the SQL reporting services that an organization uses. This can be done out of the box quite easily and without the need to re-import the organization.

Here's how:

  1. Open crm deployment manager. You must be a 'crm deployment administrator'.
    SQL reporting
  2. Click in organizations, right click and disable the organization.
    SQL reporting
  3. Right click and 'edit organization'.
    SQL reporting
  4. Change the SRS Data Connector URL to then new server.

    SQL reporting

  5. Click Next

    SQL reporting

  6. Wait for the org to be updated – will take 2-3 mins.

    SQL reporting

  7. When it finished, right click on organization and 'enable'.
    SQL reporting

That's it. All reports will now have been published to the new srs server.

Happy CRM'ing!


By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

One comment on “CRM 4.0 - How to change SQL Reporting Services for Organization”

  1. We have installed a new SQL server for CRM and moved all DB's successfully, but we have been unsuccessful migrating to the new SSRS site. We keep getting an error stating the setup failed to validate to the new SRS site due to error HTTP status 401: unauthorized. Does anyone know the proper IIS security setting to proceed with this move? Much appreciated. -Thanks

PowerObjects Recommends