Tips, Hints and Troubleshooting
SQL Server xp_cmdshell Error
Applies to: | |
All versions of Carmen with SQL Server database. | |
Issue: | |
When attempting to create or modify a library an error is displayed that says "SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' … | |
Cause: | |
Carmen requires that the extended procedure 'xp_cmdshell' be enabled. This component is disabled by default in SQL Server 2005 and later. | |
Resolution: | |
Copy, paste then run this script into SQL Server Query to turn on xp_cmdshell: USE master GO EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE WITH OVERRIDE GO EXEC sp_configure 'xp_cmdshell', 1 GO RECONFIGURE WITH OVERRIDE GO EXEC sp_configure 'show advanced options', 0 GO |