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

Re: Access Denied on sp_OaCreate method

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news.swapon.de!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Access Denied on sp_OaCreate method
Date	Thu, 20 Nov 2014 21:59:19 +0100
Organization	Erland Sommarskog
Lines	39
Message-ID	<XnsA3EBDFAE5F981Yazorman@127.0.0.1> (permalink)
References	<a2974e19-5f7b-43dd-9956-b136fb5d5a07@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx02.eternal-september.org; posting-host="416ef8a880b1e4f6f96e9a7c39a8d7a9"; logging-data="32115"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/p3Iy7MNfEithNNFdMwwvl"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:xsfrSgSPceFyySkO7v37s/XeMgk=
Xref	csiph.com comp.databases.ms-sqlserver:1839

Show key headers only | 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