Text 254, 67 rader
Skriven 2005-02-24 21:41:00 av C.Verma@gmail.Com (1:278/230)
Ärende: Excel Permission Denied
===============================


I have 8 yrs application that ran on ASP, VB5.0 and Excel97 on
WindowsNT4.0 server. The application is being upgraded and is being
moved to Windows 2003. It is now on OS Win2003,VB6.0, Excel2003,ASP.
Couple of problems (Please note it is ASP application and not ASP.NET
and also the OS is win2003)

ASP page->invokes VB dll->VBDll creates an excel file->Displays excel
in IE.


1) The VB dlls create instances of Excel using the following command:
Public xl As New Excel.Application
Set xl = CreateObject("excel.application")
Say the above got compiled as WebVB.dll and registerd on the server
using regsvr32 D:/webvb.dll

2) ASP page calls the above dll as:
Dim MyExcel
Set MyExcel = CreateObject("WebVB.clsWebVB")


Problem:

I get "Excel Permission denied" error.
My solution:
-In IIS6.0, I set it to Directory Securty|Edit|Integrated account.
- Went to DComcnfg and did following:

1.       From command prompt type "dcomcnfg.exe"

2.       You will see 'Component Management' window

3.       Component Services --> Computer--> My Computer--> DComConfig

4.       From the tree view select 'Microsoft Excel Application'

5.       Right-Click on it & select 'Properties'

6.       From the property window select the 'Security' tab.

7.       Then for all the three options select 'Customize' Radio
button (or according to your need)

8.       Added my account as user account to all the three tabs. "MY
ACCOUNT HAS ADMIN RIGHTS AS WELL!"

9.       Give appropriate permission to them

10.   Then click Apply.

So when I acces the website, it asks for my domain username/password. I
can run the reports which are generated in excel.

I DONt need integrated access to this website. So I leave it as
anonymous account. But obviously with this account, excel file doesn't
get generated and ends up saying permission denied. Even though I gave
priviliges to IUSR_machine name user in DComcnfg, I wasn't able to
create excel report.
Does IUSR_machinename has to be given Admin rights??
Or what is the best solution?



--- UseNet To RIME Gateway @ 2/24/05 9:33:51 PM ---
 * Origin: MoonDog BBS, Brooklyn,NY, 718 692-2498, 1:278/230 (1:278/230)