MSBI Tutor

Error: 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. [SQLSTATE 42000] (Error 15281). The step failed. Solution: As I don’t have access to Server to change configuration settings I executed below 3 statements in SQL server 2008 where i received the error. sp_configure ‘show advanced options’, 1 GO RECONFIGURE; GO sp_configure ‘Ole Automation Procedures’, 1 GO RECONFIGURE; GO sp_configure ‘show advanced options’, 1 GO RECONFIGURE;

The health and safety of Microsoft’s customers, partners, suppliers and employees is a top priority, and our heartfelt concern and best wishes are with those who have been affected by the current novel coronavirus (COVID-19) situation. As we continue to follow global health authority guidance, we are committed to supporting the international efforts to contain the outbreak and will take precautionary steps, as warranted. As a result, Microsoft is cancelling the Microsoft Ignite The Tour Bengaluru conference, originally scheduled to take place at the LaLiT Ashok on April 8-9, 2020.