• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

'sys.xp_cmdshell'

 
Yogendra Joshi
Ranch Hand
Posts: 213
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear Sir,

when this error occures

SQL Exception occured while updating Transaction. : [Macromedia][SQLServer JDBC Driver][SQLServer]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.

Rohit.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The error message tells you what the problem is: you don't have access to run sys.xp_cmdshell, and you need to reconfigure your server to allow it.

What were you trying to do? Running sys.xp_cmdshell is not a thing you would normally allow - since it is a call to run an executable on the server, which can be a very dangerous thing to allow.
 
Yogendra Joshi
Ranch Hand
Posts: 213
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, i had to delete some records from one table but it was not allowing to delete me ...but then i made this sys.cmd_shell enable in order to aalow me to delete the records. Actually for SQL server 2005 , this feature is by default disabled and it is recommeded that for the security purpose it shouldn't be enabled. But i just made it enable and the error starts occuring. Anyways thank you for help.

Rohit.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic