To establish the security model for RPCs, use sp_serveroption. The syntax is:
sp_serveroption server, optname, [true | false]
To establish the security model, set optname to rpc security model A or rpc security model B. server names the remote server.
For example, to set model B for remote server TEST3, execute:
sp_serveroption test3, "rpc security model B", true
The default model is “A,” that is, remote procedure calls are handled the same as in previous versions. No server options need to be set for model A.
