Re: SQL server 2008 service: access to Excel object model

David Walker (none@xxxxxxxx) writes:
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?

I'm not sure that I understand where SQL 2008 comes into the
picture. But calling Excel from a service seems dubious to me. Excel
usually likes to have a desktop, and services do not have a desktop.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • SQL server 2008 service: access to Excel object model
    ... We have a situation where a service, which is running as a domain user, ... We have already checked to make sure that Excel has been told to allow ... access to the Excel/VBA object model, ... The code that's doing the calling is C#. ...
    (microsoft.public.sqlserver.security)
  • Re: Cant get SQL INSERT code to work
    ... I'm not sure you can use SQL to add data to an Excel file from another ... From Access Help file (covers JET SQL): ... ' Create the connection string. ... > 'Excel file and modify the SQL statement to fit your data. ...
    (microsoft.public.access.queries)
  • RE: Macro
    ... Then post the query results. ... My data is in an Excel file called ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ... VBA code in excel suddenly became un-compileable. ...
    (microsoft.public.excel.programming)
  • Re: Question for Joe Fallon--determining Data type
    ... then the data type for the column will be Text. ... means 255 characters max (that's a Jet limit). ... where MSDE or SQL Server is the main database (in these cases Jet ... Is 'Spreadsheet' an MS euphemism for 'Excel' or does it support other ...
    (microsoft.public.access.externaldata)
  • Re: Excel Sheets Opens Itself Again After ADO Query ! Please Help
    ... I'm using Excel 2003 so hopefully its similar to your setup. ... You should then be asked for the workbook to query ... You should see a SQL button now where you can edit the ... Hope this opens the discussion more. ...
    (microsoft.public.excel.programming)
Quantcast