Check if acces is blocked for MGET/MPUT

Question

I am trying to use the MPUT/MGET scripts as shown in: https://www.codeproject.com/Articles/1170393/Download-file-s-from-FTP-Server-using-Command-thro But i cant get it to work, is there a way to check if you have enought acces to be able to automate ftp through SQL ?

Answer 1

This script builds OS command and runs it using Sql Server xp_cmdshell system stored proc. To check current permission to run xp_cmdshell run

EXEC sp_configure;

without parameters and find the row with the name = 'xp_cmdshell'. If you need to enable it see how to enable xp_cmdshell.