Error: SQL Replication – Remote Server does not exist, or not designated

by | Oct 13, 2020

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:

“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 has a designated Distribution server. 

Garland MacNeill

Garland MacNeill

Position

I'm a SQL DBA by day, currently working in the Duluth, MN area. My technical interests include SQL Server and SQL development. As I continue to expand my career, my focus is more on development on the SQL platform.
%d bloggers like this: