Share your ideas

"Ole Automation Procedures" are obsolete and should be removed from the reporting service

The reporting database free space reports in the Tealeaf Portal require "sys.sp_OACreate" related permissions. However, this is sometimes not possible as the 'sys.sp_OAGetProperty' of component 'Ole Automation Procedures' has been disabled in the security configuration.

This is an old method from the SQL 2000 era when it was hard to get information out of SQL Server. As modern versions have free space information available in the system catalog, can the sp_OA related calls be removed and replaced with something more native to the current SQL server versions?

Related document links:

"sys.sp_OACreate" related permissions : https://www.ibm.com/support/knowledgecenter/en/SS2MBL_9.0.2/cxImpactAdmin/CX/SQLSrvAdmin/AdditionalAdminLoginPermissions_28.html

'sys.sp_OAGetProperty' Disabled: https://www.ibm.com/support/knowledgecenter/en/SS2MBL_9.0.2/Troubleshooting/CX/TblS-TLDB/SQLServerBlocksAccessToProcedureSysSp_OAGetProperty_43.html

  • Guest
  • Feb 28 2020
  • Under consideration
What is your industry? Computer Services
What is the idea priority? Medium