21879

Product

Name

Event ID

21879

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

SQLErrorNum21879

Message Text

Unable to query the redirected server ‘%s’ for original publisher ‘%s’ and publisher

database ‘%s’ to determine the name of the remote server; Error %d, Error message ‘%s’.

uses a temporary linked server that it creates to connect to

the redirected publisher in order to discover the name of the remote server. Error 21879 is

returned when the linked server query fails. The call to request the remote server name is

typically the first use of the temporary linked server, so if there are connectivity problems they

are likely to appear first with this call. This remote call simply executes select

at the remote server.

The linked server used to query the redirected publisher uses the security mode, login, and

password supplied when

was called for the original publisher.

If SQL Server authentication was used (security mode 0) then the login and password

specified are used to connect to the remote server.

If Windows authentication was used (security mode 1) a trusted connection is used for

the connection.

ﾉ

Expand table