In this recipe, we will grant the CONNECT
permission to an existing SQL Server principle.
Identify the SQL Server principle that you will use for AlwaysOn that will need the CONNECT
permission.
Perform the following steps to grant the CONNECT
permission to an endpoint:
Open PowerShell ISE as an administrator.
Add the following script and run it:
Import-Module SQLPS -DisableNameChecking $instanceName = "SQL01" $endpointName = "AlwaysOnEndpoint" $endpointAccount = "QUERYWORKS\sqlservice" $server = New-Object Microsoft.SqlServer.Management.Smo.Server $instanceName $endpoint = $server.Endpoints[$endpointName] #identify the Connect permission object $permissionSet = New-Object Microsoft.SqlServer.Management.Smo.ObjectPermissionSet([Microsoft.SqlServer.Management.Smo.ObjectPermission]::Connect) #grant permission $endpoint.Grant($permissionSet,$endpointAccount)