Server.Endpoints Property

Represents a collection of Endpoint objects. Each Endpoint object represents an endpoint defined on the instance of Microsoft SQL Server.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public ReadOnly Property Endpoints As EndpointCollection
public EndpointCollection Endpoints { get; }
public:
property EndpointCollection^ Endpoints {
    EndpointCollection^ get ();
}
/** @property */
public EndpointCollection get_Endpoints ()
public function get Endpoints () : EndpointCollection

Property Value

An EndpointCollection object that represents all the endpoints defined on the instance of SQL Server.

Remarks

Updated text:

Updated text:

The Endpoint class is used to manage connections over the network for SQL Server services. These include database mirroring, Service Broker, Transact-SQL, and SOAP requests, which are also referred to as the payload types.

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

Example

'Set up a database mirroring endpoint on the server before setting up a database mirror.
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Define an Endpoint object variable for database mirroring.
Dim ep As Endpoint
ep = New Endpoint(srv, "Mirroring_Endpoint")
ep.ProtocolType = ProtocolType.Tcp
ep.EndpointType = EndpointType.DatabaseMirroring
'Specify the protocol ports.
ep.Protocol.Http.SslPort = 5024
ep.Protocol.Tcp.ListenerPort = 6666
'Specify the role of the payload.
ep.Payload.DatabaseMirroring.ServerMirroringRole = ServerMirroringRole.All
'Create the endpoint on the instance of SQL Server.
ep.Create()
'Start the endpoint.
ep.Start()
Console.WriteLine(ep.EndpointState)

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

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

See Also

Reference

Server Class
Server Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

How to: Create a Database Mirroring Endpoint Service in Visual Basic .NET
Using Collections
Implementing Endpoints
Managing Servers

Change History

Release

History

Changed content:
  • Removed the database mirroring disclaimer from the Endpoints property of the Server class.

Release

History

New content:
  • Added code sample to the Example section.

  • Added to the description in the Remarks section.