locked
I am trying to make snapshot replication but unable to make RRS feed

All replies

  • User991499041 posted

    Hi maddy1460,

    I am trying to snapshot replication in SQL 2014 but unable to make I have made the distributer , local publication as well as location subscription but unable to replicate the data other new instance  sql, please see the screen cast

    Unable to view the second link.

    Replication can only use SQL Server authentication logins to connect to SQL Database.

    Replicated table must have a primary key.

    Replication management, monitoring, and troubleshooting must be performed from the on-premises SQL Server.

    may there be permission issue please provide the help briefly 

    There is a PAL (Publication access list), to which if you add the user, he will have the necessary permissions to use the publication. For details, see Security Role Requirements for Replication.

    Regards,

    zxj

    Thursday, June 1, 2017 6:20 AM