Enable xp_cmdshell

Posted: May 12, 2011 in SQL Server 2005

By default, xp_cmdshell is disabled in SQL Server for security reasons. You can run the following script to enable this option:

EXEC master.dbo.sp_configure 'show advanced options', 1
GO

RECONFIGURE
GO

EXEC master.dbo.sp_configure 'xp_cmdshell', 1
GO

RECONFIGURE
GO
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s