Hi.
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.
Thx,
RP
Do the options for New database or Refresh Database list show up in the drop down?
You could try running a trace or extended events session on the subscriber server to see what account is connecting to the server. And check the SQL Server logs on both servers. Normally to populate that list, it's just executing:
exec sp_helpreplicationdboption @reserved = 1
on the subscriber.
Sue