Interesting behaviour when programmatically manage avail groups with SMO+PS

• basaj

  Grasshopper

  Points: 13

  More actions

  February 18, 2022 at 7:10 pm

  #3985547

  It can make failover even if the user who runs the PS has only Connect SQL permission.

  What's more it can alter availability group with view server state which not comply with the ms official description:

  https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-availability-group-permissions-transact-sql?view=sql-server-ver15

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  February 19, 2022 at 8:10 pm

  #3985868

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• September 6, 2022 at 7:03 am

  This was removed by the editor as SPAM