OLE Automation 2

[Apollo21]

How do I enable the OLE Automation in SQL Server 2000, running on a Windows server 2003 operating system?

I found the following from the WEB for SQL Server 2005 ...

Use the Ole Automation Procedures option to specify whether OLE Automation objects can be instantiated within Transact-SQL batches. This option can also be configured using the Surface Area Configuration tool. For more information, see Surface Area Configuration.

The Ole Automation Procedures option can be set to the following values.

0
OLE Automation Procedures are disabled. Default for new instances of SQL Server 2005.

1
OLE Automation Procedures are enabled.

When OLE Automation Procedures are enabled, a call to sp_OACreate will start the OLE shared execution environment.

The current value of the Ole Automation Procedures option can be viewed and changed by using the sp_configure system stored procedure.

Examples

The following example shows how to view the current setting of OLE Automation procedures.


EXEC sp_configure 'Ole Automation Procedures';
GO
The following example shows how to enable OLE Automation procedures.


sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO


I attempted the above with a result of an error whenever I execute the "sp_configure 'Ole Automation Procedures', 1;" command. Any help would be appreciated.

Thank you in Advance;
Apollo21

 

[gmmastros]

Did you notice this part from Books On Line:

Permissions
Execute permissions on sp_configure with no parameters, or with only the first parameter, default to all users. Execute permissions for sp_configure with both parameters, used to change a configuration option, default to the [!]sysadmin[/!] and [!]serveradmin[/!] fixed server roles. RECONFIGURE permissions default to the sysadmin fixed server role and serveradmin fixed server role, and are not transferable.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLBill]

As George said.....do you have the permissions to do the configure?

Also, what error did you get? Knowing that would be very helpful in aiding us to resolving this.

FYI-most reconfigure commands require the SQL Server services to be restarted to take effect.

-SQLBill

Posting advice: FAQ481-4875

 

[Apollo21]

The error message is as follows...
Which comes right after this command is executed.

sp_configure 'Ole Automation Procedures', 1;



Server: Msg 15123, Level 16, State 1, Procedure sp_configure, Line 79
The configuration option 'Ole Automation Procedures' does not exist, or it may be an advanced option.

Valid configuration options are:


Thank you.

 

[gmmastros]

Configuring 'Ole Automation Procedures' only works with SQL 2005.

I think (but am not sure) that you don't need to configure this for sql 2000.

With sql 2000, you MUST be a member of sysadmin to run the ole automation functions (sp_OACreate, sp_OADestroy, etc...).

I hope this helps.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom