Readme.ge Blog

FB image FB image

MSSQL “Ole Automation Procedures” enable

ავტორი: ალექსანდრე თარიღი: Tuesday, August 2nd, 2011

შეცდომა:

Msg 15281, Level 16, State 1, Procedure sp_OACreate, 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.

“Ole Automation Procedures”-ს ჩართვა:

1
2
3
4
5
6
7
8
9
10
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
sp_configure 'show advanced options', 0;
GO
GO

კატეგორიებში: Linux. |

დატოვე კომენტარი

...