Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • 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.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!