SnapshotGenerationAgent.PublisherSecurityMode Property
Gets or sets the security mode used when connecting to the Publisher.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Replication (in Microsoft.SqlServer.Replication.dll)
Syntax
'Declaration
Public Property PublisherSecurityMode As SecurityMode
Get
Set
'Usage
Dim instance As SnapshotGenerationAgent
Dim value As SecurityMode
value = instance.PublisherSecurityMode
instance.PublisherSecurityMode = value
public SecurityMode PublisherSecurityMode { get; set; }
public:
virtual property SecurityMode PublisherSecurityMode {
SecurityMode get () sealed;
void set (SecurityMode value) sealed;
}
abstract PublisherSecurityMode : SecurityMode with get, set
override PublisherSecurityMode : SecurityMode with get, set
final function get PublisherSecurityMode () : SecurityMode
final function set PublisherSecurityMode (value : SecurityMode)
Property Value
Type: Microsoft.SqlServer.Replication.SecurityMode
A SecurityMode value that represents the security mode.
Implements
ISnapshotGenerationAgent.PublisherSecurityMode
Remarks
When possible, use Windows Authentication.
If the value is Standard, the PublisherLogin and PublisherPassword 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