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.

Example

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


© Copyright SS64.com 1999-2014
Some rights reserved