XL Reporter fails to start Excel if RDP user is not an administrator

[mario_carpini]

Hi,

I have been struggling for a week with this problem.

We are running SAP B1 2007 SP1 PL08 on windows server 2003.

We have the SAP B1 client running on Windows Server 2008 R2 RDP (terminal server) as a remote app.

Excel 2007 is loaded on the RemoteDesktop server (Terminal server)

When a standard domain user is running SAP B1 as a remote app and attempts to open an XL report we get the error message

"Security Settings in Microsoft Excel Prohibit XL reporter from running"

I know this message has been covered before and I know the fix (when not using SAP as a remote app) is to tick the check box in the Excel trust centre "Trust access to VBA object model"

This works on standard client install, i.e SAP B1 client loaded on the users machine.

This is done and many permutations of various settings in the trust centre have been tried.

The only way we can get Excel to open when selecting an XL report from SAP B1remote app, is to put the remote user into the local administrators group on the RDP server (terminal server), however this is not appropriate. So does anyone know what setting I am missing. It seems to be some permision related thing , the Error message seems to be not entirely acurate.

I have tried giveing remote_desktop user full permissions to the entire drive on the RDP (terminal server) where Excel and SAP are located but getting no where.

Our Support organisation to which we pay a support fee too is unable to solve this issue after 1 week of waiting.

Any help would be greatly appreciated.

[Former Member]

Have your administrator put the TS into install mode, then start SAP & use Tools>XL Repoerter to open the XL Reporter menu. This should load the proper registry settings so other user can properly run the software.

[mario_carpini]

Thanks for the Response,

Unfortunately this made no difference.

I went to the RDP server (Terminal server) Windows 2008 R2.

Logged into the RDP servers console desktop as administrator.

Changed user to install mode eg c:> change user /install

Started SAP B1 on the RDP server desktop.

Logged into SAP B1 as an administrator.

Started XL reporter from the tools menu. Nothing different appeared to happen.

Went to a client machine and logged into SAP via Remote App as a standard user.

Same error message appears when trying to open an XL Report.

Do you know which registery settings should be set?

[Former Member]

When you started SAPB1 did you start using Right Click>Run as Administrator?

[mario_carpini]

Hi,

No that would be missing the point. We dont want Domain users to have administrator permissions.

[Former Member]

Hi Mario,

I say your post on trying to get SAP Business one to work as an RDP Remote App. It seems like the ideal way to run SAP B1. http://social.technet.microsoft.com/Forums/en-US/winserverTS/thread/2d4463f8-9a8b-4a0a-a669-1f2e756b...

Did you ever get any success?  Which partner are you using (are you still using them)?