[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Office Excel 2007 - Server 2008 Automation Permission problem

Posted on 2009-12-23
6
Medium Priority
?
700 Views
Last Modified: 2012-08-14
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!
0
Comment
Question by:SOS_Helpdesk
  • 2
3 Comments
 
LVL 12

Expert Comment

by:mccarthybri
ID: 26130366
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.  
0
 

Author Comment

by:SOS_Helpdesk
ID: 26138071
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!
0
 

Accepted Solution

by:
SOS_Helpdesk earned 0 total points
ID: 26181897
Solution I've found is to go into DCOMCNFG's COM Security and give Access Permission and Launch and Activation Permissions to the user or group that uses Excel. Done!
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question