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

Access Denied on sp_OaCreate method

X-Received	by 10.43.153.208 with SMTP id lb16mr9498932icc.12.1416501500668; Thu, 20 Nov 2014 08:38:20 -0800 (PST)
X-Received	by 10.50.66.144 with SMTP id f16mr205926igt.17.1416501500272; Thu, 20 Nov 2014 08:38:20 -0800 (PST)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!h15no4431543igd.0!news-out.google.com!w7ni66qay.0!nntp.google.com!h15no4431533igd.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Thu, 20 Nov 2014 08:38:19 -0800 (PST)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=103.255.224.34; posting-account=4zY8JwoAAAC4_UJCaB2VUQlQVAXhtk49
NNTP-Posting-Host	103.255.224.34
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<a2974e19-5f7b-43dd-9956-b136fb5d5a07@googlegroups.com> (permalink)
Subject	Access Denied on sp_OaCreate method
From	Rahul Verma <rahul.girdharwal@gmail.com>
Injection-Date	Thu, 20 Nov 2014 16:38:20 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.databases.ms-sqlserver:1838

Show key headers only | View raw

Hi,

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.


Highlights:
1. Below is working fine, That's mean sp_configuration properly working
     EXEC @RET = SP_OACREATE 'Scripting.FileSystemObject', @OBJ OUTPUT
2. I am the administrator of the machine.
3. Under Dcom.Config --> COM Security --> "Access Permission" and "Launch and Activation Permission" --> Default security for Administrator is local access and remote access

Regards
Rahul Verma

Back to comp.databases.ms-sqlserver | Previous | Next — Next 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