Hello all,
I invested a lot of time to get following configuration to run:
Ubuntu 22.04 server “linux01”
Docker container with SQL 2019 “sql2019”.
Datapath is connected to a volume on the Ubuntu server and this path is also available with full access from the Windows workstations.
All databases are reachable with SMM and other applications from the windows PC as “linux01/sql2019, 1433”
I have created a running publication “Repl_Pictures” and snapshot is created in datapath/ReplData and reachable from the windows pc
First I tried to create the Subscription with SSM 19.2. There I got the error “Property password cannot be changed or read after a connection string has been set”
After some searches I found that this is an issue with SSM 19.2
I downgraded to SSM 18.12 an there creating new subscriptions runs well
With “View Synchronization status” I found failure “The process could not connect to distributor ‘sql2019’”
No idea why it was only “sql2019” and not full naming
So I tried to create the create the subscription with sql
on Linux01/sql2019, 1433
use [Pictures]
exec sp_addmergesubscription @publication = N'Repl_Pictures', @subscriber = N'WinPC\SQL2019', @subscriber_db = N'Repl_Pictures', @subscription_type = N'pull', @subscriber_type = N'local', @subscription_priority = 0, @sync_type = N'Automatic'
GO
and on WinPC\SQL2019
use [Repl_Pictures]
exec sp_addmergepullsubscription @publisher = N'linux01\sql2019,1433', @publication = N'Repl_Pictures', @publisher_db = N'Pictures', @subscriber_type = N'Local', @subscription_priority = 0, @description = N'', @sync_type = N'Automatic'
exec sp_addmergepullsubscription_agent @publisher = N'linux01\sql2019,1433', @publisher_db = N'Pictures', @publication = N'Repl_Pictures', @distributor = N'linux01\sql2019,1433', @distributor_security_mode = 0, @distributor_login = N'sa', @distributor_password = N'mypassword', @enabled_for_syncmgr = N'False', @frequency_type = 64, @frequency_interval = 0, @frequency_relative_interval = 0, @frequency_recurrence_factor = 0, @frequency_subday = 0, @frequency_subday_interval = 0, @active_start_time_of_day = 0, @active_end_time_of_day = 235959, @active_start_date = 20231226, @active_end_date = 99991231, @alt_snapshot_folder = N'', @working_directory = N'', @use_ftp = N'False', @job_login = null, @job_password = null, @publisher_security_mode = 0, @publisher_login = N'sa', @publisher_password = null, @use_interactive_resolver = N'False', @dynamic_snapshot_location = null, @use_web_sync = 0
GO
Now I get the failure message “The remote server “pc01-server\sql2019,1433” does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers.”
Has anybody an idea how to solve this?
regards
Lars