Link to home
Start Free TrialLog in
Avatar of SOS_Helpdesk
SOS_HelpdeskFlag for Canada

asked on

Office Excel 2007 - Server 2008 Automation Permission problem

Hello,

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?

Thanks!
Avatar of mccarthybri
mccarthybri
Flag of United States of America image

Im confused why are you running server 2008 and using office on it?  I would say try to uninstall excel 07 and reinstall it.  you could also try another login and see if its just the profile acting up.  
Avatar of SOS_Helpdesk

ASKER

Thanks for your reply.

I need to use office on the server to build word, excel, and powerpoint files. The whole process is automated and microsoft explicitly said they do not support this and have a support page explaining why. We got this to work perfectly in Server 2003 so it should be the same in Server 2008. I think it's just some permissions 2008 have that we need to grant specific users/groups and we are good to go. I was hoping someone here can point me in the right direction of what permissions I'm overlooking.

I tried reinstalling office but no luck. I also tried using several accounts with different permissions, no luck.

Please help!
ASKER CERTIFIED SOLUTION
Avatar of SOS_Helpdesk
SOS_Helpdesk
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial