Wrox Programmer Forums
|
ASP Forms As of Oct 5, 2005, this forum is now locked. Please use "Classic ASP beginner" at http://p2p.wrox.com/forum.asp?FORUM_ID=54 or "Classic ASP Professional" http://p2p.wrox.com/forum.asp?FORUM_ID=56 instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP Forms section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 5th, 2003, 04:15 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 101
Thanks: 0
Thanked 0 Times in 0 Posts
Default Permission denied when access excel obj

We're running a web application that's supposed to extract data from an
 Excel sheet into a database. For this, we use an ASP pages. In the ASP page, we create a VB object. This is where the error occurs,
 and it also happens if we use the Set obj = New Excel.Application
syntax.We installed the excel software in the server login as administrator.

In client machine if user(client) have the administrative previliges , when using IE asp page works fine .if user doesn’t have administrative previliges getting 'Permission denied' on the
 creation of the Excel application object.

 We've already tried to add the IUSR_-account to the Administrators group but still same problem.

In IIS under security tab if I change anon access user from IUSR to a domain account which is having administrative previliges its working fine. But I don’t want to do this.Instead of assigning administrative account is there any way to do or what previliges I need to run this excel object ?if I know this I can create one new account and I can assign this account in anonymous account.

I hope I cleared my problem pl help me.


 
Old January 21st, 2005, 09:09 AM
Registered User
 
Join Date: Jan 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

From command prompt type "dcomcnfg.exe" [DCOM configuration tool]
You will see 'Distributed COM Configuration Properties' window.
On 'Applications' tab from 'Applications' list box, double click on 'Microsoft Excel Application'
Select 'Security' tab
Select 'Use Custom Access Permission' radio button option and click on 'Edit' button.
On the 'Registry Value Permissions' window make sure to add 'ASPNET' local user OR user running ASP.NET process on local machine.
Select OK after adding ASPNET user above
On the same tab (Security) select 'Use Custom Launch Permissions' and click on 'Edit'
On the 'Registry Value Permissions' window make sure to add 'ASPNET' local user OR user running ASP.NET process on local machine.






Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP & Excel - Permission denied: 'CreateObject' shamigc Classic ASP Components 1 May 9th, 2006 06:58 PM
(0x800A0046) Permission denied,not IIS permission! David Hay Classic ASP Basics 3 April 30th, 2006 10:47 PM
Create Excel.Chart and Save to MS Access OLE Obj kirkgomez Access VBA 1 December 29th, 2005 08:27 AM
Permission denied tksarun Classic ASP Components 0 March 11th, 2005 03:01 AM
Permission Denied einstein Linux 1 December 10th, 2003 09:49 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.