0

I've created a publisher that uses FTP snapshot delivery method using SSMS. However, when I tried to configure Subscriber, I couldn't find option to use FTP credentials.

I read "To create a pull subscription to a snapshot or transactional publication that uses FTP snapshot delivery" section in How to: Deliver a Snapshot Through FTP (Replication Transact-SQL Programming) and steps provided are for script.

I was wondering, if this can be achieved from SSMS, rather running it as script.

Thanks in advance.

Ash
  • 1,180
  • 3
  • 22
  • 36
  • 1
    As I understand, if you use SSMS, you just need to config it at publisher side only. For more information: [Deliver a Snapshot Through FTP](https://learn.microsoft.com/en-us/sql/relational-databases/replication/publish/deliver-a-snapshot-through-ftp) – Nghi Ho Apr 06 '17 at 08:25
  • Thank you for the comment blue qn. After creating subscription through wizard, I generated script of it. It shows as follows: – Ash Apr 07 '17 at 02:08
  • `exec sp_addpullsubscription_agent @publisher = N'MyServer', @publisher_db = N'PubDb', @publication = N'Myrep_demo', @distributor = N'MyServer', @distributor_security_mode = 1, @distributor_login = N'', @distributor_password = null, @enabled_for_syncmgr = N'False', @frequency_type = 64, @frequency_interval = 0, @frequency_relative_interval = 0, @alt_snapshot_folder = N'', @working_directory = N'', @use_ftp = N'True', @job_login = null, @job_password = null, @publication_type = 0` I wonder, how it connects to publisher if it doesn't use FTP without username and password. – Ash Apr 07 '17 at 02:14
  • As I know, it will connect to publication and get ftp information. – Nghi Ho Apr 07 '17 at 10:20

0 Answers0