The SQLServer remote server does not exist. It is not specified as a valid Publishing Server, or you do not have permission to view available publishing servers. sqlserver does not exist.

The SQLServer remote server does not exist. It is not specified as a valid Publishing Server, or you do not have permission to view available publishing servers. sqlserver does not exist.

When a transaction release is created and an error occurs during initialization, view the agent information as follows:

Log Reader Agent error:

Status: 0, code: 20015, text: 'remote server "serverName" does not exist, is not specified as a valid Publishing Server, or you are not authorized to view available publishing servers. '.
The remote server "serverName" does not exist. It is not specified as a valid Publishing Server, or you are not authorized to view available publishing servers.

Snapshot proxy error:

Exception message: the remote server "serverName" does not exist. It is not specified as a valid Publishing Server, or you are not authorized to view available publishing servers.

UserDomain \ User. The replication proxy encountered a problem. For more information, see the previous job step history message or copy monitor .. This step fails.

Executed as user nt authority \ network service. Truncates string or binary data. [SQLSTATE 22001] (error 8152). This step fails.

Distribution agent error:

Startup Delay: 1042 (msecs)
Connecting to distributor "serverName"
The proxy message code is 14080. The remote server "serverName" does not exist. It is not specified as a valid Publishing Server, or you are not authorized to view available publishing servers.

The configuration should not be wrong, and the proxy job owner should also change to "sa", which may be a permission issue!

Solution:

1. This UserDomain \ UserIs the user who executes the proxy and grants the user server role:Sysadmin

EXEC master. dbo. sp_addsrvrolemember @ loginame = domain \ User ', @ rolename = n'sysadmin' GO

2. Right-click Publish attribute and click Publish access listTo add the user to it.

3. reinitialize. Normal !~