Excel的COM自动化停止时,用户注销工作 [英] Excel COM automation stops working when user logs off
问题描述
我已经开发了使用Excel 2007中COM自动化将一些XLS文件服务器应用程序。它开始作为一个Windows数据中心实例的服务,在自己的用户中运行,我不得不改变DCOM安全设置(推出的交互式用户),以使其工作。
I have developed a server app that uses Excel 2007 COM automation to convert some xls files. It is started as a service on a Windows Datacenter instance, running under its own user, and I had to change DCOM security settings ("launch as interactive user") to make it work.
问题是,当我注销(通过RDP),它停止工作。我登录,它再次工作。
The problem is, when I log off (via RDP), it stops working. I log on, it works again.
有没有人有同样的问题?我很高兴约在这一点上的任何帮助。
Has anyone had the same problem? I'm glad about any help at this point.
推荐答案
好了,我不能让Excel中没有一个交互式的用户操作,无DCOMCNFG挂羊头卖狗肉的量会怎么做。于是我简单地配置自动登录的服务所(见 http://support.microsoft.com/kb/315231运行的用户一>的说明)。
Ok, so I couldn't get Excel to operate without an interactive user, no amount of DCOMCNFG trickery would do. So I simply configured autologin for the user the service is running under (see http://support.microsoft.com/kb/315231 for instructions).
这有服务器启动时,该用户将登录一个交互式控制台会话的效果。与RDP会话,这是永久性的,使Excel的快乐。
This has the effect that on server bootup, that user will login as an interactive console session. Unlike RDP sessions, this is permanent and makes Excel happy.
对于普灵魂其他线索谁也做同样的事情:
Other hints for the poors souls who have to do something similar:
- 创建文件夹C:\\ Windows \\ System32下[或Syswow64资料] \\ CONFIG \\ systemprofile \\桌面
- 确保默认打印机配置为使用该服务下运行的用户
- 更改DCOMCNFG设置(MMC -32,加上组件服务)的Excel使用交互式帐户运行
- 更改全局DCOM默认为允许本地访问,本地启动以及本地激活的服务下运行的用户
祝你好运!
这篇关于Excel的COM自动化停止时,用户注销工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!