Office Excel 2007 - Server 2008 Automation Permission problem
Posted on 2009-12-23
I know server automation is not supported by microsoft, and that is also why I'm asking this here. So I have this excel automation going on in Server 2003 and everything works fine. Excel starts up on the server, does something and it'll close down.
Different story on Server 2008. Seems to have way more security issues. Word and PowerPoint worked fine, but when Excel starts up, it gets stuck. The process is running but just hangs. This is when I run a webpart on sharepoint on my laptop. Now if I log onto the server and run the webpart on the server's browser, everything works fine again. So this must have something to do with permissions.
I opened up dcomcnfg and changed launch/access permissions on the Office Excel component but still no dice. Something I found interesting is when I changed the registry (HLM\software\microsoft\windows nt\currentversion\profilelist\s-1-5-18\profileimagepath) to point to C:\Users\-Myself- instead of the default %systemroot%\system32\config\systemprofile, it works for me! and noone else. That is probably the user profile is only accessible for me.
I've probably tried more stuff but don't remember what. Anything else I can try?