home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,123 of 19,505   
   Rahul Verma to All   
   Access Denied on sp_OaCreate method   
   20 Nov 14 08:38:19   
   
   From: rahul.girdharwal@gmail.com   
      
   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  (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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca