Check the documentation on the setup and ensure that the features you are after using are actually generally available, otherwise you may need to use public preview

Failback is a preview...

SQL MI Link uses DAGs instead of AG's to extend your on-prem AG to SQLMI.

If you're attempting to extend the AG normally like you would with just adding a replica...

You will need to split out one of those strings into its constituent parts.

You should have an element which is something like

Servername.database.windows.net

This would be what you put in the server...

You need to get the full error message to see what the connection problem is.

So either browse the report on the report server or enable remote errors, it will give...

SMO should be version agnostic.

Can you use DBATools at all instead of writing your own PowerShell?

A combination of Get-DbAvailabilityGroup and Export-DbaScript would be my way to do it rather than...

You have a Kerberos issue, ensure all the SPN's are setup, delegation is setup and all the user mappings are setup correctly.

Well if it's dev deal with the pain but its a CREATE INSERT DROP RENAME process.

Otherwise don't do it, doing it is not trivial at all.

If I may ask why is it so important that they are in alphabetical order?

What's going to happen the next time an alter column is run and its an "N"...

No you need to MDF and LDF or a backup.

You will need to create a blank DB using the schema script, but all your data is lost.

First off is, does this audit need to be legally binding?

Do you need to stand in a court of law and unequivocally say, Person X did actions, A,B,C and I...

500 - Internal server error

Something hasn't been configured right.

Re-run install

Re-run the configuration manager

Ensure everything is setup right and try again

Increase the lease timeout, or change your HA/DR technology or change your backup technology.

but if after failover the listener isn’t working you got bigger issues you need to fix and...

CMS data is stored in MSDB.

As MSDB isn't part of an AG, setting up a CMS on an AOAG is impossible (I mean you could register it against the listener...

If you set failover to manual, then one replica will always be primary unless you manually force a failover.

Kind of negates the point of having an AG if you're removing...

Open a case with MSFT and send them the dumps to analyse whats going on.

Although this is worrying

2023-09-26 16:14:10.60 Server      Timeout waiting...