Note When RTD server runs on a remote server, the RTD server must be an .exe.
This article describes how to configure DCOM on both the remote server and on the local client computer to enable this functionality.
Configure DCOM on the remote server
- Register the RTD server on the computer that will serve as the remote server. Note that Excel must be installed on both the remote server and the local client computer.
- On the taskbar, click the Start button, click Run, type Dcomcnfg.exe, and then click OK to start the DCOM configuration utility.
- On the Default Security tab, edit Default Access Permissions and add any users that are permitted to access the RTD server. For a public RTD server, add Everyone to allow anonymous access to the RTD server. Set Type of Access to Allow Access.
- Add the same entries to the Default Launch Permissions list, and set the Type of Access to Allow Launch.
- Add the same entries to the Default Configuration Permissions list. For most RTD servers, setting the Type of Access to Read should be sufficient. For RTD servers that use the registry to store settings, it may be necessary to set the Type of Access to Full Control.
Configure DCOM on the local client computer
- Register the RTD server on the local client computer. For Excel to request the RTD server on the remote server, only the ProgID and CLSID need to be registered.
- Run Dcomcnfg.exe on the local client computer.
- On the Default Security tab, edit the Default Access Permissions, and add the Everyone account. The RTD server must make calls to Excel to notify it when new data becomes available. Because of a feature of Windows security, the so-called "One Hop Rule," the RTD server makes its call back to Excel as an anonymous user. If the Everyone account is not listed under Default Access Permissions, the RTD server is unable to communicate with Excel, and RTD formulas in Excel return #N/A.
Article ID: 285888 - Last Review: Mar 23, 2009 - Revision: 1