New-DbaEndpoint

Want to see the source code for this command? Check out New-DbaEndpoint on GitHub.
Want to see the Bill Of Health for this command? Check out New-DbaEndpoint.

Synopsis

Creates endpoints on a SQL Server instance.

Description

Creates endpoints on a SQL Server instance.

Syntax

New-DbaEndpoint
    [-SqlInstance] <DbaInstanceParameter[]>
    [[-SqlCredential] <PSCredential>]
    [[-Name] <String>]
    [[-Type] <String>]
    [[-Protocol] <String>]
    [[-Role] <String>]
    [[-EndpointEncryption] <String>]
    [[-EncryptionAlgorithm] <String>]
    [[-AuthenticationOrder] <String>]
    [[-Certificate] <String>]
    [[-IPAddress] <IPAddress>]
    [[-Port] <Int32>]
    [[-SslPort] <Int32>]
    [[-Owner] <String>]
    [-EnableException]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

Examples

Example: 1

PS C:\> New-DbaEndpoint -SqlInstance localhost\sql2017 -Type DatabaseMirroring

Creates a database mirroring endpoint on localhost\sql2017 which using the default port

Example: 2

PS C:\> New-DbaEndpoint -SqlInstance localhost\sql2017 -Type DatabaseMirroring -Port 5055

Creates a database mirroring endpoint on localhost\sql2017 which uses alternative port 5055

Example: 3

PS C:\> New-DbaEndpoint -SqlInstance localhost\sql2017 -Type DatabaseMirroring -IPAddress 192.168.0.15 -Port 5055

Creates a database mirroring endpoint on localhost\sql2017 which binds only on ipaddress 192.168.0.15 and port 5055

Required Parameters

-SqlInstance

The target SQL Server instance or instances.

Optional Parameters

-SqlCredential

Login to the target instance using alternative credentials. Accepts PowerShell credentials (Get-Credential).
Windows Authentication, SQL Server Authentication, Active Directory - Password, and Active Directory - Integrated are all supported.
For MFA support, please use Connect-DbaInstance.

-Name

The name of the endpoint. Defaults to hadr_endpoint if type is DatabaseMirroring, has to be provided for other types.

-Type

The type of endpoint. Defaults to DatabaseMirroring. Options: DatabaseMirroring, ServiceBroker, Soap, TSql

-Protocol

The type of protocol. Defaults to tcp. Options: Tcp, NamedPipes, Http, Via, SharedMemory

-Role

The type of role. Defaults to All. Options: All, None, Partner, Witness

-EndpointEncryption

Used to specify the state of encryption on the endpoint. Defaults to required.
Disabled
Required
Supported

-EncryptionAlgorithm

Specifies an encryption algorithm used on an endpoint. Defaults to Aes.
Options are:
AesRC4
Aes
None
RC4
RC4Aes

-AuthenticationOrder

The type of connection authentication required for connections to this endpoint. Defaults to Negotiate.
Options are:
Certificate
CertificateKerberos
CertificateNegotiate
CertificateNtlm
Kerberos
KerberosCertificate
Negotiate
NegotiateCertificate
Ntlm
NtlmCertificate

-Certificate

Database certificate used for authentication.

-IPAddress

Specifies the IP address that the endpoint will listen on. The default is ALL. This means that the listener will accept a connection on any valid IP address.
Currently only IPv4 is supported by this command.

-Port

Port for TCP. If one is not provided, it will be auto-generated.

-SslPort

Port for SSL.

-Owner

Owner of the endpoint. Defaults to sa.

-EnableException

By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.

-WhatIf

Shows what would happen if the command were to run. No actions are actually performed.

-Confirm

Prompts you for confirmation before executing any changing operations within the command.