ReplicationDatabase.QueueReaderAgentProcessSecurity Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets the Microsoft Windows account under which the Queue Reader Agent job runs at the Distributor.
public:
property Microsoft::SqlServer::Replication::IProcessSecurityContext ^ QueueReaderAgentProcessSecurity { Microsoft::SqlServer::Replication::IProcessSecurityContext ^ get(); };
public Microsoft.SqlServer.Replication.IProcessSecurityContext QueueReaderAgentProcessSecurity { get; }
member this.QueueReaderAgentProcessSecurity : Microsoft.SqlServer.Replication.IProcessSecurityContext
Public ReadOnly Property QueueReaderAgentProcessSecurity As IProcessSecurityContext
Property Value
An IProcessSecurityContext object that specifies the Windows account used by SQL Server Agent when running the Queue Reader Agent.
Exceptions
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 and Protection (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).