ALTER REMOTE SERVICE BINDING

Define the security credentials used to initiate a conversation with a remote service.

Syntax
      ALTER REMOTE SERVICE BINDING binding
             WITH USER = user_name [ , ANONYMOUS = {ON | OFF} ]  [; ]

Key
   binding     The remote service binding to create.
   user_name   The owner of the certificate associated with the remote service.
   ANONYMOUS   Use anonymous authentication when communicating with the service.

This command is only necessary for initiating services that communicate with target services outside of the SQL Server instance. The certificate for user_name must be valid for login to the remote database.

Examples

ALTER REMOTE SERVICE BINDING MyBinding
    WITH USER = Simon ;

"Service to others is the rent you pay for your room here on earth" - Muhammad Ali

Related commands

CREATE REMOTE SERVICE BINDING
ALTER AUTHORIZATION
DROP REMOTE SERVICE BINDING