• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

I need help with an error i get while executing a stored proc in SQL server 2012

Hi experts,
I get the following error when running a stored procedure in SQL Server 2012.  How can I fix it?  :

An error occurred while running the SSIS.
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.


Thanks in advance,
mrotor
0
mainrotor
Asked:
mainrotor
  • 2
1 Solution
 
Paul JacksonSoftware EngineerCommented:
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO

Open in new window


http://technet.microsoft.com/en-us/library/ms190693.aspx
0
 
mainrotorAuthor Commented:
Do I have to execute the above in queries in the master database?
0
 
Paul JacksonSoftware EngineerCommented:
Yes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now