Friday, December 20, 2013

Msg 15281, Level 16, State 1, Line 1 (The configuration option 'sys.sp_OACreate' does not exist, or it may be an advanced option.)


Scenario:

I was trying to use OLE automation stored procedure "sp_OACreate" for calculating size of the folders and got following error. Use below script to enable "Ole Automation Procedures" using "sp_configure" option. I hope that will help others.


Msg 15281, Level 16, State 1, Line 1

SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ole Automation Procedures' by using sp_configure. For more information about enabling 'Ole Automation Procedures', see "Surface Area Configuration" in SQL Server Books Online.


Resolution:

Use master
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ole Automation Procedures', 1
GO
RECONFIGURE



Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Configuration option 'Ole Automation Procedures' changed from 0 to 1. Run the RECONFIGURE statement to install.


1 comment:

  1. Hobbyists Berat Hakan Sa─člam and Robert Allison touched the legend and recreated the spectacular Dark Lord collectible figurines on their 3D printers. Berat even added lights to the One Ring and the eyes hidden beneath the horned helmet. Enthusiast Karyn Cini dropped at life an impressively detailed Flash 3D printing figurine, and you are able to to} do} the identical by getting Flash STL information on Gambody – Premium 3D printing marketplace. The list of amazing 3D prints consists of villains and demons, with Lord of Darkness standing out among the many cool Freediving Wetsuits For Women evil beings with absolute charisma. The grasp of the “Legend” underworld’s facial expression makes it must-add 3D printed things to your collection. Some persons are followers of desktop computer systems, and others love laptops.

    ReplyDelete