How to: Configure Initiating Services for Anonymous Dialog Security (Transact-SQL)

uses dialog security for any conversation to a service for which a remote service

binding exists. If the database that hosts the target service doesn’t contain a user that

corresponds to the user that created the dialog, the dialog uses anonymous security.

1. Obtain a certificate for a user in the remote database from a trusted source.

2. Create a user without a login.

3. Install the certificate for the remote service. The user created in step 3 owns the

certificate. By default the certificate is active for.

4. Create a remote service binding that specifies the user and the target service. For

anonymous dialog security, the remote service binding specifies.

This example configures anonymous dialog security for conversations between the service

named

in the current instance and the service named

in the

remote instance.

７

Note

Only install certificates from trusted sources.

７

Note

The code samples in this article were tested using the

sample

database, which you can download from the

home page.

BEGIN DIALOG
ANONYMOUS = ON
OrderParts
SupplierOrders
AdventureWorks2022