The sp_serveroption system procedure includes the enable login redirection and cluster instance options.
enable login redirection determines if RPC requests are sent to another cluster. The syntax is:
sp_serveroption server_name, 'enable login redirection', [ true | false ]
where:
server_name – is the name of the remote server for which you are setting enable login redirection. This remote server must be included in sysservers.
true – means the instance can redirect RPC requests to another cluster.
false – means the instance cannot redirect RPC requests.
By default, enable login redirection is enabled. (You must have the sa_role to run sp_serveroption.)
cluster instance identifies sysservers entries that store instance information, where instance_name is the name of the instance you are adding.
sp_serveroption instance_name, 'cluster instance', [ true | false ]
By default, cluster_instance is disabled (set to false) for each remote server.
The
Cluster Edition automatically manages the sysservers rows
for instances in the local cluster. You need not manually set or
clear the cluster instance flag.
