database-mirroring-always-on-availability-groups-powershell.md

title	Powershell: Availability group database mirroring endpoint
description	Describes how to create a database mirroring endpoint for an Always On availability group using PowerShell.
author	MashaMSFT
ms.author	mathoma
ms.date	05/17/2016
ms.service	sql
ms.subservice	availability-groups
ms.topic	how-to
helpviewer_keywords	Availability Groups [SQL Server], server instance Availability Groups [SQL Server], deploying Availability Groups [SQL Server], endpoint

Create a database mirroring endpoint for an availability group using PowerShell

[!INCLUDE SQL Server]

This topic describes how to create a database mirroring endpoint for use by [!INCLUDEssHADR] in [!INCLUDEssnoversion] by using PowerShell.

Permissions

Requires CREATE ENDPOINT permission, or membership in the sysadmin fixed server role. For more information, see GRANT Endpoint Permissions (Transact-SQL).

Important

The RC4 algorithm is deprecated. [!INCLUDEssNoteDepFutureAvoid] We recommend that you use AES.

Using PowerShell

To create a database mirroring endpoint

1. Change directory (cd) to the server instance for which you want to create the database mirroring endpoint.

2. Use the New-SqlHadrEndpoint cmdlet to create the endpoint and then use the Set-SqlHadrEndpoint to start the endpoint.

Example (PowerShell)

The following PowerShell commands create a database mirroring endpoint on an instance of SQL Server (Machine\Instance). The endpoint uses port 5022.

Important

This example works only on a server instance that currently lack a database mirroring endpoint.

# Create the endpoint.  
$endpoint = New-SqlHadrEndpoint MyMirroringEndpoint -Port 5022 -Path SQLSERVER:\SQL\Machine\Instance  
  
# Start the endpoint  
Set-SqlHadrEndpoint -InputObject $endpoint -State "Started"  
  

Related Tasks

To Configure a Database Mirroring Endpoint

• Create a Database Mirroring Endpoint for Windows Authentication (Transact-SQL)

• Use Certificates for a Database Mirroring Endpoint (Transact-SQL)

  • Allow a Database Mirroring Endpoint to Use Certificates for Outbound Connections (Transact-SQL)

  • Allow a Database Mirroring Endpoint to Use Certificates for Inbound Connections (Transact-SQL)

• Specify a Server Network Address (Database Mirroring)

• Specify the Endpoint URL When Adding or Modifying an Availability Replica (SQL Server)

To View Information About the Database Mirroring Endpoint

• sys.database_mirroring_endpoints (Transact-SQL)

See Also

Create an Availability Group (Transact-SQL)
Overview of Always On Availability Groups (SQL Server)