Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the security mode used when connecting locally to the Distributor.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Replication (in Microsoft.SqlServer.Replication.dll)
Syntax
'Declaration
Public Property DistributorSecurityMode As SecurityMode
Get
Set
'Usage
Dim instance As SnapshotGenerationAgent
Dim value As SecurityMode
value = instance.DistributorSecurityMode
instance.DistributorSecurityMode = value
public SecurityMode DistributorSecurityMode { get; set; }
public:
virtual property SecurityMode DistributorSecurityMode {
SecurityMode get () sealed;
void set (SecurityMode value) sealed;
}
abstract DistributorSecurityMode : SecurityMode with get, set
override DistributorSecurityMode : SecurityMode with get, set
final function get DistributorSecurityMode () : SecurityMode
final function set DistributorSecurityMode (value : SecurityMode)
Property Value
Type: Microsoft.SqlServer.Replication.SecurityMode
A SecurityMode value that represents the security mode.
Implements
ISnapshotGenerationAgent.DistributorSecurityMode
Remarks
When possible, use Windows Authentication.
If the value is Standard, the DistributorLogin and DistributorPassword properties must also be specified.
Examples
// Set the Publisher, publication database, and publication names.
string publicationName = "AdvWorksProductTran";
string publicationDbName = "AdventureWorks2012";
string publisherName = publisherInstance;
string distributorName = publisherInstance;
SnapshotGenerationAgent agent;
try
{
// Set the required properties for Snapshot Agent.
agent = new SnapshotGenerationAgent();
agent.Distributor = distributorName;
agent.DistributorSecurityMode = SecurityMode.Integrated;
agent.Publisher = publisherName;
agent.PublisherSecurityMode = SecurityMode.Integrated;
agent.Publication = publicationName;
agent.PublisherDatabase = publicationDbName;
agent.ReplicationType = ReplicationType.Transactional;
// Start the agent synchronously.
agent.GenerateSnapshot();
}
catch (Exception ex)
{
// Implement custom application error handling here.
throw new ApplicationException(String.Format(
"A snapshot could not be generated for the {0} publication."
, publicationName), ex);
}
' Set the Publisher, publication database, and publication names.
Dim publicationName As String = "AdvWorksProductTran"
Dim publicationDbName As String = "AdventureWorks2012"
Dim publisherName As String = publisherInstance
Dim distributorName As String = publisherInstance
Dim agent As SnapshotGenerationAgent
Try
' Set the required properties for Snapshot Agent.
agent = New SnapshotGenerationAgent()
agent.Distributor = distributorName
agent.DistributorSecurityMode = SecurityMode.Integrated
agent.Publisher = publisherName
agent.PublisherSecurityMode = SecurityMode.Integrated
agent.Publication = publicationName
agent.PublisherDatabase = publicationDbName
agent.ReplicationType = ReplicationType.Transactional
' Start the agent synchronously.
agent.GenerateSnapshot()
Catch ex As Exception
' Implement custom application error handling here.
Throw New ApplicationException(String.Format( _
"A snapshot could not be generated for the {0} publication." _
, publicationName), ex)
End Try