1. When I ran the script for the first time, I received the following 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.        
      
To resolve it, run the following SQL commands:
USE master
GO
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
2. I then received error:
     SQL Server blocked access to procedure  'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is  turned off as part of the security configuration for this server. A  system administrator can enable the use of 'xp_cmdshell' by using  sp_configure. For more information about enabling 'xp_cmdshell', see  "Surface Area Configuration" in SQL Server Books Online.      
    
To resolve it, run the following SQL commands:
USE master
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'show advanced options', 0
GO
 
 
Комментариев нет:
Отправить комментарий