The sp_serveroption system procedure includes the enable login redirection and cluster instance options.
sp_serveroption enable login redirection determines if incoming RPC requests may be sent to another instance in the cluster. The syntax is:
sp_serveroption instance_name, 'enable login redirection', [ true | false ]
where:
instance_name – is the name of the instance for which you are setting enable login redirection. This instance must be included in sysservers, and is automatically included for all instances.
true – means the instance can redirect incoming RPC requests to another instance in the 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.
