blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search
Blogs

Stuart Preston's Blog

Mostly about Visual Studio Team System, Team Foundation Server, Engineering Practices and Application Lifecycle Management.

SQL Server 2005: SQL Server blocked access to procedure 'sys.xp_cmdshell' ...

To save some of you from SQL Server 2005 Books Online, this quick bit of SQL will enable xp_cmdshell to execute, if you don't want to use the SQL Server 2005 Surface Area Configuration tool.

Clearly you'll need sa privileges on your SQL instance to run this:

sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO

Published 06 November 2005 12:35 by Stuart.Preston

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Bruno Monteiro said:

Thanks a lot Saved me some reading time :D
July 4, 2007 15:35
 

K Jones said:

Thanks, this was helpful.
September 19, 2007 15:42

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

News







Locations of visitors to this page

© 2008 - Any comments or statements made herein do not necessarily reflect those of Conchango.
Powered by Community Server (Personal Edition), by Telligent Systems