Step by Step: Upgrading CRM 2011 RC – CRM 2011 RTM

1.                  Uninstall the RC

Uninstall CRM 2011 RC using add or remove programs

Uninstallation of CRM 2011 RC has been finished.

 2.       Install to existing databases using the RTM bits

Now run the CRM 2011 RTM installation wizard

CRM 2011 RTM installation finished.

Now download the RTM Patch (KB 2461082) Click!

 3.      Apply the RTM Patch (KB 2461082) against the RTM server. This will enable you to import      RC organizations if needed.

Installing the Outlook update patch

Installing Reporting server Extension patch

4.Run the SQL Script from KB 2461082 against any Microsoft Dynamics CRM 4.0 organizations that were upgraded to Microsoft Dynamics CRM 2011 while the server was using RC bits.

here is the SQL Script

delete from UserQueryBase where QueryType = 256 and ReturnedTypeCode = 2 and (FetchXml is null or LEN(FetchXml) = 0)



insert into UserQueryBase



(UserQueryId, Name, Description, ReturnedTypeCode, QueryType, FetchXml,



ColumnSetXml, LayoutXml, OwningBusinessUnit, ModifiedBy, ModifiedOn, CreatedBy, CreatedOn,



StatusCode, StateCode, OwnerId)



Select NEWID(), Name, Description, 2, 256, FetchXml,



ColumnSetXml, LayoutXml, OwningBusinessUnit, ModifiedBy, getutcdate(), CreatedBy, getutcdate(),



StatusCode, StateCode, OwnerId from UserQueryBase where QueryType = 16 and ReturnedTypeCode = 2 and ParentQueryId is null



Go