SQL Replication for SQL 2016

Dear Experts,

Is SQL Transactional Replication for 2016 to another SQL 2016 the same as SQL Transactional Replication for SQL 2012 to another SQL 2012?

If there are any differences, what are they?
LVL 1
Anonymous KHIT EngineerAsked:
Who is Participating?
 
Máté FarkasDatabase Developer and AdministratorCommented:
Log Reader Agent must connect to the database with db_owner role or sysadmin server role.
Try to execute manually in SSMS on publication database:
EXEC sp_replcmds @maxtrans = 100;

Open in new window

0
 
Anonymous KHIT EngineerAuthor Commented:
Distribution and Publication created successfully.

When we start the log agent, we got this message.

the process could not execute 'sp_replcmds' on 'servername'

Is this a permission issue?
0
 
Anonymous KHIT EngineerAuthor Commented:
Hi! Máté Farkas

We used the sa and domain admin account. We added them as sysadmin in the Server Roles.
0
 
Bharat BhushanSolution ManagerCommented:
They're the same. As far as I know, there were no enhancements made in SQL 2016 for replication feature.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.