ReplicationDatabase.QueueReaderAgentProcessSecurity Property

Article
12/03/2008

Gets the Microsoft Windows account under which the Queue Reader Agent job runs at the Distributor.

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Syntax

'Declaration
Public ReadOnly Property QueueReaderAgentProcessSecurity As IProcessSecurityContext

public IProcessSecurityContext QueueReaderAgentProcessSecurity { get; }

public:
property IProcessSecurityContext^ QueueReaderAgentProcessSecurity {
    IProcessSecurityContext^ get ();
}

/** @property */
public IProcessSecurityContext get_QueueReaderAgentProcessSecurity ()

public function get QueueReaderAgentProcessSecurity () : IProcessSecurityContext

Property Value

An IProcessSecurityContext object that specifies the Windows account used by SQL Server Agent when running the Queue Reader Agent.

Exceptions

Exception type	Condition
ApplicationException	When the version is not Microsoft SQL Server 2005 or later. When the Queue Reader Agent has not been upgraded to the SQL Server 2005 replication agent security model. For more information, see Security Considerations for Replication.

ApplicationException

When the version is not Microsoft SQL Server 2005 or later.

When the Queue Reader Agent has not been upgraded to the SQL Server 2005 replication agent security model. For more information, see Security Considerations for Replication.

Remarks

For security reasons, Password is always masked in the return value.

The Windows account specified by the QueueReaderAgentProcessSecurity property is always used by the Queue Reader Agent when connecting locally to the Distributor. For information about the connections that agents make and the permissions that are required for those connections, see Replication Agent Security Model.

The QueueReaderAgentProcessSecurity property can be retrieved by members of the sysadmin fixed server role or by members of the db_owner fixed database role of the published database.

Retrieving the QueueReaderAgentProcessSecurity property is equivalent to executing sp_helpqreader_agent (Transact-SQL).

The QueueReaderAgentProcessSecurity property is available with SQL Server 2005 only.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms