SQL Replication Issue

Question

hello,

I want to use SQL replication, for that I have created distributer and publisher but when i am going to add subscription it is unable to login to new SQL.

Answer 1

The account specified for the connection should only be granted permission to insert, update, and delete data on the views that replication creates in the publication database; it should not be given any additional permissions. Grant permissions on views in the publication database that are named in the form syncobj_<HexadecimalNumber> to the account you configured at each Subscriber.

See more info at https://learn.microsoft.com/en-us/sql/relational-databases/replication/security/view-and-modify-replication-security-settings?view=sql-server-ver16