CREATE REMOTE SERVICE BINDING

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

Syntax
      CREATE REMOTE SERVICE BINDING binding
         [ AUTHORIZATION owner ] 
            TO SERVICE 'service' 
               WITH USER = user_name [ , ANONYMOUS = { ON | OFF } ]  [; ]

Key
   binding     The remote service binding to create.
   owner       Set the owner of the binding to a database user or role.
   service     The remote service to bind to the USER.
   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.

Examples

CREATE REMOTE SERVICE BINDING MyBinding
    TO SERVICE '//ss64.com/services/DemoService'
    WITH USER = Simon ;

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

Related commands

ALTER REMOTE SERVICE BINDING
DROP REMOTE SERVICE BINDING