This entry was posted on Friday, April 17th, 2009 at 1:35 pm and is filed under SQL Reporting Services. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
CRM 4 Services Migration (Including Reporting Services)
For those of you who are attempting to migrate Microsoft Dynamics CRM services to another remote server to help increase your I/O, performance or for whatever reason you like, you may find frustrated during this process.
There are a few things that you need to do first to ensure that you have a smooth upgrade. First off i would definately check out the following article to ensure that a path that is defined is the easiest for the job.
http://support.microsoft.com/kb/952934
This will assist with moving your database of Microsoft CRM 4, and reporting services. However, there is also a few steps that are not included in this document.
Just make sure that after you deploy your reporting services reports to the new migrated server that you have also double checked the login on the mscrm datasource in the reportserver directory.
You can get errors that you will not be able to connect to CRM datasource and more. Turns out that after a couple of hours fighting with checking IIS security, SQL Service accounts, CRM deployment settings, SRSS groups and regedit settings that it turns out this is the most often overlooked. 
So simple, but it can also be very aggrivating. Till next time!
Leave a Reply
You must be logged in to post a comment.
