Configuration Error - MS CRM

We have the MS CRM installed on the same machine as our Report Server.
Sometimes (infrequently) when accessing the report manager
(http://ComputerName/reports) we are presented with the following error
message. Any Ideas on how to solve it?
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>Try to add this assembly to the rssrvpolicy.config just like the Share Point
assembly toward the end of the file. You may need to forward this to the
product support. It looks like a bug to me.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:4BBD0311-BB8B-44F0-AF7C-6A96FD1D796B@.microsoft.com...
> We have the MS CRM installed on the same machine as our Report Server.
> Sometimes (infrequently) when accessing the report manager
> (http://ComputerName/reports) we are presented with the following error
> message. Any Ideas on how to solve it?
> 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>
>|||SAcanuck, did you get this to work? I'm getting the same error message on my
server which is running CRM & Reporting Services.
Teo, I tried looking into the rssrvpolicy.config file like you suggested,
and I see Sharepoint, but I'm not sure how I would add the CRM assembly.
There's a PublicKeyBlob field which I have no idea how I find that for CRM:
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="SharePoint_Server_Strong_Name"
Description="This code group grants
SharePoint Server code full trust. ">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="1"
PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100AFD4A0E7724151D5DD52CB23A30DED7C0091CC01CFE94B2BCD85B3F4EEE3C4D8F6417BFF763763A996D6B2DFC1E7C29BCFB8299779DF8785CDE2C168CEEE480E570725F2468E782A9C2401302CF6DC17E119118ED2011937BAE9698357AD21E8B6DFB40475D16E87EB03C744A5D32899A0DBC596A6B2CFA1E509BE5FBD09FACF"
/>
What changes would I make to the above XML Node to change it from Sharepoint
to CRM?
-Joel
"Teo Lachev [MVP]" wrote:
> Try to add this assembly to the rssrvpolicy.config just like the Share Point
> assembly toward the end of the file. You may need to forward this to the
> product support. It looks like a bug to me.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
> news:4BBD0311-BB8B-44F0-AF7C-6A96FD1D796B@.microsoft.com...
> > We have the MS CRM installed on the same machine as our Report Server.
> >
> > Sometimes (infrequently) when accessing the report manager
> > (http://ComputerName/reports) we are presented with the following error
> > message. Any Ideas on how to solve it?
> >
> > 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>
> >
> >
>
>|||Joel,
See if this works for you:
1. Open C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFIG\security.config.
2. Locate and copy the entire <CodeGroup> element for
microsoft.crm.platform.types.dll.
3. Now open C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\rsmgrpolicy.config and add the <CodeGroup> element.
If you cannot find microsoft.crm.platform.types.dll in security.config, use
caspol to get its publickeyblog as follows:
CASPol -all -resolveperm microsoft.crm.platform.types.dll
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Joel Corra" <JoelCorra@.discussions.microsoft.com> wrote in message
news:CE3D587C-0480-4ABC-8816-E64B0CC18954@.microsoft.com...
> SAcanuck, did you get this to work? I'm getting the same error message on
my
> server which is running CRM & Reporting Services.
> Teo, I tried looking into the rssrvpolicy.config file like you suggested,
> and I see Sharepoint, but I'm not sure how I would add the CRM assembly.
> There's a PublicKeyBlob field which I have no idea how I find that for
CRM:
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="SharePoint_Server_Strong_Name"
> Description="This code group grants
> SharePoint Server code full trust. ">
> <IMembershipCondition
>
class="StrongNameMembershipCondition"
> version="1"
>
PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000
100AFD4A0E7724151D5DD52CB23A30DED7C0091CC01CFE94B2BCD85B3F4EEE3C4D8F6417BFF7
63763A996D6B2DFC1E7C29BCFB8299779DF8785CDE2C168CEEE480E570725F2468E782A9C240
1302CF6DC17E119118ED2011937BAE9698357AD21E8B6DFB40475D16E87EB03C744A5D32899A
0DBC596A6B2CFA1E509BE5FBD09FACF"
> />
> What changes would I make to the above XML Node to change it from
Sharepoint
> to CRM?
> -Joel
>
> "Teo Lachev [MVP]" wrote:
> > Try to add this assembly to the rssrvpolicy.config just like the Share
Point
> > assembly toward the end of the file. You may need to forward this to the
> > product support. It looks like a bug to me.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MVP [SQL Server], MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > Publisher website: http://www.manning.com/lachev
> > Buy it from Amazon.com: http://shrinkster.com/eq
> > Home page and blog: http://www.prologika.com/
> > ---
> >
> > "SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
> > news:4BBD0311-BB8B-44F0-AF7C-6A96FD1D796B@.microsoft.com...
> > > We have the MS CRM installed on the same machine as our Report Server.
> > >
> > > Sometimes (infrequently) when accessing the report manager
> > > (http://ComputerName/reports) we are presented with the following
error
> > > message. Any Ideas on how to solve it?
> > >
> > > 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>
> > >
> > >
> >
> >
> >|||Teo-
Thank you so much!!!! It looks like that has solved the problem (after
wasting a support incident with Microsoft so they could tell me that
Reporting Services and Crystal Reports can't be installed on the same
machine, and to uninstall Reporting Services to fix the error--is there any
way to get a refund on a support incident?).
The .dll for CRM was not in the security.config file, so I had to find the
assembly--in case anyone else has a hard time finding it, it is in the
assembly cache on the machine (c:\%windows%\assembly). The physical location
on my machine was
C:\WINNT\assembly\GAC\Microsoft.Crm.Platform.Types\1.2.3297.0__31bf3856ad364e35
I ran caspol on that assembly, copied the whole <codegroup> ... </codegroup>
element from the Sharepoint entry in the rsmgrpolicy.config and replaced the
publickeyblog value with the value returned by Caspol. This is the first
time since installing Reporting Services that I have been able to access both
CRM and the Report Manager at the same time, before either one or the other
would always give the error.
I am still getting another error, though, when I try to access certain pages
in Report Manager:
SQL Server Reporting Services
Error
The underlying connection was closed: Could not establish trust relationship
with remote server.
I have seen other people say they get this error and it has something to do
with certificates. We are using a home-made certificate on that server since
it is only for internal use, so we install the certificate into the browser's
root certificates and we don't have any problems accessing the site
internally. How would I get around this in Report Manager?|||Joel,
Please review the following thread:
http://groups.google.com/groups?q=certificate+group:*.reportingsvcs+author:teo&hl=en&lr=&selm=uWfcNndmEHA.512%40TK2MSFTNGP10.phx.gbl&rnum=1
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Joel Corra" <JoelCorra@.discussions.microsoft.com> wrote in message
news:3431FA6F-C887-4D18-8119-BF3680A9C3AC@.microsoft.com...
> Teo-
> Thank you so much!!!! It looks like that has solved the problem (after
> wasting a support incident with Microsoft so they could tell me that
> Reporting Services and Crystal Reports can't be installed on the same
> machine, and to uninstall Reporting Services to fix the error--is there
any
> way to get a refund on a support incident?).
> The .dll for CRM was not in the security.config file, so I had to find the
> assembly--in case anyone else has a hard time finding it, it is in the
> assembly cache on the machine (c:\%windows%\assembly). The physical
location
> on my machine was
>
C:\WINNT\assembly\GAC\Microsoft.Crm.Platform.Types\1.2.3297.0__31bf3856ad364
e35
> I ran caspol on that assembly, copied the whole <codegroup> ...
</codegroup>
> element from the Sharepoint entry in the rsmgrpolicy.config and replaced
the
> publickeyblog value with the value returned by Caspol. This is the first
> time since installing Reporting Services that I have been able to access
both
> CRM and the Report Manager at the same time, before either one or the
other
> would always give the error.
>
> I am still getting another error, though, when I try to access certain
pages
> in Report Manager:
>
> SQL Server Reporting Services
> Error
> The underlying connection was closed: Could not establish trust
relationship
> with remote server.
> I have seen other people say they get this error and it has something to
do
> with certificates. We are using a home-made certificate on that server
since
> it is only for internal use, so we install the certificate into the
browser's
> root certificates and we don't have any problems accessing the site
> internally. How would I get around this in Report Manager?
>|||Greetings Teo,
I tried the way you have indicated, but unfortunately it seems not to work.
Its highly possible that I may be making a error. I would appreciate if you
can give me some direction here.
C:\WINDOWS\assembly\GAC>CASPol -all -resolveperm
microsoft.crm.platform.ty
pes.dll
Microsoft (R) .NET Framework CasPol 1.1.4322.573
Copyright (C) Microsoft Corporation 1998-2002. All rights reserved.
ERROR: Unable to load assembly
"Teo Lachev [MVP]" wrote:
> Joel,
> Please review the following thread:
> http://groups.google.com/groups?q=certificate+group:*.reportingsvcs+author:teo&hl=en&lr=&selm=uWfcNndmEHA.512%40TK2MSFTNGP10.phx.gbl&rnum=1
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "Joel Corra" <JoelCorra@.discussions.microsoft.com> wrote in message
> news:3431FA6F-C887-4D18-8119-BF3680A9C3AC@.microsoft.com...
> > Teo-
> >
> > Thank you so much!!!! It looks like that has solved the problem (after
> > wasting a support incident with Microsoft so they could tell me that
> > Reporting Services and Crystal Reports can't be installed on the same
> > machine, and to uninstall Reporting Services to fix the error--is there
> any
> > way to get a refund on a support incident?).
> >
> > The .dll for CRM was not in the security.config file, so I had to find the
> > assembly--in case anyone else has a hard time finding it, it is in the
> > assembly cache on the machine (c:\%windows%\assembly). The physical
> location
> > on my machine was
> >
> C:\WINNT\assembly\GAC\Microsoft.Crm.Platform.Types\1.2.3297.0__31bf3856ad364
> e35
> >
> > I ran caspol on that assembly, copied the whole <codegroup> ...
> </codegroup>
> > element from the Sharepoint entry in the rsmgrpolicy.config and replaced
> the
> > publickeyblog value with the value returned by Caspol. This is the first
> > time since installing Reporting Services that I have been able to access
> both
> > CRM and the Report Manager at the same time, before either one or the
> other
> > would always give the error.
> >
> >
> > I am still getting another error, though, when I try to access certain
> pages
> > in Report Manager:
> >
> >
> > SQL Server Reporting Services
> > Error
> >
> > The underlying connection was closed: Could not establish trust
> relationship
> > with remote server.
> >
> > I have seen other people say they get this error and it has something to
> do
> > with certificates. We are using a home-made certificate on that server
> since
> > it is only for internal use, so we install the certificate into the
> browser's
> > root certificates and we don't have any problems accessing the site
> > internally. How would I get around this in Report Manager?
> >
> >
>
>sqlsql