I am in the middle of an upgrade to SQL server 2012 from 2005, however we want to keep one of our server on SQL 2005 as it has a Database published as a Snapshot replication.
My Question is are we able to do a Push of the Published database into one of our SQL 2012 server ? A pull of the data as a Subscriber works from the SQL 2012 server, however doing a push to the same subscriber SQL 2012 server from the 2005 server does not work.
Main message Error: 14151, Severity: 18, State: 1.
I have tried to set the agents with the same Domain account but still got the same error, so just wondering if the version is the issue here.