I'm having a replication issue on a simple Transactional Repl setup for 2012 PUBLISHER to 2008 SUBSCRIBER.
When I get to the part in the wizard to ADD SUBSCRIBER (in SSMS), it connects to the subscriber (server), BUT, does not list the available databases on the subscriber, even after I create a new one. Neither new or existing databases show up.
Is this a permissions thing? Obviously, it DOES connect to the server, but no dbs on the subscriber server list. (there are about 12 dbs there).
I setup a sql authenticated sysadmin account (same name and pw) on both sides, same permissions. What am I missing?
Please advise asap.