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 | |
