SRS and MSCRM (1.2) on 1 server
The people who have tried to install both SRS and MSCRM on the same server within the same website in IIS, they must know the message:
Server Error in '/Reports' Application.
--------------------------------------------------------------------------------
Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: Assembly microsoft.crm.platform.types.dll security
permission grant set is incompatible between appdomains.
Source Error:
Line 5: <assemblies>
Line 6: <add assembly="Microsoft.Crm.Platform.ComProxy, Version=1.0.0000.0, Culture=neutral, PublicKeyToken=31bf3856ad34e35">
Line 7: <add assembly="Microsoft.Crm.Platform.Types, Version=1.2.3297.0, Culture=neutral, PublicKeyToken=31bf385ad364e35">
Line 8: </assemblies>
Line 9: </compilation>
In this case MSCRM is in the root of the website and reporting services in the folder "/Reports".
This can be solved by modifying the web.config of MSCRM. Add this code to the web.config just before the <appsettings>part of the file. Make that you modify the PublicKeyToken and if necessary also the versions!
<!-- Support for SQL Reporting services -->
<location path="Reportssrs">
<system.web>
<compilation debug="true" defaultlanguage="C#">
<assemblies>
<remove assembly="Microsoft.Crm.Platform.ComProxy, Version=1.0.0000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
<remove assembly="Microsoft.Crm.Platform.Types, Version=1.2.3297.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
</assemblies>
</compilation>
<pages enablesessionstate="true" validaterequest="false" enableviewstate="true">
</SYSTEM.WEB>
</location>