Udostępnij za pośrednictwem


Remote Service Bindings

A remote service binding establishes a relationship between a local database user, the certificate for the user, and the name of a remote service. Service Broker uses the remote service binding to provide dialog security for conversations that target the remote service.

Service Broker determines the users for a conversation when a conversation begins, using the information in the database that hosts the initiating service. A conversation that uses dialog security involves four users. Each database must contain a user for the initiator of the conversation and a user for the target of the conversation. The initiator of the conversation is the user that begins the dialog. The remote service binding specifies the user for the target of the conversation. An initiating service can act as PUBLIC in the remote database by specifying ANONYMOUS = ON in the remote service binding.

For more information on Service Broker security, see Security Considerations for Service Broker.

See Also

Other Resources

CREATE CERTIFICATE (Transact-SQL)
CREATE LOGIN (Transact-SQL)
CREATE USER (Transact-SQL)
Security Considerations for Service Broker
CREATE REMOTE SERVICE BINDING (Transact-SQL)
ALTER REMOTE SERVICE BINDING (Transact-SQL)
DROP REMOTE SERVICE BINDING (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance