Knowledgebase: Pegasus Opera
XRL Add-In Not Appearing in Excel Ribbon for a Terminal Server User
Posted by Claire Craig, Last modified by Claire Craig on 25/03/22 15:49

When XRL is installed in the RDS environment to then apply the Infor Q&A (C:\Program Files (x86)\Infor\Query and Analysis 'ExcelAddinRemoveAdd function) to the users Excel Ribbon ensure to carry out the following:

1. Ensure full/read write permissions to the c:\programfilesx86\infor and c:\programfilesx86\pegasus and c:\programdata\pegasus folders

2. On the RDS server, ensure the user has been added to the 'Local Administrators Group' found in Local User and Groups

3. Ensure to log user off/on the RDS session to apply the above

4. Then run the C:\Program Files (x86)\Infor\Query and Analysis 'ExcelAddinRemoveAdd function

5. Then run the CASPOL commands below via CMD (however check what version of .net framework is in place and replace the v2.0.50727 with what is in the current C:\Windows\Microsoft.NET\Framework folder)

    C:\Windows\Microsoft.NET\Framework\v2.0.50727\CasPol.exe -m -ag 1 -url "c:\Program Files (x86)\Infor\Query and Analysis\Infor.QAA.Ribbon.dll" FullTrust

    C:\Windows\Microsoft.NET\Framework\v2.0.50727\CasPol.exe -m -ag 1 -url "file://\\GES-RDS-001\C$\Program Files (x86)\Infor\Query and Analysis\Infor.QAA.Ribbon.dll" FullTrust

6.  Check if the XRL is now appearing in Excel

7.  Then remove the user from the 'Local Administrators Group' 

8.  Log user off and back on and check if XRL is still appearing ok


Additional Note:

Needing to run the Caspol was found when deploying RDS's for GES because the C:\ drive is locked down on the user files so both of the above caspol's needed ran.

This is due to Code Access Security Policy needs to be set machine wide. I suspect the installer might be setting it on a user level, but I don't know. Run from command line (not powershell), effectively tells .NET to trust anything in that folder.

(this was advised by David Archibald in case of any questions or queries)

 caspol cmd.txt (0.11 KB)
(2 vote(s))
Not helpful

Comments (0)