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

Access Denied on sp_OaCreate method

Newsgroups	comp.databases.ms-sqlserver
Date	2014-11-20 08:38 -0800
Message-ID	<a2974e19-5f7b-43dd-9956-b136fb5d5a07@googlegroups.com> (permalink)
Subject	Access Denied on sp_OaCreate method
From	Rahul Verma <rahul.girdharwal@gmail.com>

Show all headers | 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