CRM 4 re-deployment problem with reports RRS feed

  • Question

  • We have a test CRM server which worked well and now we want to move it a production server.

    Here is what I did.

    -Moved SQL database

    -Re-Deployed CRM

    And everything works well except for the report. For some reason the Report Server Data Source changes its setting automatically.



    I have set the MSCRM_DataSource setting to be (On the Report Server)

    Name: MSCRM_DataSource

    Hide in list view –checked

    Enable this data source -checked

    Data Source Type: Microsoft SQL Server

    Connection String: Data Source=”SERVERNAME”;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI

    Connect using: Windows integrated security


    With the above settings the reports works well.


    But later maybe after a couple of hrs or a day or the next time a report is generated the MSCRM_DataSource setting changes to


    Data Source Type: Microsoft SQL Server Analysis Server

    and the report wont work .

    Can you please help me with this

    V Philip

    Tuesday, December 1, 2009 10:16 AM


  • Did you tried to reinstall SSRS CRM Connector. Do you have valid servernames in registry on the SSRS server ?
    Check logs on the CRM and SSRS servers.
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Tuesday, December 1, 2009 5:00 PM