Enabling Ole Automation Procedures
When you want to initilise a com component (sp_OACreate) or call a method (sp_OAMethod) of com component we have to use Ole Automation Procedures.
If we use those procedures we get error like
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.
This is because by default Ole Automation Procedures are disabled for security reasons. To avoid this error we need to enabled Ole Automation Procedures.
Lets see steps for enabling Ole Automation Procedures
1. Open SQL Server Surface Area Configuration tool from
start menu > program files > Microsoft SQL Server 2005 > Configuration Tools
2. Open Surface Area Configuration for Features
3. Select OLE Automation and check the box Enable OLE Automation
4. Click Apply
Now you can use Ole Automation Procedures
Madhu :-)
Labels: sql server 2005
