To fully support remote logins, Client-Library provides connection properties that enable Component Integration Services to request a server connection. This connection is recognized at the receiving server as a server connection (as opposed to an ordinary client connection), allowing the remote server to validate the connection through the use of sysremotelogins as if the connection were made by a site handler.
Server connections are not enabled automatically. Instead, the SSO or DBA must request it by executing sp_serveroption:
exec sp_serveroption <server_name>, ‘server login’, true | false
You cannot change the server login property if the current server’s @@servername global variable is NULL.
If the server login option is true, then Component Integration Services uses Client-Library connection properties to establish connections to the specified server.
Remote passwords specified by the client application are passed unchanged to the remote server. The use of and rules associated with remote passwords in server logins are identical to those associated with site handler connections.
These connection properties are only established if:
The server option server logi is set to true.
The remote server is configured with server class ASEnterprise.
There is a local server name defined for the Component Integration Services-enabled server (in other words the query select @@servername returns something other than NULL).
