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
Thanks
V Philip
