Don’t forget to check permissions
Here’s a quick post to remind myself and others, to check ALL of the permissions when working with replication.
For the past couple of days, I’ve been working on getting transactional replication set up between a couple of servers in between other projects I’ve been working on. For the last day I kept running into the following error:
1
“The remoter server <“server name”> does not exist, or has not been designated as a valid Publisher, or you may not have permissions to see available Publishers. ”
Make sure the account for the log_reader has dbo access to the distribution database. I missed that, given that the other system we use for replication is a designated Distribution server