question

ujjwa_jain avatar image
ujjwa_jain asked

Data Access option getting false for subscriber Linked server when calling "sp_addsubscription " from publisher end in SQL server 2019

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






replicationsqlservertransactional-replicationsqlbrowsertransactional replication
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.