DistributorSecurityMode Propiedad
SQL Server 2008
Gets or sets the security mode used when connecting locally to the Distributor.
Espacio de nombres: Microsoft.SqlServer.Replication
Ensamblado: Microsoft.SqlServer.Replication (en Microsoft.SqlServer.Replication.dll)
Valor de la propiedad
Tipo: Microsoft.SqlServer.Replication..::..SecurityModeA SecurityMode value that represents the security mode.
Implementa
ISnapshotGenerationAgent..::..DistributorSecurityModeSiempre que sea posible, utilice la autenticación de Windows.
If the value is Standard, the DistributorLogin and DistributorPassword properties must also be specified.
// Set the Publisher, publication database, and publication names. string publicationName = "AdvWorksProductTran"; string publicationDbName = "AdventureWorks"; 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 = "AdventureWorks" 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