CODEWITHSUNDEEP
sql-servermget
Richard_2413
Richard_2413

Reputation: 119

Check if acces is blocked for MGET/MPUT

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 ?

Upvotes: 0

Views: 89

Answers (1)

Serg
Serg

Reputation: 22811

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.

Upvotes: 0

Related Questions