Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1839

Re: Access Denied on sp_OaCreate method

Show all headers | View raw

Rahul Verma (rahul.girdharwal@gmail.com) writes:
> Any resolution would be appreciate.
> I have below configuration
> 
> Excel --> 32 bit
> Sql Server --> 32 bit 
>      (
>      Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (Intel X86) 
>           Oct 19 2012 13:43:21 
>           Copyright (c) Microsoft Corporation
>        Enterprise Edition on Windows NT 6.1 <X64> (Build 7601: Service 
> Pack 1) (WOW64)
>      )
> OS window 7 Enterprise (SP1) --> 64 bit
> 
> 
> 
> Getting below error:
> 
> On execution:
> EXEC @RET = SP_OACREATE 'EXCEL.APPLICATION', @OBJ OUTPUT
> 
> Error Message:
> -2147024891
> ODSOLE Extended Procedure
>  Access is denied.
 
I would guess that the service account for SQL Server does not have 
permission to where Excel is installed.

Overall, I cannot say that I am sympathetic to the idea to run Excel 
from SQL Server. Excel does not mind open a window, but SQL Server 
does not have a desktop, so that can could cause confusion. I would 
recommend that you find another solution for whatever you are trying 
to do.


-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Access Denied on sp_OaCreate method Rahul Verma <rahul.girdharwal@gmail.com> - 2014-11-20 08:38 -0800
  Re: Access Denied on sp_OaCreate method Erland Sommarskog <esquel@sommarskog.se> - 2014-11-20 21:59 +0100

csiph-web