Viewing SQL Endpoint Permissions with PowerShell

A quick and simple post today as I have been very busy. I needed to list the users with permissions on mirroring endpoints today so I wrote this script and figured it was worth sharing.

It’s a simple script which takes a server name from a Read-Host prompt. Displays the available endpoints and asks which one you want and shows you the permissions

and heres a screenshot of the results

Ps`1If you want to do it with T-SQL

image


Please feel free to comment on this post. All comments are moderated first before appearing on the site