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.

Example

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