SQL server 2008 service: access to Excel object model

We have a situation where a service, which is running as a domain user,
gets an HResult of 0x800A03EC when calling the Excel 2003 object model,
only when actually running as a service.

The same code, when running as a console app, works fine.

We have already checked to make sure that Excel has been told to allow
access to the Excel/VBA object model, per KB article 282830. We made this
setting change while logged on as the domain user that the service runs
under. We stopped and restarted the service to make sure no registry
entries were cached or anything like that.

Are there more security checks that a *service* has to go through, like
policy settings, which apply to a service, that don't cause a failure when
running as a console application?

The code that's doing the calling is C#.

Thanks a bunch for any suggestions.


David Walker
.

Relevant Pages

  • Re: SQL server 2008 service: access to Excel object model
    ... We have already checked to make sure that Excel has been told to allow ... access to the Excel/VBA object model, ... I'm not sure that I understand where SQL 2008 comes into the ... But calling Excel from a service seems dubious to me. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL server 2008 service: access to Excel object model
    ... We have already checked to make sure that Excel has been told to ... allow access to the Excel/VBA object model, ... We made this setting change while logged on as the domain user that ... But calling Excel from a service seems dubious to me. ...
    (microsoft.public.sqlserver.security)
  • Re: Opening/Running Word from Excel
    ... application SELECTION applies. ... Since both Word and Excel object models ... Much better would be to work with Word's object model and avoid ... Dim wrdApp As Word.Application ...
    (microsoft.public.word.vba.general)
  • Re: what is the status "Hidden" in MSDN (it means deprecated)
    ... The Excel 2007 object model has many new methods and properties. ... Although no difference in this example, with many other format properties ... pa dot format dot fill dot OneColorGradient ...
    (microsoft.public.excel.programming)
  • Re: Application.Calculation = xlCalculationAutomatic
    ... If you are using the function as a UDF by calling it from an Excel formula ... in a cell the statement will be ignored (because UDFs are not allowed to ...
    (microsoft.public.excel)