SQL Server remote servers do not exist, are not designated as valid publishers, or you do not have permission to view available publishers

Original: SQL Server remote servers do not exist, are not designated as valid publishers, or you do not have permission to view available publishers

A transactional publication was created and an error occurred during initialization to view the relevant proxy information as follows:

Log Reader Agent error:

Status: 0, Code: 20015, Text: ' Remote server ' serverName ' does not exist, is not specified as a valid publisher, or you do not have permission to view the available publishers. ‘。
The remote server "ServerName" does not exist, is not specified as a valid publisher, or you do not have permission to view the available publishers.

Snapshot Agent Error:

Exception message: The remote server "ServerName" does not exist, is not specified as a valid publisher, or you do not have permission to view the available publishers.

Executed as user domain \ user . The replication agent is experiencing problems.  For more information, see the previous job step history message or Replication Monitor: The step failed.

Executed as user NT Authority\Network SERVICE. string or binary data is truncated. [SQLSTATE 22001]  (Error 8152). The step failed.

Distribution Agent Error:

Startup delay:1042 (msecs)
Connecting to distributor "ServerName"
Agent Message Code 14080. The remote server "ServerName" does not exist, is not specified as a valid publisher, or you do not have permission to view the available publishers.

Configuration should not be wrong, agent job owner also changed to "sa", may be the issue of permissions!

Workaround:

1. The user domain \ User is the user executing the agent, and the user server role is granted to the sysadmin

EXEC master.dbo.sp_addsrvrolemember @loginame = domain \ user ', @rolename = N ' sysadmin ' GO

2. Right-click Publish Properties,  Publish Access Lists, add the user to it.

3. Re-initialized, normal! ~

SQL Server remote servers do not exist, are not designated as valid publishers, or you do not have permission to view available publishers