Before the call sp_addsubscription I can see "Data Access" option is true for Subscriber linked server at publisher but when I call for adding subscription with below call:
exec sp_addsubscription @publication = @n, @article = N'all', @subscriber = @svr, @destination_db = @db, @sync_type = N'replication support only', @update_mode = N'read only', @offloadagent = 0, @dts_package_location = N'distributor', @loopback_detection = 'true'
After the I can check "Data Access" option getting false for subscriber linked server at publisher in sql server 2019 , I want to confirm is there anything wrong with "sp_addsubscription" call or do I need to change publisher and subscriber server system configuration?
Please help me out solve this problem
